Creating a JDBC database connection for dynamic query mode

Create a JDBC database connection for report packages that use Dynamic Query Mode.

1. Copy your database's JDBC driver JAR files to the following locations:
   • JazzSM_WAS_Profile/installedApps/localhostNode01Cell/IBM Cognos.ear/p2pd.war/WEB-INF/lib/
   • JazzSM_HOME/reporting/cognos/webapps/p2pd/WEB-INF/lib/
   Note: For a DB2® database, no copy is required because the JAR files already exist in the Tivoli® Common Reporting environment. For other database types, check its documentation for list of required JDBC driver JAR files.
2. Create a database connection for Cognos as follows:
   1. Log in to the relevant reporting interface in your environment. Logging in to the reporting interface.
   2. Select Launch > Administration.
   3. In the Configuration tab, click to add a data source.
   4. Use the New Data Source wizard to create the data source with regard to the following points:
      • On the second page of the wizard, select DB2 or Oracle database as the Type, that is, do not select JDBC.
      • Ensure that the Configure JDBC connection option is selected.
      • On the third page of the wizard, enter only the database name, and in the Signon section, specify the User ID and password for connection to the database.
      • On the fourth page, enter the Server name, Port number, and the Database name.
      Note: The connection may fail the connection test for compatibility. This can be ignored, as the Compatible connection type is not being used.