In order for Apama to communicate with your database using an ODBC-JDBC bridge, you must have an ODBC driver for your database. Most databases that run on Microsoft Windows come standard with an ODBC driver. You must also register your database with ODBC before accessing it from Apama. The name specified for the ODBC data source name during the ODBC driver setup is the name you will use when accessing the database from Apama.
Apama includes several Progress ODBC database drivers that eliminate the need to install vendor-supplied drivers and they are pre-configured so adapter instances are automatically configured with appropriate settings when the drivers are added to an Apama project. For more information on these packaged database drivers, see
Setting up SQL database connections.