Sybase IQ and SAP HANA

Sybase IQ and SAP HANA require an ODBC data source on the client computer for each database you want to access using ODBC.

On Windows, use a system DSN, which offers faster performance than a file DSN. You can also share system DSNs with all users on the network.

On UNIX or Linux operating systems, ODBC data sources are held in a file named .odbc.ini. When you create an .odbc.ini file, you must use the long form of each identifier. For example:

[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.

Here is an example of an entry for SAP HANA:

[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 multi-byte characters need to be processed, you may omit this line.

For information about configuring ODBC, see Configuring ODBC for Event Stream Processor.