A telecommunications company has satellite offices in San Francisco and Chicago that use Microsoft SQL Server to store local customer information. 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. Then, Replication Server applies data changes to the headquarters’ consolidated customer database, which is stored in Oracle.
To set up unidirectional consolidation into a central repository, the telecommunications company uses the following components:
Replication Server
Replication Manager (RM)
ECDA Option for Oracle
Replication Agent for Microsoft SQL Server
See Chapter 1, “Introducing Replication Server Options,” for descriptions of specific components.
Figure 2-1 illustrates this sample scenario.
Figure 2-1: Unidirectional consolidation into a central repository
