1. Using the IBM DB2 Adapter with Oracle Integration 3
  2. Understand the IBM DB2 Adapter
  3. About IBM DB2 Adapter Use Cases

About IBM DB2 Adapter Use Cases

The IBM DB2 Adapter can be used in scenarios such as the following:

  • You can create an integration that includes a SOAP Adapter connection on the trigger (inbound) side and a IBM DB2 Adapter on the invoke (outbound) side. For example, when configuring the invoke IBM DB2 Adapter, you can select a stored procedure that enables you to pass an employee ID as an inbound parameter from the SOAP Adapter to an on-premises IBM DB2 Database to retrieve additional information about the employee (first name, last name, email ID, and so on). The request is sent to the on-premises agent for execution. The employee results are then returned to Oracle Integration.

  • You an configure the IBM DB2 Adapter as a trigger that can poll on a table. It can poll on a table with a logical delete column and send the records to the outbound adapters.