cancel
Showing results for 
Search instead for 
Did you mean: 

Data Manager

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

AndreasForster
Product and Topic Expert
Product and Topic Expert
0 Kudos

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/66a4169b84b2466892e1af9781...

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

Answers (0)