Oracle is now picking up pace and providing new and enhanced services for cloud. The new Oracle autonomous data warehouse cloud service gives a data store which is cloud based highly performant and highly available and has ability to automatically tune itself to give best performance for BI and analytics application. Inbuilt machine learning capabilities also gives customers to explore the AI and data science angle on top of the data already stored in the data warehouse.
As many oracle customers are already using OBIEE or OAC, they would like to migrate and connect OBIEE with Oracle ADWC. However as ADWC supports oracle client 12c and above connecting this through OCI client becomes difficult as normal adminitration tool of OBIEE supports OCI 10g/11g clients only.
Below are the steps one can carry out to connect Oracle's OBIEE or OAC with oracle ADWC.
- Download the client credentials from ADWC console. This is a zip file with wallet credentials for ADWC database.
- Download the oracle 12c client. ADWC supports oracle client 12c and above.
- Copy the tnsnames and sqlnet in the oracle client network/admin folder from the zip file downloaded from ADWC console. This is to override sqlnet.ora to state the wallet location on local system where oracle client is installed.
- Create a wallet folder inside oracle client folder and copy all the files downloaded in the client credentials zip and place in the new wallet folder.
- Edit sqlnet.ora copied in step 3 and point the wallet folder location as in step 4 in sqlnet.ora.
- Download OAC admin tool. Normal OBIEE admin tool is not supported.
- Open rpd and point the tns alias in connection pool.
That's it for now. Have a good day.
