via DSN (Driver)

MicroStrategy Secure Enterprise uses the SAP HANA ODBC Driver for analytical requests. The following driver configurations and settings are known to enhance performance of MicroStrategy when connecting to SAP HANA.

1. Download the SAP HANA ODBC driver.
2. Open the file odbc.ini. By default, this is located in /opt/mstr/MicroStrategy.
3. Define the ODBC Data Source under the [ODBC Data Sources].

   For example, SAP_HANA=SAP HANA ODBC DRIVER

4. In the file, add the following:

   [SAP_HANA]
   Driver=/home/mstr/sap/hdbclient/libodbcHDB.so
   Description=HDBODBC
   Servernode=<ip-address-of-your-hana-instance>:<port>
   USER= <DB user>
   PASSWORD= <your-hana-DB-User-password>
   DriverUnicodeType=1

5. Save the file.
6. Create a database instance.

   

7. Under Database Connection, click New.
8. Create a database connection that points to the DSN.

   

9. Click the Advanced tab.
10. Select the Use parameterized queries checkbox. All SQL executions containing text input from filters, search conditions, and text prompts are secured through parameterized queries. See KB484512 for more information and a list of certified gateways.

    

11. Click OK.
12. Under Default database login name, click New.
13. Configure and store credentials for login.

    

14. Click OK.