Wednesday, April 11, 2012

HANA: The mystery around data replication in HANA

Hello guys,

Nowadays, everyone talks about HANA.. have you ever wondered how the data is replicated in HANA from ERP or legacy systems in order to leverage the potential of HANA..
There are 3 possible ways tp achieve the same, namely:

  1. Sybase replicator
  2. Data services from BOBJ
  3. SLT Replicator
I will talk about SLT Replicator  (SAP Landscape Transformation):
SLT Replicator is the tool which allows Real-time data repliation into HANA systems.
The technology is based on Trigger-based approach which is supported by almost all database providers.
This involves few basic steps:

  • Create triggers on the source machine based on your requirements(business process I must say)
  • Perform Initial data load into HANA machine
  • Start real-time data replication

Do comment or provide your feedback if you need further details on the same.

Cheers,
Sandeep