Overview of Oracle Warehouse Builder and Its Benefits

Oracle Warehouse Builder (OWB) is a full-featured data integration, data warehousing, data quality and metadata management solution designed for the Oracle database. OWB is an integral part of Oracle Database 11g Release 2 (11.2) and is installed as part of every database installation (other than Oracle Database XE).

The major feature areas of OWB include:

• Data modeling

• Extraction, Transformation, and Load (ETL)

• Data profiling and data quality

• Metadata management

• Business-level integration of ERP application data

• Integration with Oracle business intelligence tools for reporting purposes

• Advanced data lineage and impact analysis

OWB is also an extensible data integration and data quality solutions platform. OWB can be extended to manage metadata specific to any application, and can integrate with new data source and target types, and implement support for new data access mechanisms and platforms, enforce your organization's best practices, and foster the reuse of components across solutions.