How to connect to SAP HANA from Statistica using MDX provider
Article ID: KB0082290
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | - |
Description
For the purpose of this article, Statistica Enterprise Manager is used. Similar connectivity can be established via File >> External Data >> Query >> Create within Statistica
PREREQUISITES:
1.In addition to the Statistica installation, SAP HANA client must be downloaded and installed
2. In context of using Statistica Enterprise Manager, the user should have permissions to create a database connection - Either System Admin (SADM) or Database Admin (EXTDB_ADM) and Data Admin (DADM)
3. Details of SAP HANA server, Port and user credentials.
PREREQUISITES:
1.In addition to the Statistica installation, SAP HANA client must be downloaded and installed
2. In context of using Statistica Enterprise Manager, the user should have permissions to create a database connection - Either System Admin (SADM) or Database Admin (EXTDB_ADM) and Data Admin (DADM)
3. Details of SAP HANA server, Port and user credentials.
Issue/Introduction
This article details how to connect to SAP HANA from Staistica/ Statistica Enterprise manager using the MDX Provider
Resolution
1. Launch Statistica/ Statistica Enterprise manager from the start menu. If using Statistica, select File >> External Data >> Query >> Create . If using Enterprise manager, right click on on Database connections and select "New OLEDB Database Connection"
2. In the Data Link Properties dialog that launches, choose SAP HANA MDX Provider . If this provider does not appear in the list of providers, SAP HANA client is likely not installed- contact your system administrator. Click Next
3. Enter SAP HANA ServerName:Port for Host and enter the credentials to connect to the SAP HANA instance. Click Test Connection. You should see "Test connection succeeded" if the server credentials are correct. Click OK.
Note : If the test connection fails, double check that the credentials to the server/ server information is correct and contact the system administrator, if necessary.
4. Name the connection appropriately, define Access Permissions in Enterprise Manager and then click on commit on the top left hand corner of Enterprise manager.
5. Expand System View in Enterprise Manager, right click on a folder and click on New Data Configuration
6. Choose the database connection defined in Step 4 for connection from the drop down list. Name the Data configuration appropriately and then click on New button near Queries.
7. If you have an MDX query, you may paste it in the SQL Statement window. If you need to formulate the MDX query, click on SQL Wizard button.
8. Define the MDX query by dragging and dropping the Row, Column and Slicer. Click on the green triangular arrow after the MDX statement is defined.
9. Commit the change in Enterprise manager by clicking the commit button in the top left hand corner of Enterprise manager. Explore the data configuration to bring the data into a Statistica spreadsheet for further analysis.
2. In the Data Link Properties dialog that launches, choose SAP HANA MDX Provider . If this provider does not appear in the list of providers, SAP HANA client is likely not installed- contact your system administrator. Click Next
3. Enter SAP HANA ServerName:Port for Host and enter the credentials to connect to the SAP HANA instance. Click Test Connection. You should see "Test connection succeeded" if the server credentials are correct. Click OK.
Note : If the test connection fails, double check that the credentials to the server/ server information is correct and contact the system administrator, if necessary.
4. Name the connection appropriately, define Access Permissions in Enterprise Manager and then click on commit on the top left hand corner of Enterprise manager.
5. Expand System View in Enterprise Manager, right click on a folder and click on New Data Configuration
6. Choose the database connection defined in Step 4 for connection from the drop down list. Name the Data configuration appropriately and then click on New button near Queries.
7. If you have an MDX query, you may paste it in the SQL Statement window. If you need to formulate the MDX query, click on SQL Wizard button.
8. Define the MDX query by dragging and dropping the Row, Column and Slicer. Click on the green triangular arrow after the MDX statement is defined.
9. Commit the change in Enterprise manager by clicking the commit button in the top left hand corner of Enterprise manager. Explore the data configuration to bring the data into a Statistica spreadsheet for further analysis.
Feedback
Yes
No
Powered by
