Skip to Content
0

Data Manager

Jan 05 at 10:53 AM

38

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Andreas Forster
Jan 05 at 11:17 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded