This graphic describes Multiple Database Topology, with Client installed on one computer, and Oracle Database installed on both Server 1 and Server 2.

  1. One Oracle Database is installed on the Server 1 computer. The Oracle Database contains a Repository.

  2. The other Oracle Database is installed on the Server 2 computer. The Oracle Database contains a Repository, a Target Schema, Source Schema 1 and Source Schema 2.

  3. Oracle Warehouse Builder Control Center Service that is installed on Server 1 computer is not used.

  4. Oracle Warehouse Builder Control Center Service that is installed on Server 2 computer deploys and executes on the Map of the Target Schema in the Oracle Database on Server 2.

  5. The Design Center is installed on the client computer, and it manages the design inside the Repository that is in the Oracle Database (on the Server 1 computer). It also deploys and executes on Oracle Warehouse Builder Control Center Service (on the Server 2 computer).

  6. The Local OC4J service is installed on the client computer, and it contains the Browser Server. It reports on the Repository in the Oracle Database (on the Server 1 computer), and it reports on the Audit Tables that are in the Workspace of the Repository in the Oracle Database that is on Server 2 computer. It also receives and updates Oracle Warehouse Builder Browser's Design Reports and Audit Reports (on the client computer).

  7. Oracle Warehouse Builder Browser is installed on the client computer, and it receives and updates Local OC4J service's Design Reports and Audit Reports (on the client computer).