Distribution of Enterprise Data Between Multiple Central Databases

The scenario describes a sample solution for replicating Oracle data using RSO for Oracle components.

A large regional supplier maintains its enterprise data in a central database in Hong Kong before merging with a second regional supplier of comparable size in Walldorf. The Hong Kong and Walldorf enterprises maintain data on Oracle systems, and both organizations implement a bidirectional replication system.

To set up bidirectional, enterprise-wide replication, the Hong Kong enterprise uses these components:
  • Oracle
  • Replication Server
  • Replication Agent for Oracle
  • ExpressConnect for Oracle
Bidirectional, Enterprise-Wide ReplicationThis figure describes bidirectional replication of Oracle data using the RSO for Oracle components.