GOAL

This article helps you to connect Oracle autonomous database from ODI studio using wallet files.

Overview of Autonomous database connections

Oracle autonomous database offers 3 type of connections –

  1. Oracle Net Service Name – JDBC thin driver, JDBC OCI, Oracle Call Interface (OCI) & ODBC drivers can use Oracle Net Service names to connect autonomous database.
  2. Oracle wallet file – Java & JDBC thin driver uses wallet files (ewallet.p12 & cwallet.sso) files to connect autonomous database.
  3. Oracle JKS files – Java & JDBC thin driver uses JKS file (truststore.jks & keystore.jks) files to connect autonomous database.

Here we will use oracle wallet files to connect to the database.

Pre-requisites for Autonomous database connections

Make sure you meet the following requirements.

  1. An Autonomous database with security rules configured allows connections from the ODI studio client network.
  2. An ODI studio j2ee/stand-alone agent with a minimum 12c version.

Creating a Connection

Download the Wallet file from ADW

Download the wallet file from the Autonomous database console.

From OCI console Autonomous database page > Navigate to Service Console.

In the ADW service console page go to > Administration, click on “Download Client Credentials (Wallet)”.

Next, you need to enter a password to download the wallet. This password is also used as wallet & truststore passwords.

Now you will see a wallet downloaded “Wallet_<DBname>.zip.”

Connect to ADW from the ODI studio

Copy the downloaded wallet file to the ODI client machine.

Open the ODI studio and connect to the repository.

Navigate to Topology > Physical Architecture > Technologies > Right click on Oracle > Click “New Data Server”.

On the New Data Server page, fill in the following details.

Name – <Data Server Name>

User – <ADW username>

Password – <Password to connect ADW username>

Credential File – <Wallet file location on the machine>

Connection Details – <TNS_connection_type>

 

Next, go to JDBC from the left side pane, You should see the JDBC URL is auto-populated.

Then you need to manually change the “oracle.net_wallet_location” property values to the correct location.

Now click on Save and Test Connection.

 

Now you will see the connection is Successful.

Do you need help with your Oracle OCI implementations? Please drop a line here. Our Oracle OCI experts will contact you promptly.