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 –
- 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.
- Oracle wallet file – Java & JDBC thin driver uses wallet files (ewallet.p12 & cwallet.sso) files to connect autonomous database.
- 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.
- An Autonomous database with security rules configured allows connections from the ODI studio client network.
- 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.