OWB 11g Progressive Series (0) Oracle Warehouse Builder 11g Architecture and components

This paper is compiled from Oracle documentation

Warehouse Builder 11g Architecture and components

Oracle Warehouse Builder is an information integration tool that can transform data into high-quality information using an Oracle database. The Oracle database is the central component of the Warehouse Builder architecture because it hosts the code generated by the Warehouse Builder repository and Warehouse Builder.

The following illustration shows the interaction of the main components of the Warehouse Builder software.

Design Center is a user interface for designing, managing, scheduling, and deploying ETL processes that can move and transform data. All the metadata associated with the work done in design Center is stored in the Oracle Warehouse Builder repository. The repository is hosted in an Oracle database, and you can use Repository Browser to report the metadata in the repository. Target mode is also hosted in an Oracle database, Warehouse Builder can load data from the ETL process that you perform through the control Center Service into target mode.

Figure from Oracle's help document

Again, we can simply think of it as a single server that contains the client-side components and server-side components, as if I was talking a bit of nonsense.

To cut to the chase, look at what the component role is in the diagram:

Design Center:

Design Center provides a graphical interface for defining sources as well as designing goals and ETL processes.

Control Center Manager:

Control center Manager is also located in the design Center client where you can deploy and execute the ETL process. Control Center Manager is a comprehensive deployment console that allows you to view and manage all aspects of your deployment.

Target schema (destination mode):

Target mode is the goal that you load data and data objects (such as cubes, dimensions, views, and mappings) designed in design Center into them. The target pattern contains Warehouse Builder components such as synonyms that enable the ETL map to access audit/service packages in the repository. The repository is used to store all information related to the target schema, such as execution and deployment information.

Note that the target mode is not a Warehouse Builder software component, but an existing component of an Oracle database. This allows you to associate multiple target schemas with a single Warehouse Builder repository. You can implement one-to-one or many-to-many relationships with one (multiple target patterns for a repository).