In order for Apama to communicate with your database using a straight JDBC connection, you must have a JDBC driver for your database. JDBC drivers are available from most database vendors. To make your database driver available to Apama, locate the driver on your machine and add the jar that contains the driver class to your Dashboard Properties (select Properties from the Project menu in Apama Studio).

Apama includes Progress DataDirect JDBC 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.

You can add paths to multiple driver classes. You must know the fully qualified class name for the driver class and the database URL required to connect to your database when you add the database in the Application Options dialog. The database URL typically contains the protocol and sub-protocol strings for your database as well as the path to the database and a list of properties. If you do not know the syntax for your database URL, consult the documentation for your JDBC driver.