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 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 tool –

1. 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
2. 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 –

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.