Advanced Data Integration

Extract Data from SAP R/3
Use high performance extraction techniques based on ABAP code and fully supported by SAP.

Consume Web Services
Call external SOAP-based web services in process flows.

Create Code Template Mappings
Use ODI knowledge modules in OWB mappings for JDBC, non-Oracle databases, bulk data movement and more.

Schedule OWB Jobs
Use the OWB integrated scheduler to run ETL activities at different times.

Create CDC Mappings
Design OWB code template mappings for change data capture and manage change capture processes from Design Center.

Publish OWB Jobs as Web Services
Expose OWB mappings and process flows as web services, for orchestration from Oracle BPEL or similar tools.

Use Queues for Real-Time ETL
Use queues as sources or targets for batch or trickle-feed data integration.

Whitepaper: ODI-EE and Right-Time Data Warehousing
A closer look at using OWB with CDC, GoldenGate and trickle-feed mappings using OWB's ODI-EE features.

Advanced Data Integration Features