Connecting to ADW/ATP using Oracle Integration Cloud

Oracle Autonomous Data Warehouse (ADW) provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance and requires no database administration.

Oracle Integration Cloud( (OIC) makes it very easy to connect to Oracle ADW or Oracle ATP using the upcoming ATP Adapter. 

The same ATP adapter can used to connect to Oracle ADW as well as Oracle ATP. 

Follow the below steps to connect to Oracle ADW/ATP from Oracle Integration Cloud

Pre-requisites

1. ADW/ATP Instance
2. Oracle Integration Cloud Instance
3. As I write this blog, Oracle ATP adapter is under preview. Once can request this adapter by enabling feature flag. Please follow this blog to enable ATP adapter feature flag on your OIC Instance


Once ADW/ATP Instance is successfully created, one needs to get the below details from the instance created in your cloud tenancy.

• Download Client Credentials (Wallet)
• ADW User and Pwd -> This would have been set during the OA instance creation.
• TNS Name
• Wallet Password

Oracle ADW/ATP

Go to your Oracle Autonomous Instance & Click on DB Connection

Figure-1

Download Client Credentials (Wallet) by Clicking on Download. Also note the TNS names mentioned in the connection setting section.

Figure-2

Give a password (Note this password) and click on Download

Figure-3

Unzip the downloaded zip file and open tnsnames.ora in a editor

Figure-4

Search the tnsname noted above and copy the service name.

Figure-5

Oracle Integration Cloud

Create new ATP Connection in your OIC Instance.

Figure-6

Give ATP Connection details and click Create

Figure-7

Give ATP/ADW Instance Details as captured above.

Figure-8

Test the connection

Figure-9

Note:

Make sure you use the correct service name captured from Figure-5 while entering connection details. The error [Cause: Cloud-0005] will be encountered if there is any mismatch.

Figure: 10