Using JDBC drivers for IBM Cognos Controller

IBM® Cognos® Controller uses JDBC (Java™ Database Connectivity) connectivity to access the Controller database. You need to download a suitable JDBC driver from the relevant database provider's website.

Table 1. JDBC drivers required for databases
Database JDBC driver
DB2® DB2 driver, for example db2jcc.jar
Microsoft SQL Server JDBC driver, for example sqljdbc4.jar
Oracle JDBC thin driver, for example ojdbc5.jar

Procedure

  1. Copy the downloaded driver jar file to C:\Program Files\C10\Server\Integration directory.
  2. Edit the ccr-dbTypes.properties file to match the copied driver jar file using a text editor such as Notepad. You need the following information depending on which driver file you are using:

    IBM DB2

    DB2.name = DB2

    DB2.driver = com.ibm.db2.jcc.DB2Driver

    DB2.url = jdbc:db2://%s%s/%s

    SQL Server (MS native)

    SQL_SERVER.name = MS SQLServer (Microsoft native)

    SQL_SERVER.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver

    SQL_SERVER.url = jdbc:sqlserver://%s%s;databaseName=%s

    Oracle

    ORACLETHIN.name = Oracle thin

    ORACLETHIN.driver =oracle.jdbc.driver.OracleDriver

    ORACLETHIN.url = jdbc:oracle:thin:@%s%s:%s

    More information is available in the ccr-dbTypes.properties file.

  3. Restart the IBM Cognos Controller Java Proxy service if it is running.
    Note: Make a backup copy of the ccr-dbTypes.properties file to avoid overwriting it when the system is updated.