Understanding SLT with Replication

• SLT is the SAP first ETL ( Extract , Transform , Load ) a tool that allows you to load and replicate data in real-time  from the source system and Non-Source System into SAP HANA Database.
• SAP SLT server uses a trigger-based replication approach to pass data from source system to target system.
• The connection between SAP SLT and SAP Source is established as RFC connection.
• The connection between SAP SLT and SAP HANA is established as a DB connection.
• Even when we execute Replicate option, system will Load entire data that is in the base table (APP Tables ) to SAP-HANA at first time.
• After Load is complete , system changes the status from Load to Replicate.
• Once status changed to replicate 2 additional objects are created

1. DB triggers : is a small piece  procedural code , that monitors for any events ( Insert , Delete , Modify , update etc ) that take place in Table( APP Table ).
2. Logging Tables : If DB triggers , then logging Tables will stores triggered data ( Modified data in App tables).

• Read Modules : Reads the data from Logging table and using RFC connection data sends to the SLT Server.
• In SLT Server data goes for structure mapping and Transformation.
• Using the  Write modules and DB connection , SLT system writes the data into SAP-HANA.
• For Ex: if we changes any data in SAP-ECC , within a millisecond data will available in SAP-HANA in Real time.