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.
December 14, 2020 with OAC 5.8
June 7, 2019
Preparing to Create ADW Connections
Creating an OAC BI Publisher ADW Connection
___________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________
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.
►Click JDBC Connection to create the ADW connection.
►Click Add Data Source.
For the Data Source details:
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.
____________________________________________________________________________________________________________________________________________________________________________
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.
Previous Post
Next Post