Oracle Read - Oracle Blogs Aggregator

Here’s a quick post to illustrate the web services OWB exposes for Change Data Capture (CDC) it follows on from Mark Rittman’s post on CDC using OWB 11gR2 to capture changes from SQL Server using the open connectivity code templates in 11gR2. The web services can be orchestrated in OWB’s process flow or Oracle BPEL for example to script the CDC setup and initialization; starting the CDC, defining subscribers etc. In ODI you can define this kind of orchestration in the package object.
Using Mark’s example, if you right-click on the module note you can create a bunch of web services

…click on the title to read the full article…