PowerExchange for HANA User Guide for PowerCenter

Back Next

Create a HANA ODBC Data Source on UNIX

On UNIX, set the ODBCHOME, ODBCINI, and shared library environment variables. Add the data source entries to the

odbc.ini

file in the system

$ODBCHOME

directory.

Set the following environment variables:

ODBCHOME: Set the variable to the ODBC installation directory.; For example,
setenv ODBCHOME /export/home/qamercury/Informatica/10.4.1/ODBC7.0

ODBCINI: Set the variable to point to the directory that contains the odbc.ini file.

For example,
setenv ODBCINI /export/home/qamercury/MBUGB_ODBCINI/10.4.1/odbc.ini

LD_LIBRARY_PATH, LIBPATH, or SHLIB_PATH: Set the shared library environment variable to the directory where the SAP HANA ODBC driver is installed.

For example,
setenv LD_LIBRARY_PATH ".:${PM_HOME}:${JAVA_HOME}/lib:${ORACLE_HOME}/lib:/usr/sap/hdbclient:"

After you set environment variables, add data source entries to the odbc.ini file found in the system $ODBCHOME directory.

For SAP HANA, add the following entry to the odbc.ini file:

[SAP HANA source]
Driver=/usr/sap/hdbclient/libodbcHDB.so
DriverUnicodeType=1
ServerNode=<server_node>:<port>

The operating system user that runs Informatica processes must have read and execute permissions on the HANA ODBC driver file.