Model Sources and Targets
Connect to Oracle Databases
Set up locations to connect to database sources and targets. This generic discussion applies to Oracle and non-Oracle databases.
Import Design Metadata from Data Sources
Pull definitions of existing objects from databases and applications into your project.
Connect through Gateways and ODBC
Use Oracle heterogeneous services to access non-Oracle data sources and targets.
Design Relational Objects
Define source and target relational database objects using the OWB Design Center.
Connect through JDBC
Work with a wide variety of non-Oracle sources without using Oracle gateways.
Design Cubes and Dimensions
Take advantage of OWB's advanced support for dimensional objects in the Oracle database.
Access Flat File Sources
Use delimited files, fixed-length files, binary files and XML files as sources in your ETL mappings.
Sample Flat Files to Derive Structure
Let OWB help you figure out the contents and structure of your flat file data.
Integrate Enterprise Application Data
Include SAP R/3 sources, and Oracle E-Business Suite, Siebel, Peoplesoft and MDM hub applications as sources or targets in your ETL mappings.
Set up Flat Files as Targets
Set up structure of supported flat file source and target types (delimited, fixed-length, binary and XML files).
Integrate with Oracle Business Intelligence Tools
Generate metadata for OBI SE (Discoverer) and OBI EE based on your warehouse design.
Import COBOL Copybook Metadata
Import accurate design metadata for mainframe data from the source, instead of sampling
