Urgent !! - Cognos 11.0.12 to Oracle ADW Data Source Connection

[Lokesh Reddy]

Hi Cognos Community !

Urgent !!!

One of our On-Prem Oracle Database has been migrated to Oracle Cloud (ADW)

We are in the phase of testing our Cognos Data Source Connection to Oracle ADW.

we obtained tns entries (host, port, service name) for this cloud DB

Below things we have in our Cognos servers.

1) Oracle Client v12.1.0.2

2) ojdbc8.jar (v21.6.0.0.1)


As part of testing, we have created new Data Source Connection in Cognos DEV environment and provided all the connection parameters.

OCI connection is getting succeeded but we are facing challenges for JDBC connection.

Does anyone has idea on how to create Data Source Connection from Cognos v11.0.12 to Oracle ADW Cloud DB ?

Looking forward for your inputs and guidance..

Thanks,

Lokeswara

[MFGF]

Hi Cognos Community !

Urgent !!!

One of our On-Prem Oracle Database has been migrated to Oracle Cloud (ADW)

We are in the phase of testing our Cognos Data Source Connection to Oracle ADW.

we obtained tns entries (host, port, service name) for this cloud DB

Below things we have in our Cognos servers.

1) Oracle Client v12.1.0.2

2) ojdbc8.jar (v21.6.0.0.1)


As part of testing, we have created new Data Source Connection in Cognos DEV environment and provided all the connection parameters.

OCI connection is getting succeeded but we are facing challenges for JDBC connection.

Does anyone has idea on how to create Data Source Connection from Cognos v11.0.12 to Oracle ADW Cloud DB ?

Looking forward for your inputs and guidance..

Thanks,

Lokeswara

Hi,

It depends on which version of java you are using with your Cognos install as to which is the correct jdbc driver to download and use for Oracle. If you are using Java 1.5, you need the odbc5.jar driver, and if you are using Java 1.6, you need the odbc6.jar driver.

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=databases-oracle

Whichever Java you have, I assume odbc8.jar is incorrect?

Cheers!

MF.