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
A basic technique for loading flat files.
(Tip:
External Tables
offer better performance.)
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.
Optimize Mapping Performance
Take full advantage of hints and other features to run your ETL faster.
