Oracle Autonomous Transaction Processing Adapter Capabilities

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. For example, quotes in Oracle CPQ Cloud can be created as Orders in the on-premises Oracle database by sending SQL statements or stored procedures using the Oracle Autonomous Transaction Processing Adapter.

The Oracle Autonomous Transaction Processing Adapter provides the following capabilities:

  • 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 creating integrations with Oracle Autonomous Data Warehouse.
  • 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.

    Select the Run a SQL Statement option on the Basic Info page of the Adapter Endpoint Configuration Wizard to execute simple SQL queries. For complex SQL queries, use stored procedures by selecting the Invoke a Stored Procedure option on the Basic Info page of the Adapter Endpoint Configuration Wizard. Stored procedures can reduce the complexity of a SQL query.

  • Support for updating or inserting multiple records in a single request.

  • Support for performing a SELECT operation against database tables.

  • Support for the operations on a table feature, which enables you to model SQL statements with the Adapter Endpoint Configuration Wizard. The operation on a table feature also supports multiple records in a single request.

Note:

In Java, Unicode characters are represented as 2 bytes.

Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical transaction processing and mixed workload applications. See Autonomous Transaction Processing.

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