Consolidation of Data into a Central Repository

The scenario describes a sample solution for setting up unidirectional consolidation of data into a central repository using RSO for Oracle components.

A telecommunications company has satellite offices in Walldorf and Singapore that use Oracle to store local customer information. Company headquarters, in Houston, uses Oracle to store company-wide customer information. Replication Agent captures the changes to data at the satellite offices and passes them to Replication Server. Replication Server then applies data changes to the headquarters consolidated Oracle customer database.

To set up unidirectional consolidation into a central repository, the company uses these components:
  • Oracle
  • Replication Server
  • Replication Agent for Oracle
  • ExpressConnect for Oracle
Unidirectional Consolidation into a Central RepositoryThis figure illustrates a sample solution for setting up unidirectional consolidation of data into a central repository using the RSO components.