Original Message:
Sent: Mon February 10, 2025 10:03 AM
From: Lokeswara Yerramreddy
Subject: Cognos 11.0.12 to Oracle ADW Data Source Connection
Hi Jonathan chesterton,
Good Morning.
Thank you for your response to my query.
We are using Oracle Wallets.
And we were following the steps mentioned in this document https://www.oracle.com/a/ocom/docs/cognos6_28may2019a-2_adw.pdf
We have ojdbc8.jar and Oracle Client 12c
We are able to test OCI connection successfully with Oracle ADW but facing challenges with JDBC connection.
Can you please help me with below queries.
What version of Oracle Client you are using?
What version of Cognos you are using?
What is the JDBC Driver version that you are using? do we need to use any additional JAR files to establish JDBC connection?
Do we need to put Wallets and tnsnames.ora file in same directory? and add this directory as TNS_ADMIN in Environment variable on Cognos servers?
Thanks,
Lokeswara
------------------------------
Lokeswara Yerramreddy
Original Message:
Sent: Fri February 07, 2025 04:26 AM
From: jonathan chesterton
Subject: Cognos 11.0.12 to Oracle ADW Data Source Connection
We connect to Oracle ADW using Cognos.
Are you using Oracle wallets?
If so you'll need t unzip the wallet to a location on your server then within the jdbc string you will need to point at the TNS contained within the wallet.
So for example
jdbc:oracle:thin:@<xxxSERVICE_low/medium/highxxx>?TNS_ADMIN=<xxlocation of wallet e.g. E:\Oracle\Wallets\Productionxx>
This link takes you to an Oracle PDF that details the connection steps Creating a connection from IBM Cognos Analytics server to Oracle Autonomous Data Warehouse (ADW)
hope it helps
------------------------------
jonathan chesterton
NHS Supply Chain
Original Message:
Sent: Fri January 31, 2025 08:08 AM
From: Lokeswara Yerramreddy
Subject: Cognos 11.0.12 to Oracle ADW Data Source Connection
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
------------------------------
Lokeswara Yerramreddy
------------------------------