DATA Provisioning & Replication in SAP HANA

What is DATA Provisioning?

DATA Provisioning is a process of creating, preparing, and enabling a network to provide data to its user. Data needs to be loaded to SAP HANA before data reaches to the user via a front-end tool.
All these processes are referred as ETL (Extract, Transform, and Load), and detail is as below-

Extract – This is the first and sometimes most difficult part of ETL, in which data are extracted from the different source system.
Transform – In the Transformation Part, series of rules or functions is defined for the data extracted from the source system, for loading data into the target system.

Load – The load phase loads the data in the target system.

Replication in SAP HANA

SAP HANA supports two type of Provisioning tools –

SAP HANA Built-In Provisioning Tool
1. Flat File
2. Smart Data Streaming
3. Smart Data Access (SDA)
4. Enterprise Information Management(EIM)
5. Remote data
External tool supported by SAP HANA
1. SAP Landscape Transformation
2. SAP Business Objects Data Services
3. SAP Direct Extractor Connection
4. Sybase Replication Server

At present, there are main methods of data provisioning for SAP HANA, these are –

Methods of Data Provisioning	Description
SLT	SLT (“SAP Landscape Transformation Replication Server”) running on the SAP Net Weaver Platform. SLT is an ideal solution for Real-Time and Schedule time replication for SAP and non-SAP source system.
SAP DATA Services	SAP DATA Services is a platform for designing of ETL processes with a graphical user interface.
DXC	DXC stands for Direct Extractor Connect is a batch driven ETL tool.
Flat File Upload	This option used to Upload data (.csv, .xls, .xlsx) to SAP HANA.

SAP HANA SLT Road Map

SAP HANA SLT Road Map is as below – DATA Provisioning through SLT require RFC/DB connection to SAP/Non-SAP Source System and a DB connection for SAP HANA database. On SAP SLT server, we define Mapping and Transformation. Below is a roadmap for data provisioning through SLT.