Connecting Oracle Autonomous Analytics to Exadata Express

Introduction

This post details the steps required to upload an Exadata Express 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 additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAAC and OAC, visit the Analytics Cloud page.

The instructions found in Creating Connections to Oracle Autonomous Data Warehouse Cloud are sufficient for experienced users and also apply to Exadata Express. This post supplements the instructions with images of the screens used.

Updates

Latest Validation: June 21, 2018 for Exadata Express 18.2.4 with OAC 18.2.1-1506 and OAAC 18.2.1-1438

Published on: June 29, 2018

Topics

Uploading the Exadata Express Wallet to OAC

Creating an Exadata Express Data Connection

Creating an Exadata Express Console Connection

Versions Used

Oracle Analytics Cloud 18.2.1-1473 and 18.2.1-1506
Oracle Autonomous Analytics 18.2.1-1438
Exadata Express 18.2.4
Windows 7 SP 1

Uploading the Exadata Express Wallet to OAC

To enable secure communication between Oracle Analytics Cloud and Exadata Express, your administrator must upload trusted SSL certificates to Oracle Analytics Cloud.

Topics

Obtaining the Client Credentials Zip File from the Exadata Express Console

Unzipping the Client Credentials Wallet Zip File

Uploading the Extracted Wallet File

Obtaining the Client Credentials Zip File from the Exadata Express Console

The Exadata Express wallet file is one of the files provided in the Client Credentials zip file. Refer to Downloading Client Credentials for the steps.

Unzipping the Client Credentials Zip File

Use an unzip utility to unzip the Client Credentials Zip File e.g. client_credentials.zip to a directory e.g. client_credentials

Uploading the Unzipped Wallet File

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.


7. Click Browse and select the wallet file (cwallet.sso) in the unzipped Exadata Express directory e.g. client_credentials

8. Click OK.

You can now upload a RPD that contains a TNS Connect Descriptor from the tnsnames.ora file in the unzipped Exadata Express directory. Refer to Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service for details on creating an Exadata Express connection inside an RPD.

Creating an Exadata Express Data Connection

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. Note: This is the type to use for Exadata Express also.

5. Complete the connection details and click Save.

The Host, Port, and Service Name are found in the tnsnames.ora file in the unzipped Exadata Express directory.

Use the Username e.g. Admin and Password specified when the Exadata Express instance was created or a different Schema’s credentials.

You can now create DV data sets from the connection.

Creating an Exadata Express Console 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 Exadata Express directory.

c. Use the Username e.g. Admin and Password specified when the Exadata Express instance was created or a different Schema’s credentials.

d. Check the Enable SSL box.

You can now create TCM models using the connection.

Summary

This post detailed the steps required to upload an Exadata Express 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.

References

Exadata Express Cloud Service

Analytics Cloud

Creating Connections to Oracle Autonomous Data Warehouse Cloud

Downloading Client Credentials

Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service

Oracle A-Team Chronicles for BICS

Oracle A-Team Chronicles for OAC

 

Add Your Comment