E.4 Configuring a JDBC Connection in iManager

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

  1. Download the JDBC driver for your SQL Server database from the Microsoft SQL Server Downloads web page. After you complete the installation, copy the mssqlserver.jar file to the tomcat/common/lib folder of the server hosting the Novell Audit iManager plug-in.

    This .jar file enables you to create JDBC connections to the SQL Server.

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

  3. Click New to add a new database.

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