Oracle Warehouse Builder Architecture

Oracle Database provides Oracle Warehouse Builder (OWB) as part of the standard software when the database is installed. OWB is an integral part of Oracle Database. OWB runs on all versions (Standard Edition, Standard Edition One, Enterprise Edition) and typically all platforms that Oracle Database is certified on and ported to.

The basic OWB architectural components on the server side are:

• The OWB Repository

• Workspaces

• Control Center Service

• Control Center Agent (J2EE Runtime)

• Target Schemas

The main OWB components on the client or desktop side, which are discussed in User Interface Tour, are:

• Control Center Manager

• Design Center

• Repository Browser

Figure: OWB Components illustrates the components that comprise OWB and where they reside and run on clients and servers.