1. Using the Oracle Database Cloud Service Adapter with Oracle Integration Generation 2
  2. Understand the Oracle Database Cloud Service Adapter
  3. Oracle Database Cloud Service Adapter Capabilities

Oracle Database Cloud Service Adapter Capabilities

The Oracle Database Cloud Service Adapter enables you to integrate Oracle Database Classic Cloud Service with Oracle Integration through use of the connectivity agent. The Oracle Database Cloud Service Adapter provides support for integrating with one-node database systems on either bare metal or virtual machines, and two-node real application cluster (RAC) database systems on virtual machines offered by Oracle Cloud Infrastructure using the connectivity agent. Use the Oracle Database Cloud Service Adapter to poll for new and updated records for processing in Oracle Integration. For example, any new record added to the Employee table in your Oracle Database Classic Cloud Service can be synchronized with Oracle HCM Cloud using Oracle Integration. In addition, use the Oracle Database Cloud Service Adapter to execute SQL queries or stored procedures in Oracle Database Classic Cloud Service. For example, quotes in Oracle CPQ Cloud can be created as Orders in Oracle Database Classic Cloud Service by sending SQL statements or stored procedures using the Oracle Database Cloud Service Adapter.

Note:

Apart from using the Oracle Database Cloud Service Adapter to integrate with Oracle Database Classic Cloud Service, it can only be used for existing Oracle Database Classic Cloud Service integrations to work with Oracle Autonomous Transaction Processing Cloud Service. Use the Oracle Autonomous Transaction Processing Adapter for any new integrations built to connect with an Oracle Autonomous Transaction Processing instance database. Oracle Autonomous Transaction Processing integration-related capabilities/enhancements are only introduced in the Oracle Autonomous Transaction Processing Adapter.
The Oracle Database Cloud Service Adapter provides the following capabilities:
  • Support for integrating an Oracle Database Classic Cloud Service database with a private endpoint. Integration is achieved with a wallet-based connection that uses the connectivity agent. See Configure Connection Security.

  • 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 a comprehensive database workbench for configuring SQL statements to perform SELECT, INSERT, and UPDATE operations on up to four tables.

  • Support for non-JDBC (PL/SQL) datatypes in outbound invocations of stored procedures.

  • Support for invocation of stored procedures in the Oracle database.

  • Support for automatically generating and presenting the request and response data definitions in the mapper based on the SQL Query/DML statements/stored procedure configured through the adapter. This feature generates an XSD from a PureSQL statement provided by dynamically querying the table.

  • Support for polling new and updated records for processing in the Oracle database. The Oracle Database Cloud Service Adapter supports distributed polling and multithreading. Distributed polling helps eliminate duplicate polling of the same records while multithreading provides optimum performance.

  • Support for a logical delete polling strategy. This strategy involves updating a special field on each row once it is processed.

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

  • Support for database fault mapping.

  • Support for processing message payloads up to 10 MB in size. In the case of polling, you must set the Rejected Value property to REJECTED on the Polling Strategy and Options page. If the incoming message is greater than the 10 MB threshold size, that particular record is updated to REJECTED instead of READ. If the outbound operation returns a response greater than the 10 MB threshold size, the response message is ignored and a fault response is sent to the calling client.

    Note:

    In Java, Unicode characters are represented as 2 bytes.
  • Support for connecting to the Oracle Database Classic Cloud Service instance with SSL, thus avoiding the need to install and configure the connectivity agent. You select and configure Oracle Wallet as the security policy on the Connections page.

    WARNING:

    For direct connections (configured without using the connectivity agent), the Oracle Database Cloud Service Adapter can only be used for making outbound invocations as an invoke connection. This type of Oracle Database Cloud Service 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.
    See Prerequisites for Creating a Connection.

    Note:

    The Oracle Wallet security policy can only be used when the database is SSL-enabled.

The Oracle Database Cloud Service Adapter is one of many predefined adapters included with Oracle Integration. You can configure the Oracle Database Cloud Service Adapter as a target or invoke connection in an integration in Oracle Integration.