In previous article Overview of Data Provisioning in SAP HANA
, we explained various data provisioning technique in HANA.
In this article, we will learn more about SAP Replication Server (SRS).
SAP Replication Server (SRS)?
SAP Replication Server (SRS) also known SAP Sybase Replication Server is a real-time data integration and movement software.
SAP Replication Server (SRS) moves and synchronizes transactional data including DML and DDL across the enterprise, providing low impact, guaranteed data delivery, real-time business intelligence, and zero operational downtime.
SRS supports log-based replication from and to heterogeneous databases, except for the homogeneous SAP HANA to SAP HANA replication, which is trigger-based. We can use SAP Replication Server to do an initial load as well as replication in real time to SAP HANA, at both table and database level, from these primary databases:
- SAP Adaptive Server Enterprise
- Microsoft SQL Server
- DB2 UDB LUW
- SAP Business Suite running on SAP ASE, Oracle, MSSQL Server or DB2 UDB LUW
- SAP HANA database
Also, SRS includes Replication Agent for SAP HANA (RAH), a light-weight server that replicates data from a primary SAP HANA to a replicate SAP HANA database using trigger-based replication, primarily used for real time data distribution and real time reporting.