Describes a sample solution for setting up unidirectional consolidation of data into a central repository using RSO components.
A telecommunications company has satellite offices in San Francisco and Chicago that use Microsoft SQL Server to store local customer information. Company headquarters, in Boston, uses Oracle to store company-wide customer information. Replication Agent captures the changes in Microsoft SQL Server 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
- Microsoft SQL Server
- Replication Server
- Replication Agent for Microsoft SQL Server
- ExpressConnect for Oracle
