I have installed the CA 11.0.6 and I can upload the Excel files in cognos .But now I am trying to create the
Oracle 11 R2 as a data source in Cognos connection. I have installed the oracle client version and placed the JDBC drivers in below mentioned locations in CA 11 to connect the database.
Details;
32- bit Oracle 11G R2 as client software: installed Cognos server
Cognos analytics 11.0.6 with Easy install in single server
I have created the new schema with full permissions and I can able to connect the same in Oracle (toad) directly. However whenever I created the new connection from Cognos its getting failed .its means it's not working the Cognos from Cognos to oracle. I have placed all the Jdbc drivers from oracle lib to Cognos drivers ojdbc5.jar and ojdbc6 .jar
Cognos location:
Oracle location "
• C:\app\Administrator\product\11.2.0\client_1\jdbc\lib
Cognos data source connection:
the jdbc file is also placed .....\ibm\cognos\analytics\drivers
(assuming you are not changing the defaults). ?
Copy the ORACLE JDBC driver (ojdbc8.jar or ojdbc7.jar) into <cognos>\drivers
See also
https://www-01.ibm.com/support/docview.wss?uid=swg21987705
https://www-01.ibm.com/support/docview.wss?uid=swg22001003