X

PaaS Partner Community

Oracle Autonomous Transaction Processing Adapter in OIC by Ankur Jain

Juergen Kress
PaaS Partner Adoption

image

The Oracle Autonomous Transaction Processing Adapter enables you to integrate the Oracle Autonomous Transaction Processing database with Oracle Integration through use of direct connectivity. Use the Oracle Autonomous Transaction Processing Adapter to execute SQL queries or stored procedures in the Oracle database.

In this article, we are going to explain capabilities of ATP adapter and how to connect to Autonomous Transaction Process(ATP) in Oracle Integration Cloud(OIC) using OOTB Oracle ATP adapter.

In my earlier article, I have explained how to provision the Autonomous Transaction Process(ATP) instance. Kindly see the article, before you go ahead in this article.

Capabilities of Oracle Autonomous Transaction Processing Adapter
  • Support for using direct connectivity to connect to the Oracle Autonomous Transaction Processing database in place of using the on-premises connectivity agent.
  • Support for invocation of stored procedures in the Oracle database
  • Support for non-JDBC (PL/SQL record and PL/SQL table) datatypes in outbound invocations of stored procedures
  • Support for execution of DML statements and SQL queries: Select, Insert, Update, and Delete. Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

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.