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:
- Adaptive Server® Enterprise
- IBM DB2
- Oracle
- Kx Systems KDB+
- Microsoft SQL Server
The Event Stream Processor Server supports using ODBC drivers for connecting to the following external databases:
- Adaptive Server Enterprise
- Sybase IQ
- SQL Anywhere®
- IBM DB2
- Oracle
- Microsoft SQL Server
- TimesTen
- MySQL 5.x
- PostgreSQL