Database Adapter

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:
Related reference
Adapter Support for Schema Discovery