Last validation: September 30, 2020 with 12.2.1.4.0

Introduction

This post details the steps required to create connections in Oracle Data Integrator (ODI) Marketplace to Autonomous Databases on shared infrastructure e.g. Autonomous Data Warehouse (ADW). This post uses ADW, but the method is also applicable to Autonomous Transaction Processing (ATP) databases.

For additional details about ADW, refer to Autonomous Data Warehouse. For additional details about ODI, refer to Oracle Data Integrator Overview.

ODI Studio is assumed to be provisioned. For information on installing ODI visit Deploying Oracle Data Integrator Marketplace in a Public Subnet with Autonomous Database

Updates and Validations

Validations:

 September 30, 2020 with 12.2.1.4.0

February 4, 2020 with ODI 12.2.1.4.0 and JDK 1.8.0_191

Topics

Preparing to Connect to ADW

Creating a Data Server

Preparing to Connect to ADW

Connecting to autonomous databases from ODI Marketplace requires client credentials, an OCI Dynamic Group and an OCI Policy for the compartment containing ADW.

CREDENTIAL FILE

Credential files are downloaded from the ADW console to the ODI host in the Oracle Cloud Infrastructure (OCI).

Note: When ODI is deployed from the Marketplace, client credential folders are downloaded from autonomous databases that exist in the OCI compartment containing ODI.

If ADW is in a different compartment than ODI follow the steps below.

Download the Credentials

Connect to the ODI host using VNC. Refer to the Deployment blog above for details.

Launch Firefox from the Applications>Favorites list.

Follow the steps in Downloading Autonomous Data Warehouse Credentials to obtain the client credentials compressed folder containing the wallet and network configuration files used by ODI to make the connections.

DYNAMIC GROUP

Ensure a dynamic group exists that includes the ODI compute instance. This group is used by a policy rule to grant permissions.

Refer here for the documentation.

An example matching rule that includes all instances in the ODI compartment is:

instance.compartment.id = '<compartment_ocid>'

COMPARTMENT POLICIES

Ensure there are policy rules granting the dynamic group permissions in the compartment containing ADW.

Refer here for the documentation.

Example policy rules are:

Allow dynamic-group <dynamic group name> to USE autonomous-database-family in compartment <ADW compartment>

Allow dynamic-group <dynamic group name> to INSPECT compartments in compartment <ADW compartment>

Creating a Data Server

Connect to ODI Studio. Navigate to the Oracle technology in the Physical Architecture > Technologies tab. Right-Click on the Oracle technology and click New Data Server.

In the Definition tab, give the server a Name.

In the Connection section, enter the database instance User and Password.

If your ADW is in the ODI compartment, click the Discover ADBs button. This checks the Use Credential File box and populates the Credential File location. Note: If the ADW was created after the ODI deployment, the Studio connects to the ADW and downloads the credential file.

If your ADW is not in the ODI compartment, click the Search icon and choose the Credential File you downloaded. 

Use the Dropdown on the right of the Connection Details box and choose the desired connection.

Click Test Connection which also saves the Data Server.

Summary

This post provided the steps required to create connections in Oracle Data Integrator Marketplace to the Autonomous Data Warehouse on shared infrastructure.

For other posts relating to analytics and data integration visit http://www.ateam-oracle.com/dayne-carley