Apama communicates with your database using either a direct JDBC connection or an ODBC-JDBC bridge connection. Both connections require some setup before Apama can communicate with your database.

Once you have setup your database connection, you will need to add your database in the Builder from the Application Options dialog on the SQL tab. Apama will attempt to connect to your database. If Apama is unable to connect to your database, this means that either the driver is not setup correctly or that you do not have permission to access the database. Note: Databases that have been setup to Use Client Credentials will not connect unless you are logged in and you have objects in your display that are using that connection.

If the connection is successful, and the Get Tables and Columns from Database checkbox is selected in the Application Options dialog, Apama will use information from this database to populate drop down menus in the Attach to Data dialog with available tables and columns. If a Database Repository is found, information from your database will be merged with data from the repository file. If you deselect the Get Tables and Columns from Database checkbox Apama will no longer query your database for this information, but the Database Repository will still be used to populate drop down menus. Using a Database Repository to populate drop down menus makes it possible to specify which tables and columns from your database will be listed in the Attach to Data dialog and gives you the ability to build displays while databases are offline.

Apama includes Progress DataDirect ODBC and JDBC database drivers for the following Apama-certified databases (note, the ODBC drivers are available only for Windows platforms):

These database drivers 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.

The Progress DataDirect ODBC database drivers are licensed to be used only with the Apama ADBC adapter. The Progress DataDirect JDBC drivers can be used with any Apama component.

For more information on the supplied Progress database drivers, see the Progress DataDirect Connect Series documentation available in the following locations: