Configuring an External unixODBC Driver Manager

If you are using SAP Event Stream Processor Studio on Linux, and have no other ESP components installed locally, install and configure your own unixODBC driver manager.

Prerequisites

Install the SAP HANA client. See the SAP HANA Client Installation and Update Guide for instructions.

Context

SAP Event Stream Processor requires the ODBC driver manager unixODBC 2.3.1, which is only included with the ESP server installation package.

Procedure

Download and install the unixODBC driver manager, which is available from your Linux provider, or from http://www.unixodbc.org/download.html.
Navigate to the location of the unixODBC driver manager. The default location is /usr/local/lib.
Locate libodbc.so.1 in the default folder. If libodbc.so.1 does not exist, execute the following to create a symbolic link from libodbc.so.1 to libodbc.so.2 (or to libodbc.so.3, depending on which version of unixODBC you installed):
```
ln -s libodbc.so.2.0.0 libodbc.so.1
```
ESP connects to libodbc.so.1, which unixODBC 2.3.1 has renamed libodbc.so.2. Creating the symbolic link allows ESP to use libodbc.so.2 (or libodbc.so.3).
Create the .odbc.ini file at /usr/sap/<SID>.
In /hana/shared/<SID>/streaming/STREAMING.sh, update LD_LIBRARY_PATH to:
```
LD_LIBRARY_PATH="/usr/local/lib":$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
```
LD_LIBRARY_PATH points to where libodbc.so.1 is available. In this example it is located at /usr/sap/home/unixodbc2.3.1/lib. If using libodbc.so.2 or libodbc.so.3, create a file called libodbc.so.1, link it to libodbc.so.2 (or libodbc.so.3), and set LD_LIBRARY_PATH to:
```
LD_LIBRARY_PATH=/usr/sap/home/unixodbc2.3.1/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH
```
In the /usr/local/lib directory, locate .odbcinst.ini.

Add an entry in the Driver parameter for your SAP HANA ODBC driver:

[HDBODBC]
Description=64-bit HANA ODBC Driver
Driver=<install-location>/hdbclient/libodbcHDB.so
FileUsage=1