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


  1. Copy the downloaded driver jar file to C:\Program Files\C10\Server\Integration directory.
  2. Edit the 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

    DB2.driver =

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

    SQL Server (MS native) = MS SQLServer (Microsoft native)

    SQL_SERVER.driver =

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

    Oracle = Oracle thin

    ORACLETHIN.driver =oracle.jdbc.driver.OracleDriver

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

    More information is available in the file.

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