IBM Support

How to obtain a suitable JDBC driver for use with Cognos Controller

Question & Answer


Question

Customer is trying to install Cognos Controller. How can they download the relevant Java JDBC JAR database connector file?

Cause

Some Controller functions use JDBC connectivity to access the Controller databases. Controller does not ship with a JDBC driver in the software itself, so you must download a suitable JDBC driver from the relevant database provider’s website.

For example, the following are known to work with Controller:
Database Server
Description
Filename
Microsoft SQL
JDBC driver
sqljdbc4.jar
mssql-jdbc-7.0.0.jre8.jar
Oracle
JDBC thin driver
varies*

(example: ojdbc5.jar)
IBM DB2
DB2 driver
db2jcc.jar

Answer

Microsoft SQL (for example: sqljdbc4.jar or mssql-jdbc-7.0.0.jre8.jar)
For instructions on how to obtain these files, see separate IBM Technote #1135510.

Oracle (OJDBC JAR file)
There are several different possible file names (for example ojdbc5.jar) and versions of the Oracle OJDBC file.
  • For full details, see separate IBM Technote #1988891.

DB2 (db2jcc.jar)
Install the DB2 client on the Controller application server.
  • Assuming you have installed the DB2 10.5 client in the default location, then you can find the file here: C:\Program Files\ibm\SQLLIB\java
  • Alternatively, you can download from separate IBM Technote #382667.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.1;10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 April 2020

UID

swg22011796

Page Feedback