The ESP server accesses external databases by using database services defined in the service.xml configuration file.
Adapter | Supported Drivers | Supported Databases |
---|---|---|
Adaptive Server® Enterprise Output Adapter | Open Client™ | Adaptive Server Enterprise |
Database Input and Output Adapters | JDBC |
|
Database Input and Output Adapters | ODBC |
|
SAP HANA Adapter | ODBC | SAP HANA |
SAP Sybase IQ | ODBC | SAP Sybase IQ |
On UNIX systems, 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
This link is required because ESP links to libodbc.so.1, which unixODBC 2.3.1 has renamed libodbc.so.2. With the link, ESP will now use libodbc.so.2.