Oracle by Example Series:

Oracle Warehouse Builder 11g

Note: This version of the 'Getting Started' Oracle by Example course is written for OWB 11g Release 1, with differences in setup scripts, screenshots, and text from the previous version of OWB 10g Release 2.

Getting Started

What Is Warehouse Builder?

Oracle Warehouse Builder 11g is an enterprise business intelligence integration design tool that manages the full life cycle of data and metadata for Oracle Database 11g. It provides an easy-to-use, graphical environment to rapidly design, deploy, and manage business intelligence systems. Oracle Warehouse Builder 11g:

• Enables the extraction, transformation, and loading of data to produce quality information in the Oracle database
• Protects and leverages customer investment in the Oracle technology stack through data and metadata integration

You learn how to use Oracle Warehouse Builder to design, build, and manage your data warehouse, data mart, or business intelligence system. The prototype throughout the product is that you import definitions, define target structures, validate the structures, generate the code to implement the structures, and deploy the structures to the target environment. After it is deployed, Warehouse Builder assists in the daily maintenance as well as monitoring of the deployed system. You learn how Warehouse Builder leverages your Oracle database investments and integrates with other Oracle tools.

Click the links below to open each lesson. To successfully complete the hands-on steps, work through the lessons in the order given below.