Data Provisioning

There are many ways to propagate data in SAP HANA:

1. SLT (SAP Landscape Transformation) -- trigger based replication
2. SAP DS (SAP Data Services) -- ETL based replication
3. SAP RS (SAP Sybase Replication Server) -- log based replication
4. DXC (Direct Extractor Connection) -- is Business Content data source in SAP BW.
   DXC generally applies more to SAP BW on SAP HANA than to SAP HANA as a data warehouse for analytics.

SAP Landscape Transformation

SLT / Trigger-based replication is the primary data-provisioning mechanism for SAP source system, for ex: SAP ERP. Some notes for SLT:

• SLT Requires the installation of an SLT Replication Server.
• Both data and metadata from tables can be replicated to SAP HANA with this technology.
• The SLT Replication Server record any changes to a set of designated tables inside the source system and makes them available for a pull into the SAP HANA database.
•  The SLT Replication Server intercept the changes to the table in the application layer when transaction are executed in SAP ERP by detecting the triggers that are sent to the database to update tables, making this solution database independent on the SAP ERP side.
• The replication of data to SAP HANA can be set up according to a schedule or as a continuous, near real-time feed.
• You can filter data within a table and set which field should come accross to SAP HANA
• The SLT Replication Server is an ABAP-based technology that leverages serveral proven existing system landscape optimization technologies from SAP, which are now updated to work for SAP HANA
• The SLT Replication Server can also be used for non-SAP sources that meet some basic database criteria that enable the SLT Replication Server to capture the changes in the source system.

SAP Data Services