Wednesday, December 26, 2012

Defining Source Data Structures In OWB from an Oracle database



Note: I have used Oracle Warehouse Builder 11.2.0.1

Start the Design Center
Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Design Center

Defining Source Data Structures from an Oracle database

Right click on the "Oracle" under MY_DW_PROJECT -> Databases.
Defining Source Data Structures from an Oracle database
Choose "New Oracle Module".


Defining Source Data Structures from an Oracle database

Click on "Next".

Defining Source Data Structures from an Oracle database

Choose the module name and description. Click on "Next".
Defining Source Data Structures from an Oracle database
Edit the connection details:  Click on "Edit".
Click on "Finish" to create the module. When the module is created, the name is in italic characters. Save it and the italic characters will become normal.

Defining Source Data Structures from an Oracle database

You can validate the module: right click -> Validate

Defining Source Data Structures from an Oracle database

You must have "0 errors" like in this screen.

Note: When a module is created no objects (tables, views, sequences) are related to this module.
Now you must import the remote Oracle data structures in order to create the OWB design.