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
Microsoft SQL Server JDBC driver, for example sqljdbc4.jar

Procedure

  1. Copy the downloaded driver jar file to C:\Program Files\IBM\Cognos\ccr_64\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:

    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

  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.