1 Overview of Installation and Configuration Architecture

Single Computer Topology

When everything is running on the same computer, the database home for Oracle Database 11g Release 2 contains all the components needed to run Warehouse Builder, as illustrated in Figure 1-1.

Figure 1-1 Single Computer Topology for Oracle Database 11g Release 2

Description of "Figure 1-1 Single Computer Topology for Oracle Database 11g Release 2"

Separate Client and Database Server Topology

If separate computers are being used to run the client and to host the repository, then all computers must have the OWB software installed, as illustrated in Figure 1-2. For the database server installation, Oracle Database 11g Release 2 includes the necessary components. For the client, you must install the OWB software from the standalone install image.

Figure 1-2 Two Computer Topology; Separate Client and Database Server Installations

Description of "Figure 1-2 Two Computer Topology; Separate Client and Database Server Installations"

Multiple Database Topology

If a database on a separate computer is being used to run mappings designed on another database, then all computers must have the OWB software installed, as illustrated in Figure 1-3. For the database servers, the installation for Oracle Database 11g Release 2 includes the necessary components. For the client, you must install the OWB software from the standalone install image.

You must prepare the OWB repository on all database server computers. As illustrated in Figure 1-3, one acts as the design repository (Server1). The additional servers where mappings execute each have their own repository (shown as Server2), which in this case functions as a run-time repository. The Control Center Service on the execution database server deploys and executes the code.

Figure 1-3 Multiple Database Topology

Description of "Figure 1-3 Multiple Database Topology"

Separate Client, Control Center Service, and Database Server Topology

If the OWB client, the Control Center Service, and the repository run on different computers, then all these computers must have the OWB software installed, as illustrated in Figure 1-4. For the database server, the installation media for Oracle Database 11g Release 2 includes the necessary components. For the client, you must install the OWB software from the standalone install image. For the Control Center Service, you can use either type of installation. However, Oracle recommends that you use the standalone image because it installs only the components that OWB requires.

Figure 1-4 Separate Client, Control Service Center, and Database Server Topology

Description of "Figure 1-4 Separate Client, Control Service Center, and Database Server Topology"

Control Center Agent Topology

If separate computers are used to run the OWB client, the Control Center Agent service (CCA), and the repository, then all computers used to deploy or execute OWB code must have installed OWB software, as illustrated in Figure 1-5. For the database server, the installation for Oracle Database 11g Release 2 includes the necessary components. For the client, you must install the OWB software from the standalone install image. For the Control Center Agent service, you can use either install. However, because the standalone image only installs the OWB-required components, Oracle recommends this option.

In some deployments, a Control Center Service is required on a host that does not have an Oracle Database installed. For example, if you use code template-based ETL mappings where part of the mapping executes on a non-Oracle database, then you can run a Control Center Agent on that non-Oracle database host. In such a case, you can install the OWB software on the non-Oracle database host.

Also note that:

• On the non-Oracle database host, the only component of the OWB software that is used is the Control Center Agent. The rest of the software is present but not used.

• The CCA may be located with the OWB client or Server1, in which case no additional installation would be necessary.

• In Figure 1-5, the Map1 has three execution units (a, b, c). The first two are Load Code Templates (LCTs) and the other one is an Oracle Target Code Template.

Figure 1-5 Control Center Agent Topology

Description of "Figure 1-5 Control Center Agent Topology"