Oracle Warehouse Builder (OWB) Architecture & Components

OWB is a datawarehousing solution from oracle that has features for designing,implementing,managing data warehouses.It is made up of the following components: 1) Design centre - It is a browser based user interface used to design the ETL processes. 2) Repository - The database used to store the metadata about OWB.It can be hosted in Oracle Database10gR2(standard edition,enterprise edition),Oracle Database 11g(standard edition,enterprise edition).Personal and express editions are not supported. Repository assistant can be used to create workspaces in Repository that is used to isolate development,test,production environments. It has mappings to target schema which is the table that stores the OWB data after mapping and process flows. 3) Repository Browser - It is a user interface used to browse metadata,monitor and view metadata in the repository. 4) Control centre manager - It is a part of design center which manages communication between repository and design centre. 5) Control centre service - It is a server side component that manages the target schema operations. Oracle Workflow (2.6.4 and higher versions) are an integral part of latest OWB release. In previous versions it is imperative to download and install them seperately. Oracle workflow is used for process flows