OSB : DB Adapter-Poll - Delete Logical Records using Oracle Service Bus 12c
In this section, we will see how to use the Logical delete of records from table for polling tables from database. Note: For creating connection factory, datasource, deployment , DBAdapter for poll and merge please verify my blog page OSB : DB Adapter-Poll - Delete Physical Records using Oracle Service Bus 12c Here will explain only the essence of logical delete and how the data is picked and processed. 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 Create table and insert records . In this option we have to add one more column for performing the logical delete just by updating the values. Here we are making logical delete on column "STATUS" by changing poll value from "N" to "Y" Physically the data will be available in the database but the process wont pick it as the condit...