Design ETL Processes
Create Basic Relational Mappings
Extract, transform and load data among relational sources and targets, including databases, flat files, and ERP applications.
Create Process Flows
Design multi-step data integration processes using a wide variety of activities and complex flow of control.
Load Dimensions and Cubes
Use OWB's advanced dimensional object support for ETL with dimensions and cubes, including SCD Types 1, 2 and 3.
Deploy OWB Jobs
Push your objects and ETL logic out to your sources and targets.
Use SQL*Loader Mappings for Flat Files
Get maximum load performance on large data volumes.
Execute OWB Jobs
Run your ETL, data quality or other OWB jobs from the OWB Control Center Manager.
Extract Data from SAP R/3
Use high performance extraction techniques based on ABAP code and fully supported by SAP.
View OWB Job Results
Find out what happened to your deployments and executions, including scheduled executions.
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.
Consume Web Services
Call external SOAP-based web services in process flows.
Optimize Mapping Performance
Take full advantage of hints and other features to run your ETL faster.
