Database Adapter

SAP Event Stream Processor provides an input and output database adapter. The Database Input adapter receives data from a database table, and the Database Output adapter sends data to a database table.

You can use several different JDBC™ and ODBC drivers with the database adapter. To use the ODBC drivers, ensure you have a driver manager installed.

On UNIX systems, Event Stream Processor expects your ODBC driver manager library to be called libodbc.so.1. Ensure that your driver manager library has this name or create a symbolic link from libodbc.so.1 to your ODBC driver manager library.

If you are connecting to a database other than SAP HANA, SAP recommends upgrading to version 2.3.0 or later of unixODBC. If you are using a version lower than 2.3.0, set a parameter for the driver that instructs the database manager not to synchronize database access. To do this, add a line that says “Threading = 0” for your driver in the odbcinst.ini file.

If you are connecting to an SAP HANA database, use unixODBC version 2.3.0 or later - do not use an earlier version. In addition:

If you are using version 2.3.0, add “Threading=0” in the odbcinst.ini file to ensure optimal adapter performance.
If you are using version 2.3.1, create a symbolic link under <2.3.1 installation folder>/lib as follows:
```
ln -s libodbc.so.2.0.0 libodbc.so.1
```
As stated previously, Event Stream Processor expects your ODBC driver manager library to be called libodbc.so.1, which unixODBC 2.3.1 has renamed libodbc.so.2.
If Event Stream Processor needs to pass multibyte characters to the SAP HANA database, specify the CHAR_AS_UTF8=1 property. For Windows, specify this property using the HANA ODBC driver advanced setup. In Linux, edit your .odbc.ini file to include this property.