SAP HANA Admin - Data Provisioning

SAP HANA Replication allows the migration of data from source systems to SAP HANA database. A simple way to move data from the existing SAP system to HANA is by using various data replication techniques.

System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction systems can stay online during this process. There are three types of data replication methods in HANA system −

  • SAP LT Replication method
  • ETL tool SAP Business Object Data Service (BODS) method
  • Direct Extractor Connection method (DXC)

SAP LT Replication Method

SAP Landscape Transformation (SLT) Replication is a trigger-based data replication method in HANA system. It is a perfect solution for replicating real-time data or schedulebased replication from SAP and non-SAP sources. It has SAP LT Replication server, which takes care of all trigger requests. Replication server can be installed as a standalone server or can run on any SAP system with SAP NW 7.02 or above.

There is a trusted RFC connection between HANA DB and ECC transaction system, which enables trigger-based data replication in HANA system environment.

ETL SAP Data Services Replication

SAP HANA ETL based replication uses SAP Data Services to migrate data from SAP or nonSAP source system to target HANA database. BODS system is an ETL tool used to extract, transform, and load data from the source system to the target system.

It enables to read the business data at the Application layer. You need to define data flows in Data Services, scheduling a replication job, and defining the source and the target system in data store in Data Services designer.

Direct Extractor Connection Method (DXC)

Direct Extractor Connection data replication reuses the existing extraction, transformation, and load mechanism built into SAP Business Suite systems via a simple HTTP(S) connection to SAP HANA. It is a batch-driven data replication technique. It is considered as a method for extraction, transformation, and load with limited capabilities for data extraction.

DXC is a batch-driven process and data extraction using DXC at certain interval is enough in many cases. You can set an interval when batch job executes, for example, every 20 minutes. In most of the cases it is sufficient to extract data using these batch jobs at certain time intervals.

You can check complete details about Data Provisioning in our SAP HANA tutorial −