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:
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.
DB2 (db2jcc.jar)
Install the DB2 client on the Controller application server.
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.
Related Information
[{"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"}}]
Was this topic helpful?
Document Information
Modified date:
24 April 2020
UID
swg22011796