How to download ATP client credentials (Wallet) and create connection in OIC

 ATP stands for Autonomous-Transaction-Processing

It is a fully autonomous Oracle Database service optimized for transaction processing workloads, and workloads with a mix of transactions, analytics, and batch. It is preconfigured for row format, indexes, and data caching to accelerate application performance and real-time operational analytics for Oracle, ISV, and custom-built applications.

In this post we will see how we can  download the wallet and use it to create connection in OIC using JDBC Over SSL security policy.

This wallet is a zip file which contains details like SSL certificate , ojdbc properties etc to enable us connect to ATP from OIC.

We can download as many wallet zip file as we want, but every wallet zip file will  have its on password which we provide while downloading.

Follow the below steps to download the wallet:

Login to OCI console:

 

Click on menu->Oracle Database-> Autonomous Transaction Processing

 

 

Now select the compartment and the ATP Database:

 

 

Click on DB connection in the new window that appears.

 

 

This will display the details like Wallet, TNS Name etc.

click on Download Wallet and provide any password you want to provide and then click on Download:

 

 

The wallet gets downloaded to our local machine.

Now lets go to OIC to create connection using this wallet.

Click on Integrations->Connections

 

 

 

Click on create and select Oracle ATP as adapter.

 

 

 Provide the details like below:

Service name: TNS Name

Security Policy: JDBC Over SSL

Wallet: Upload the wallet which you downloaded

Wallet Password: Provide the password which you provided to download the wallet

Database Service Username: DB schema or username

Database Service Password: DB user password

 Leave HOST, PORT and SID as Blank

 

 

 

Now test  the connection :

 

 

Save the connection.

We are good to use this in our integrations.