Apama 10.7.2 | Building and Using Apama Dashboards | Building Dashboard Clients | Using SQL Data | Setting up SQL database connections
 
Setting up SQL database connections
 
Direct JDBC connection
Apama communicates with your database using a direct JDBC connection that requires 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 a JDBC database driver for the following Apama-certified databases:
*Microsoft SQL Server
*Oracle
These database drivers eliminate the need to install database-vendor-supplied drivers. 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 location:
apama_install_dir\doc\db_drivers\jdbc