DB2 Adapter Capabilities

The DB2 Adapter enables you to integrate the DB2 database residing behind the firewall of your on-premises environment with Oracle Integration Cloud Service through use of the on-premises connectivity agent. Use the DB2 Adapter to poll for new and updated records for processing in Oracle Integration Cloud Service. For example, any new record added to the Employee table in your DB2 database can be synchronized with Oracle HCM Cloud using Oracle Integration Cloud Service. In addition, use the DB2 Adapter to execute SQL queries or stored procedures in the DB2 database. For example, quotes in Oracle CPQ Cloud can be created as Orders in the on-premises DB2 database by sending SQL statements or stored procedures using the DB2 Adapter.

The DB2 Adapter provides the following capabilities:

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

  • 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 generating XSD from PureSQL. 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 DB2 database. The DB2 Adapter supports distributed polling. Distributed polling helps eliminate duplicate polling of the same records.

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

To install the on-premises agent, see Downloading and Running the On-Premises Agent Installer in Using Oracle Integration Cloud Service.

The DB2 Adapter is one of many predefined adapters included with Oracle Integration Cloud Service. You can configure the DB2 Adapter as a connection in an integration in Oracle Integration Cloud Service. For information about Oracle Integration Cloud Service, connections, and integrations, see the following sections: