OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c
In 11g OSB, DB adapter can be used by creating it from JDeveloper , then pointing the folder in Eclipse. In 12c, the step is simplified . Similar to SOA BPEL, DB adapter can be created and used using JDeveloper at design time in OSB. A variety of DB operations can be performed using DB Adapter. DML operations like Insert,Merge(Insert/Update),Update,Delete Select operation - Select, Select using primarykey , select using query by example Using Procedure/Function Poll operation for real time data synchronization from tables Execute Pure SQL In this section we are about to see all the Poll related operations to pick the new or changed records from source table and how to MERGE(INSERT OR UPDATE) data using merge option with it to another table. POLL TABLE FOR NEW OR CHANGED RECORDS IN A TABLE: VERSION USED: SOA SUITE 12C - 12.2.1.3 DB 12C - 12.2.0.1.0 SOURCE SCHEMA - SCOTT SOURCE TABLE - EMP_UI TARGET SCHEMA - TGT TARGET TABLE - EMP_UI_TGT