This post details the steps required in OAC version 4 (versions 18.2.x and less) to upload an Autonomous Data Warehouse (ADW) wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data sets. Console connections are used for TCM models.
For OAC5 connections refer to Connecting Oracle Analytics Cloud Version 5 to the Autonomous Data Warehouse.
The instructions found in Connect to Oracle Autonomous Data Warehouse Cloud are sufficient for experienced users. This post supplements the instructions with images of the screens used.
Latest Validation: September 14, 2018 using OAC 18.2.1-1510
Past Validations: July 24, 2018 using OAC 18.2.1-1506 and OAAC 18.2.1-1447
Published on: June 22, 2018
Uploading the ADW Wallet to OAC
Creating an ADW Data Connection
Creating an ADW Console Connection
Oracle Analytics Cloud 18.2.1-1473, 18.2.1-1506 and 18.2.1-1510
Oracle Autonomous Analytics 18.2.1-1438 and 18.2.1-1447
Autonomous Data Warehouse 18.1.5+
Windows 7 SP 1
To enable secure communication between Oracle Analytics Cloud and the Autonomous Data Warehouse, your administrator must upload trusted SSL certificates to Oracle Analytics Cloud.
Obtaining the Client Credentials Zip File from the Oracle Autonomous Data Warehouse Console
Unzipping the Client Credentials Wallet Zip File
Uploading the Extracted Wallet File
The ADW wallet file is one of the files provided in the Client Credentials zip file. Refer to Downloading Client Credentials (Wallet) for the steps.
Use an unzip utility to unzip the Client Credentials Zip File e.g. wallet_DB201806211045.zip to a directory e.g. wallet_DB201806211045.
Note: You must be an Administrator to do this.
1. Login into the DV home page and click the Action Menu.
2. Click Console.
3. Click Connections.
4. Click Upload Wallet to upload a wallet for the first time or Replace Wallet to update an existing wallet.
5. Note: Even on your first upload, you may encounter a screen saying a wallet is already uploaded. If so, click Proceed.
6. Click Proceed without a virus scanner when warned.
8. Click OK.
You can now upload a RPD that contains a TNS Connect Descriptor from the tnsnames.ora file in the unzipped ADW directory. Refer to Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse Cloud for details on creating an ADW connection inside an RPD.
A data connection is used to create DV data sets.
1. Click Home to return to the DV home page.
2. Click Create.
3. Click Connection.
4. Click the Oracle Autonomous Data Warehouse connection type.
5. Complete the connection details and click Save.
The Host, Port, and Service Name are found in the tnsnames.ora file in the unzipped ADW directory.
Use the Username e.g. Admin and Password specified when the ADW instance was created or a different Schema's credentials.
You can now create DV data sets from the connection.
A console connection is used by the TCM to create models.
1. Click Console.
2. Click Connections.
3. Click New Connection.
4. Complete the connection details, click Test and then click OK.
a. Choose Host, Port, and Service Name for the Connect using.
b. The Host, Port, and Service Name are found in the tnsnames.ora file in the unzipped ADW directory.
c. Use the Username e.g. Admin and Password specified when the ADW instance was created or a different Schema's credentials.
d. Check the Enable SSL box.
You can now create TCM models using the connection.
This post detailed the steps required to upload an ADW wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC).
For more OAC, BICS and BI 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 BICS and Oracle A-Team Chronicles for OAC.