Advanced OBIEE for Experts: Connecting OACS to ADWC.

This blog explains how to connect OAC to Oracle Autonomous Data Warehouse Cloud.

Introduction about Autonomous Data Warehouse Cloud (ADWC)

Autonomous Data Warehouse Cloud Service, fully managed pre-configured data warehousing environment by Oracle. It is built on the next generation technology using artificial intelligence to deliver unprecedented reliability, performance, and highly elastic data management to enable data warehouse deployment in seconds.

Oracle Autonomous Data Warehouse is a PaaS offering and built on Top of Oracle Database Supports

Structured Query Language (SQL)
Business Intelligence Tools (BI)

ADWC has only accepts secure connections to the database, you need to download a wallet file containing your credentials first. The wallet is downloaded from the ADWC service console. On the Instances page, find database and click “DB Connections (or) Service Console” in the actions menu.

1.Create Autonomous Warehouse Instance:

There is a console with several options is called OCI Console, go & click on Create Autonomous Database.When the status is available for database, click on Database Name and open DB Connection or service Console to get the database details.

2. Download Client Credentials:

In the Service Console, under the Administration option, select Download Client Credentials Or DB connection option from the ADB instance console.

3. ADB Wallet’s Content:
Extract the downlaod file "Wallet_BMKOACSDB.zip" and check the .ora files.

4. ADB Connection Details

The connection details can be found In the tnsnames.ora or using the new DB connection button, Choose the correspondent one depending on performance requirements

5. ADB Connection Types

There are Pre defined Service names offer different levels of performance & concurrency

High: the highest level of performance. Number of concurrent queries 3 – this value does not depend of the number of CPUs

Medium: performance lower level than high Number of concurrent queries: depends on number of CPUs (lineal increment)

Low: is the lowest value for performance but is the highest value of concurrency

6. Accessing ADB with SQL Developer.
Test the data and loading into ADB Through SQL Developer 18.2.

We can use other ETL Tools also like Oracle Data Integrator, Informatica PowerCenter, etc..

We can Create, Modify & Update the Data for Autonomous Cloud Database in SQL Developer.

Process to connect Data through Data Visualisation Desktop at On-Prem:

The following steps we can use here to connect database to DVD.

Get the ADWC Credentials (Wallet)
Copy the wallet.sso under DVD folder
Create a new connection in DVD
Create Data Set & New Project.
Getting Start Visualisation.

01.Get ADWC Credentials

In the Service Console, under the Administration option, select Download Client Credentials.

02. Copy the wallet.sso file under DVD folder:

Copy the wallet.sso file under %AppData%\Local\DVDesktop\components\OBIS\dwcs folder

Create the folder in case it doesn’t exist in Local Folder.

03. Create a new connection in DVD.
Select Connection type as Oracle Autonomous Data Warehouse Cloud and enter the required credentials to setup Connection for Data sets.