Oracle Warehouse Builder (OWB) is a comprehensive tool for ETL (extract, transform and load), relational and dimensional modeling, data quality,
data auditing, and full lifecycle management of data and metadata. With the Oracle Database as its metadata repository and transformation engine, OWB provides superior
performance, security, and scalability.
The basic OWB functionality for designing and maintaining an Oracle data warehouse is included in the Oracle Database licenses. Other options such as
profiling data or new, more flexible options for accessing heterogeneous data stores require additional licensing. For more information, refer to Licensing.
Installation
Beginning with the 11g release, the Oracle Database includes the Warehouse Builder design repository and design client
pre-installed. To start using any of the OWB 11g releases:
Unlock the pre-installed design repository as described in the Installation Guide.
For additional design clients, install the OWB standalone software onto
client computers.
For Oracle Database 10gR2 and earlier Database implementations, you need to install the OWB standalone software on both the Database and client computers.
You can run OWB with various editions and releases of the Oracle Database. For example, you can run OWB 11.2 on the Standard and
Enterprise editions of Oracle Database 10.2, 11.1, and 11.2. For more information, refer to Certification.
Bookmark
