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