Skip to Content

Data Manager

Under Create or Edit Analytic data

Data type(database), I can only see underlying database connections.

In the tutorial document it shows other types such as Excel files , MS access database

what do I need to get an expanded list

page 11 of the SAP PA Automated Tutoral Data manager

regards

Nicholas Wright

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 05 at 11:17 AM

    Hello Nicholas,

    The screen you are on shows all available ODBC sources on your computer. The computer that was used in the tutorial just had additional ODBC sources available, hence that list is longer. If you would like to connect to SAP HANA, you have to create a new ODBC source in Windows' "ODBC Data Sources(64 bit)" first. Then this connection will show on the screen you have on page 11.

    Here is some information on creating that ODBC source:
    https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.02/en-US/66a4169b84b2466892e1af9781049836.html

    Data Manager creates SQL statements, hence it is only supported to work with SQL-databases by the way. MS Excel or MS Access are not supported.

    Should you not have a SAP HANA system available, you could download the free version of SAP HANA Express https://www.sap.com/cmp/ft/crm-xu16-dat-hddedft/index.html

    Many Greetings

    Andreas

    Add comment
    10|10000 characters needed characters exceeded