Configuring ODBC for Event Stream Processor

Set up ODBC and the Sybase IQ ODBC driver to allow Event Stream Processor to connect to the historical database.

The Sybase IQ ODBC driver is installed using the Sybase IQ Network Client Install. Use a typical installation and install a licensed copy.
If you plan on using the SAP HANA project, obtain and install the unixODBC ODBC 2.3.0 driver manager on your system. However, if you do not plan to use the SAP HANA project, you can use the driver manager that is installed as part of Sybase IQ Network Client Installation.
Event Stream Processor requires you to call your driver manager's library libodbc.so.1. If your driver manager has a different library name (typically libodbc.so), create a symbolic link to the driver manager library using the name libodbc.so.1.
Create or add to an existing .odbc.ini file. This file must be accessible to any user that has permission to start Event Stream Processor.
Sybase suggests placing the file inside the Event Stream Processor installation directory.

Add an entry for the previously installed Sybase IQ server by replacing <host name> with the hostname of the Sybase IQ database server, and <Sybase IQ ODBC Driver Installation Directory> with the installation path for the Sybase IQ ODBC driver.

If you specified a different port for you server, replace 2638 with your port.
```
[RAPIQ]
ServerName=RAPIQ
DatabaseName=RAPIQ
CommLinks=tcpip{host=<host name>;port=2638}
Driver=<Sybase IQ ODBC Driver Installation Directory>/IQ-15_4/lib64/libodbc.so
Charset=utf8
```
Include Charset=utf8 only if you have a multibyte character install.
If you plan to use the SAP HANA sample project with Event Stream Processor, add connection information about your SAP HANA database to the .odbc.ini file you previously created or modified.
Replace <hana host name>, <hana port>, and <path to SAP hana driver library file>. If you have not yet installed your SAP HANA client, update <path to SAP hana driver library file with the correct location after you install it. Then add the following to your .odbc.ini file:
```
[RAPHANA]
ServerNode=<hana host name>:<hana port>
Driver=<path to SAP hana driver library file>/libodbcHDB.so
CHAR_AS_UTF8=1
```
Include CHAR_AS_UTF8=1 only if Event Stream Processor passes multibyte characters to the SAP HANA database. If no multibyte characters need to be processed, you may omit this line.