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 SAP RSO components.

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

To set up unidirectional consolidation into a central repository, the company uses these components:
  • SAP HANA database
  • Microsoft SQL Server
  • SAP Replication Server with ExpressConnect for SAP HANA database
  • Replication Agent for Microsoft SQL Server
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.