C.6 Configuring a JDBC Connection in iManager

JDBC database connections are used when performing queries in iManager. These steps assume that the required JDBC driver file (.jar) is in the iManager server’s defined classpath.

  1. Download the JDBC driver for the MySQL database from the MySQL Development site.

    The .jar file must be copied to the tomcat/common/lib folder of the server hosting the Nsure Audit iManager plug-in. The .jar file enables you to create JDBC connections to MySQL.

    NOTE:If your browser renames the .jar file as a .zip file during the download, you must rename the file with the original .jar extension.

  2. In iManager, click Auditing and Logging > Query Options.

  3. In the Databases tab, click New to add a new database.

  4. Follow the instructions in the online help to create the database entry.