KB40923: How to configure the SAP HANA 1.0 SP2 ODBC driver for connectivity to a SAP HANA database for the MicroStrategy Intelligence Server 9.3.0 on Linux

In Strategy 9.3.0, SAP HANA 1.0 SP2 is certified as a Warehouse with Strategy Intelligence Server running on Windows and Linux operating systems.
 
Follow the steps below to configure the SAP HANA ODBC driver with the Strategy Intelligence Server 9.3.0 on Red Hat Enterprise Linux:
 
1.  Install the SAP HANA driver files on the Linux system that will host the Strategy Intelligence Server.
 
2.  Add the settings for environment variables by manually adding the following entry to the end of the <Strategy_Home_Path>/env/ODBC.sh file (this file may need to be made writable using the chmod +w command):

#
#ODBC Driver for SAP HANA
#
SAPHANA_PATH=<SAPHANA_PATH> 
if ; then
export SAPHANA_PATH
mstr_append_path LD_LIBRARY_PATH "${SAPHANA_PATH:?}"
export LD_LIBRARY_PATH

 
Note:
<SAPHANA_PATH> is the location of the installed SAP HANA 1.0 SP2 ODBC client for Linux.
 
3.  Save and close the ODBC.sh file.
 
4.  Create a DSN to the SAP HANA 1.0 SP2.  For additional steps on how to create ODBC DSN for SAP HANA users can refer to the section below on this document.
 
5. Restart the Strategy Intelligence Server.
 
How to create a DSN for SAP HANA 1.0 SP2 for the Strategy Intelligence Server 9.3.0 on Linux
 
Add a DSN in the odbc.ini for the SAP driver.

odbc.ini:
SAP-HANA-TEST=SAP HANA ODBC DRIVER
……
 
Driver=<SAPHANA_PATH>/libodbcHDB32.so
Servernode=xxx.xx.xxx.xxx:<portnumber>
USER=test
PASSWORD=test
DriverUnicodeType=1 

 
For example:
 

Driver=/usr/sap/hdbclient32/libodbcHDB32.so
Servernode=xxx.xx.xxx.xxx:10000
USER=test
PASSWORD=test
DriverUnicodeType=1

 
NOTE:  The SAP HANA ODBC driver on Linux  is an UTF-16 driver. Therefore, users will need to set the 'Character set encoding for UNIX drivers' is set to 'Non UTF-8' in the Database Connection in Strategy Desktop.
 
Third Party Software Installation WARNING
 
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.