ODBC Driver for SAP HANA for Windows and Linux

The ODBC driver for SAP HANA is not a MicroStrategy-branded driver. The following steps show how to configure ODBC driver for SAP HANA.

To Configure an ODBC Driver for SAP HANA on Windows

1. Install the SAP HANA ODBC driver files on the Windows system that will host the MicroStrategy Intelligence Server. For specific installation steps, refer to your third-party SAP documentation.
2. Using the Microsoft ODBC Data Source Administrator, create a data source name to connect to your SAP HANA data source.

   For best practices on using the Microsoft ODBC Data Source Administrator to create data source names that are to be used in MicroStrategy, see Managing ODBC and data sources with Microsoft ODBC Data Source Administrator.

3. You can use the MicroStrategy DB Query Tool to test whether data can be retrieved data from your SAP HANA data source. For information on how to use the MicroStrategy DB Query Tool, see Using the DB Query Tool.
4. To use an SAP HANA as a data source, you must create a database instance in MicroStrategy. For information on creating a database instance, see Creating a database instance.

   When creating a database connection, which is part of a database instance, ensure that you select Non UTF-8 as the character set encoding for Windows drivers.

This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. For additional configuration requirements, see Additional Requirements to Support SAP HANA.

To Configure an ODBC Driver for SAP HANA on Linux

Begin by installing the SAP HANA ODBC driver files on the Linux system that will host the MicroStrategy Intelligence Server. For specific installation steps, refer to your third-party SAP documentation.

The following set of instructions are divided into two sections: how to configure your environment and how to configure a DSN.

To Configure the Environment

1. In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.Browse to the folder env.
2. Add Write privileges to the ODBC.sh file by entering the following command:

   chmod u+w ODBC.sh

3. Edit the odbc.sh file and provide the location where you installed the SAP HANA ODBC driver files. Within the ODBC.sh file, the following definition is included:

   SAPHANA_PATH='<SAPHANA_PATH>'

   Replace this <SAPHANA_PATH> placeholder with the location of the SAP HANA ODBC driver files.

   Do not modify any other occurrences of <SAPHANA_PATH> within odbc.sh.

4. Save the ODBC.sh file and remove Write privileges from the file by entering the following command:

   chmod a-w ODBC.sh

To Configure a DSN

1. In a Linux console window, browse to HOME_PATH where HOME_PATH is the specified home directory during installation.
2. Open the odbc.ini.example file and find the section that starts with [SAP HANA]. Copy the section into the odbc.ini file.

3. Edit the following information from the syntax that you copied to odbc.ini:

   • Driver=<SAPHANA_PATH>/libodbcHDB.so

     Replace <SAPHANA_PATH> with the location where you installed the SAP HANA ODBC driver files.

   • Servernode=ip_address:port

     Replace ip_address with the IP address for the machine that hosts the SAP HANA database.

     Replace port with the port number for the connection to the SAP HANA database. Contact your SAP HANA database administrator for the required port number.

   • USER=uid

     Replace uid with a valid SAP HANA user account.

   • PASSWORD=pwd

     Replace pwd with the password for the SAP HANA user account described above.

   For information on the available parameters, refer to your third-party SAP HANA driver documentation. This can often be found along with the driver installation.

4. Save the odbc.ini file.
5. You can use the MicroStrategy DB Query Tool to test whether data can be retrieved data from your SAP HANA data source. For information on how to use the MicroStrategy DB Query Tool, see Using the DB Query Tool.
6. To use an SAP HANA as a data source, you must create a database instance in MicroStrategy. For information on creating a database instance, see Creating a database instance.

   When creating a database connection, which is part of a database instance, for SAP HANA, ensure that you select Non UTF-8 as the character set encoding for Linux drivers.

This completes the steps for the initial connection to SAP HANA in MicroStrategy for Windows environments. For additional configuration requirements, see Additional Requirements to Support SAP HANA below.

To Configure a DSN‑less Connection

To configure the ODBC driver for DSN‑less connection, an additional step is required along with the steps in the To Configure a DSN section above.

1. Open the odbcinst.ini file and find this section:

   Copy

   [HDBODBC]
   Driver=<SAP_HANA_ODBC_DIR>/libodbcHDB.so
   Description=HANA Driver
   Setup=<SAP_HANA_ODBC_DIR>/libodbcHDB.so
   CPTimeout=0

2. Replace the <SAP_HANA_ODBC_DIR> placeholder with the location where you installed the SAP HANA ODBC driver files. The path is the same as specified in the odbc.ini file.
3. Restart the Intelligence Server.

Additional Requirements to Support SAP HANA

Review the following additional requirements to ensure a successful integration of SAP HANA in MicroStrategy:

• Be aware that once you import tables from SAP HANA into MicroStrategy, you must manually import any prefix information as well. Using the Warehouse Catalog, you can select all tables imported from SAP HANA and select Import Prefix to import the prefix information. For additional steps to access and use the Warehouse Catalog, see the Project Design Help.
• If the tables in SAP HANA include input parameters, these are supported in MicroStrategy using prompts. Using the Table Editor available in MicroStrategy Developer, you can create and modify prompts to support input parameters. For steps to access and use the Table Editor, refer to the Project Design Help.