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
Flat File Smart Data Streaming Smart Data Access (SDA) Enterprise Information Management(EIM) Remote data
External tool supported by SAP HANA
SAP Landscape Transformation SAP Business Objects Data Services SAP Direct Extractor Connection Sybase Replication Server
At present, there are main methods of data provisioning for SAP HANA, these are –
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.
SAP HANA SLT Road Map