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