Real Time Replication for HANA enhancement in SRS 15.7 SP200
Big news! SAP Replication Server 15.7 SP200 is now G.A. It marks another major milestone in SAP Replication Server (SRS) history. This release delivers enhanced replication features for SAP HANA, SAP Business Suite on SAP ASE and SAP Data Services. This is the first in a series of blogs that will focus on each of these areas of functionality in detail.
In this blog, I am focusing on the new functions added in SRS to expand SAP HANA replication support. SAP Replication Server 15.7 SP200 introduces several major new functions for SAP HANA database replication:
- Replicate SAP Business Suite databases into SAP HANA database
- Database replication definition and subscription
- Data Definition Language (DDL) commands replication into SAP HANA database
- Simplify installation and configuration of Replication to SAP HANA using Replication Management Agent (RMA)
- Support for SAP HANA as a source database
Replicate SAP Business Suite database into SAP HANA database
In my last blog, we talked about SRS support for non-Business Suite replication into the SAP HANA database, which was available as part of SRS 15.7 SP100, introduced last year. In this newest release, SRS 15.7 SP200 now supports database replication from SAP Business Suite applications that use cluster tables to SAP HANA. SAP Business Suite defines logical tables in the application layer that are clustered and stored in physical tables in the database. A cluster table is a compressed representation of a materialized natural join of a number of tables. When performing materialization and replication of a database containing cluster tables, SRS performs de-clustering of the data before sending transactions to the SAP HANA, essentially converting cluster tables to transparent tables in SAP HANA. Please note, this release doesn’t support replication of pool tables in SAP Business Suite. With this capability, SRS completes its market coverage from custom, 3rd party applications to SAP Business Suite applications. Users can readily take advantage of real-time transactional replication from SAP Replication Server.
Database replication definition and subscription
SAP Replication Server 15.7 SP200 supports real-time replication at database level, in addition to table level, which was the practice since SRS’s inception. The database-level, real-time replication greatly simplifies replication configuration involving databases with many tables and reduces maintenance overhead. This feature is designed to replicate from SAP Business Suite applications into SAP HANA database(s), where there are typically many tables involved for replication. Custom or 3rd party application users with much less tables will also benefit from this feature for ease of use and reduced maintenance overhead.
Data Definition Language (DDL) commands replication into SAP HANA database
Data Definition Language (DDL) commands, such as create table, alter table, rename table and drop table, are frequently performed due to application changes to meet business requirements. For many years, SRS has been supporting DDL replication in homogeneous replication environment, such as ASE to ASE, Oracle to Oracle etc. With this release, SRS supports DDL command replication into SAP HANA, essentially in a heterogeneous replication environment. SAP Replication Server automatically alters the database replication definition to reflect any DDL changes in a database that is marked for replication at the database level, when configured appropriately. For example, if a create table command is executed against a database marked for replication, data is automatically configured for replication in the newly added table. SRS will reconstruct the DDL command to the replicate HANA database’s specific syntax, and data type mapping will be applied from the primary database to the replicate HANA database.
Simplify installation and configuration of Replication to SAP HANA using Replication Management Agent
To simplify installation and configuration SAP Replication Server, SRS introduced a new management framework, Replication Management Agent (RMA) in SRS 15.7 SP200. It is a distributed management agent that you can use to set up and manage replication for HANA. RMA provides automated setup, configuration and materialization, monitoring, and administration for SAP Business Suite, 3rd party and custom applications on supported databases. The typical RMA architecture is shown below.
Both GUI and command line formats are available to perform installation, configuration, and monitoring tasks.
Support for SAP HANA as a source database
SAP Replication Server introduced Replication Agent for SAP HANA (RAH) to replicate both DML and DDL from HANA to HANA. With RAH, you can configure, manage and deploy HANA to HANA replication models based on your use case requirements. Both initial load materialization and replication are supported. This feature is primarily designed for real-time data distribution and reporting use cases.
SAP Replication Server 15.7 SP200 has been designed to enhance real-time replication for HANA to deliver performance, scalability and simplicity to enterprise customers who require real-time transactional replication for HANA. Do you think any of these features will benefit your environment?
Hi,
What format (Row store or column store) data has been read by RepServer? Can RAH read by row by row as it does in case of ASE or RAH can provide data in Column format as well?
Nishar
Hi Bill Zhang
Correct me if i'm wrong. There's no SRS for HANA2HANA, but just replication agent?
Thanks,
Nicholas Chang
Nicholas-
You are correct, no SAP Replication Server (SRS), just Replication Agent for Hana (RAH).
Hi Kenneth,
Thanks for the info. Do you have a concrete answer on can RAH works site2site migration? Something like DB migration.
Thanks,
Nicholas Chang
RAH doesn't provide site-to-site migration. It will materialize tables that aren't on the target database, but no other DB objects. If you are still interested in Hana to Hana trigger-based replication, I suggest you look into using the HanaAdapter in SAP Hana Smart Data Integration (SDI).
Hi Kenneth Brozovich
Do you mean that we can use HANA SDI to replicate entire HANA DB, from source to target?
If yes, would you mind to share more on how exactly it works and any reference?
Thanks,
Nicholas Chang
Hopefully this will answer your questions:
http://scn.sap.com/community/developer-center/hana/blog/2014/11/27/hana-sp9-data-provisioning--overview