The Integration blog covers the latest in product updates, best practices, customer stories, and more.


The power of ATP (Autonomous Transaction Processing) adapter in Oracle Integration

The Oracle ATP Adapter enables you to run stored procedures or SQL statements on Oracle ATP CS as part of an integration in Oracle Integration.

Please note that you could use the ATP adapter to connect to Autonomous Data Warehouse as well.

The Oracle ATP Adapter provides the following benefits:

  • You can invoke a stored procedure.
  • You can run SQL statements.
  • You can perform the below operation on a Table.

              . Insert

              . Update

              . Insert or Update (Merge)

              . Select

The Oracle ATP Adapter is one of many predefined adapters included with Oracle Integration. You can configure the Oracle ATP Adapter as a connection in an integration in Oracle Integration.

Connections define information about the instances of each configuration you are integrating. Oracle Integration includes a set of predefined adapters, which are the types of applications on which you can base your connections, such as Oracle Sales Cloud, Oracle Eloqua Cloud, Oracle RightNow Cloud, ATP CS, and so on.

A connection is based on an adapter. A connection includes the additional information required by the adapter to communicate with a specific instance of an application (this can be referred to as metadata or as connection details). For example, to create a connection to a specific RightNow Cloud application instance, you must select the Oracle RightNow adapter and then specify the WSDL URL, security policy, and security credentials to connect to it.

To create a connection to Oracle ATP CS instance, you must select Oracle ATP adapter and then specify the connection properties given below.

         1. Service Name. <<For example, myatp_tp. You can get the service name from the wallet or administrator can provide you>>

And specify the security properties given below:

          1. Wallet : <<Download the wallet from ATP and upload it here>> Please look at the steps given below to download the wallet from ATP.

          2. Wallet Password: <<Provide wallet password>>

          3. Database Service Username : <<Provide database service username>>

          4. Database Service Password: <<Provide database service password>>

Please find the below screenshot of the ATP connection:

Steps to download the wallet from ATP:

Oracle client credentials (wallet files) can be downloaded from Autonomous Transaction Processing by a service administrator. If you are not an Autonomous Transaction Processing administrator, your administrator should provide you with the client credentials. If you have administrator access, then you can login to service console, go to administration and click on "Download Client Credentials" to download the wallet. Refer here for detailed instructions.


Wallet files, along with the Database user ID and password provide access to data in your Autonomous Transaction Processing database. Store wallet files in a secure location. Share wallet files only with authorized users. If wallet files are transmitted in a way that might be accessed by unauthorized users (for example, over public email), transmit the wallet password separately and securely.                   

Autonomous Transaction Processing uses strong password complexity rules for all users based on Oracle Cloud security standards.

OIC: Oracle Integration eliminates barriers between  business applications through a combination of machine learning, embedded best-practice guidance, prebuilt integration, and process  automation. Oracle Integration is unique in the market by leveraging Oracle application expertise to build an extensive library of adapters to Oracle and 3rd party SaaS and on-premises applications to enable you to deliver new business services faster.

ATP: Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical applications.

Please note that ATP Adapter is available as part of feature flag. Please refer blog on feature flags

The below screenshot demonstrates the use case for retrieving the data from ATP CS and writing into FTP location.


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.