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 a wallet for direct connectivity. Use the Oracle Autonomous Transaction Processing Adapter to execute SQL queries or stored procedures in the Oracle Autonomous Transaction Processing database. For example, quotes in Oracle CPQ Cloud can be created as Orders in the Oracle Autonomous Transaction Processing database by executing 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 a wallet for direct connectivity to connect to the Oracle Autonomous Transaction Processing - Shared (ATP-S) database in place of using the on-premises connectivity agent.

  WARNING:

  For direct connections (configured without using the connectivity agent), the Oracle Autonomous Transaction Processing Adapter can only be used for making outbound invocations as an invoke connection. This type of Oracle Autonomous Transaction Processing Adapter-specific connection cannot be configured as a trigger connection in an integration. Use cases related to inbound polling must be implemented using the scheduled orchestration integration pattern.
• Support for accessing an Oracle Autonomous Transaction Processing – Dedicated (ATP-D) database with a wallet-based connection that uses the connectivity agent.
• Support for integrating an Autonomous Transaction Processing - Shared (ATP-S) database with a private endpoint. Integration is achieved with a wallet-based connection that uses the connectivity agent. See Configure Connection Security.
• Support for the bulk data import operation. This feature is supported for the following scenarios:
  • When using direct connectivity (that is, without use of the connectivity agent)
  • When using the Oracle Autonomous Transaction Processing - Shared (ATP-S) database
  • With the comma-separated value (CSV) data format only.

  A typical bulk data import use case with the Oracle Autonomous Transaction Processing Adapter consists of getting a data file from an FTP server or application (such as an HCM payroll system), placing the file in an object storage bucket, and placing the file contents into an Oracle Autonomous Transaction Processing - Shared (ATP-S) database. The file can be in a format expected by the database (for example, a CSV file) or in a format that the database is not expecting (for example, XML or JSON). In that case, Oracle Integration is used to translate the format into a CSV format that the database expects.

• Support for creating integrations with Oracle Autonomous Data Warehouse.

• Support for invocation of stored procedures in the Oracle Autonomous 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.

Cloud Database Connectivity Support

This table describes cloud database connectivity support in Oracle Integration. Review these capabilities and use the adapter (Oracle Autonomous Transaction Processing Adapter, Oracle Autonomous Data Warehouse Adapter, or Oracle Database Cloud Service Adapter) appropriate to your environment.

Database	Direct Connectivity with Wallet	Connectivity Agent with Username Token Policy	Connectivity Agent with Wallet
Autonomous Database - Shared (Oracle Autonomous Transaction Processing - Shared, Oracle Autonomous Data Warehouse - Shared)	Supported	Not supported	Supported
Private Endpoint for Autonomous Database - Shared (Oracle Autonomous Transaction Processing - Shared Private Endpoint, Oracle Autonomous Data Warehouse - Shared Private Endpoint)	Not supported	Not supported because Oracle Autonomous Transaction Processing - Shared supports only wallets	Supported
Autonomous Database - Dedicated (Oracle Autonomous Transaction Processing - Dedicated, Oracle Autonomous Data Warehouse - Dedicated)	Not supported	Supported	Supported
Autonomous Database - Dedicated (Oracle Autonomous Transaction Processing - Dedicated Private Endpoint, Oracle Autonomous Data Warehouse - Dedicated Private Endpoint)	Not supported	Supported	Supported
Oracle Database Cloud Service	Supported	Supported	Supported
Oracle Cloud Infrastructure - Bare Metal and Virtual Machine Database Systems (Oracle Database Cloud Service Private Endpoint)	Not supported	Supported	Supported

See Overview of Autonomous Databases and Bare Metal and Virtual Machine DB Systems.