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

Once you have set up your database connection, you will need to add your database in the Builder from the Application Options dialog on the SQL tab (see 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 set up correctly or that you do not have permission to access the database. Note: Databases that have been set up 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 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 database-vendor-supplied drivers. The ODBC database drivers are licensed to be used only with the Apama ADBC adapter. The JDBC drivers can be used with any Apama component.

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