External Database Access

The Server accesses external databases by using database services defined in the service.xml configuration file.

For the Server to communicate with external databases you must:

Have a working JDBC or ODBC connection with the appropriate JDBC or ODBC driver for the desired external database installed.
Modify the service.xml file with the appropriate configuration information.

The Server supports using JDBC drivers for connecting to the following external databases:

The Event Stream Processor Server supports using ODBC drivers for connecting to the following external databases:

Service Configuration File
The service configuration file (service.xml) contains database service definitions, which include all the properties and parameters required for a database connection.
Sample Service Configuration File
A sample of the service.xml configuration file in ESP_HOME/bin. You can use this as a reference for creating your custom service configuration file.
Configuring Connections to External Databases
Use the service.xml file to store service definitions that store connection properties required for a database connection.
Linking to Your ODBC Driver Manager Library
To successfully use an ODBC driver manager library on UNIX systems, link to your ODBC driver manager library and include this link in LD_LIBRARY_PATH for the ESP Server.