X

Best Practices from Oracle Development's A‑Team

Connecting Oracle Analytics Cloud BI Publisher to the Autonomous Data Warehouse

Introduction                                                                                                                                                     

The latest releases of Oracle Analytics Cloud (OAC) now support BI Publisher (BIP) connections to the Autonomous Data Warehouse (ADW).

This post is a step-by-step guide to creating the connections. Links to documentation are provided for all steps where possible. Screen shots are provided for the ADW Connection steps.

It is part of the A-Team ADW Posts collection.

Updates

  • Published on June 7, 2019

Versions

  • Oracle Analytics Cloud version 105.2.x
  • ADW 18c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  • Mac OS 10.13.6

Topics

  • Preparing to Create ADW Connections
  • Creating an OAC BI Publisher ADW Connection

___________________________________________________________________________________________________

 Preparing to Create ADW Connections

To enable secure communication between Oracle Analytics Cloud and the Autonomous Data Warehouse, your administrator must obtain trusted SSL certificates contained in an ADW wallet.

Topics

  • Obtaining the Client Credentials Zip File from the ADW Console
  • Unzipping the Client Credentials Zip File

_________________________________________________________________________________

Obtaining the Client Credentials Zip File from the ADW Console

Refer to Downloading Client Credentials (Wallet) for the steps.

_________________________________________________________________________________

Unzipping the Client Credentials Zip File

Unzip the Client Credentials Zip File e.g. wallet_DB201806211045.zip to a directory e.g. wallet_DB201806211045.

_____________________________________________________________________________________________________

 Creating an OAC BI Publisher Connection

This section creates the OAC BI Publisher ADW Connection.

►Log into OAC, click the hamburger icon and select Open Classic Home.

 ►Click Administration. Then click Manage BI Publisher.

                                                 

►Click Upload Center to upload the ADW wallet.

  1. Click Choose File and select the wallet from the unzipped client credentials folder.
  2. Select JDBC Client Certificate as the File Type and click Upload. 
  3. Then Click Return to return to the BIP Administration page.

►Click JDBC Connection to create the ADW connection.

►Click Add Data Source.

For the Data Source details:

  • Enter a Data Source Name
  • Accept Oracle 12c as the Driver Type
  • Accept oracle.jdbc.OracleDriver as the Database Driver Class
  • For the Connection String use a TNS Connect Descriptor found in the tnsnames.ora file in the unzipped client credentials folder.
  • Enter the ADW schema owner name for the Username
  • Enter the Password
  • Choose the uploaded wallet from the Client Certificate dropdown

Then click Test Connection and ensure success.

Then click Apply.

A successful test responds with this: 

You can now use the ADW connection to create BIP Data Models and reports in OAC.

____________________________________________________________________________________________________________________________________________________________________________

Summary

This post described how to create an ADW connection using Oracle Analytics Cloud BI Publisher.

For more OAC best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit Oracle A-Team Chronicles for OAC.

For additional details on ADW, visit the Autonomous Data Warehouse page. 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha