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
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 ).
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.
No comments:
Post a Comment