This blog will give you step by step procedure for Trigger-Based Data Replication
from ECC/S4Hana to HANA system using SAP Landscape Transformation (SLT) also called Real time data Replication.
What is SLT ?
SLT allows you to load and replicate data in real-time or schedule data from the source system into SAP HANA Database.
The source system maybe ECC, S4H & Non SAP as well.
The source system maybe ECC, S4H & Non SAP as well.
SAP SLT Architecture between SAP System and SAP HANA (Showing 3 System Connetion)
As showing like the above image the landscape contain 3 Systems
Source System :- The above picture will give an overview idea about the SLT Architecture.
Here the source system showing SAP with Hana DB but we can use any other DB & Non-sap system as well.
SLT :- The system 7.5 With DIMS (SLT Component Name - DMIS)
DMIS Version should be same in SLT & Target systems.
We can use SLT System as NW version 7.4 SP 08 onward.
All the SLT Connection configuration we are going to do in this system.
Target System :- This system should be in Hana DB. Here HANA 2.0 SP 03 Version is using.
Below are the Installed Software products in SLT System
To Upgrade the system with SLT Component (DMIS) we need to Generate the Stack file from Maintenance Planner & Upgrade the system using SUM Tool.
DMIS Version should be same in all the 3 systems, from S/4HANA 1610 System onward's the DIMS component is integrated with S4Core Layer. So need to upgrade the Source & Target system if it required.
DIMS Comparability in S/4HANA - https://launchpad.support.sap.com/#/notes/2572945
To configure SLT, Login to the SLT system and execute the Tcode LTR / LTRC
The below screen showing the LTRC Screen. We can Create, Edit, Monitor the SLT Configuration here,
Click on 'Create' option (Red Marked Option)
Give the Configuration Name & Description,
While Creating a SLT Configuration to replicate the tables system will create one Schema on the target DB.
The configuration name should be the Schema name,
The configuration name should be the Schema name,
From SLT system to the source system we need to create a RFC to catch the data. If it is SAP System we can create abap connection & if it is non sap other connection type.
This step we need to select the RFC name to the source system
Also if you are planning to take the data from p particular client select the 'Read from Single Client' option otherwise deselect it,
This step we need to select the RFC name to the source system
Also if you are planning to take the data from p particular client select the 'Read from Single Client' option otherwise deselect it,
Here Select the Target DB Name First,
Then Give the Target System User Name, Password & Port Number
If the HANA DB server is multi-tenant, then we should carefully give tenant DB Port Number
(This step onward i'm attaching LTR screen. LTR & LTRC Configuration screen are same, one is browser based & the other is GUI)
If the HANA DB server is multi-tenant, then we should carefully give tenant DB Port Number
(This step onward i'm attaching LTR screen. LTR & LTRC Configuration screen are same, one is browser based & the other is GUI)
Once the Configuration Completed. Again LTRC T-code and Click your configuration Name,
The data replication may take some time, all the status of the data replication you can see under
LTRC ---> Configuration Name Screen
You can see the over all status at the top & Table status at 'Current Action' Column
If you are only using Source & Target system then SLT System is not required.
Thanks for reading, Please share your valuable feedback.
Click on 'Data Provisioning' on the opened screen,
You will get the below Screen,
Select Start Replication option & Enter the Table names that you want to replicate.
The data replication may take some time, all the status of the data replication you can see under
LTRC ---> Configuration Name Screen
You can see the over all status at the top & Table status at 'Current Action' Column
If you are only using Source & Target system then SLT System is not required.
Thanks for reading, Please share your valuable feedback.
Nice, very helpful. Thanks for sharing.
ReplyDeleteVery nice
ReplyDeleteJust FYI, you don't need SLT component in target system unless you are using your target as SLT+Target on same system
ReplyDeleteYes You are correct, If we are using the SLT & Target system is same system.
DeleteHow can we install DMIS component in non sap server as you mention it supposed to be same level in all 3 systems ( source, slt and target)
ReplyDeleteIn the case of SAP- SAP the DMIS version is required, in the case of Non-SAP instead of RFC DB connection is using.
DeleteUseful information..Thank you
ReplyDelete"I appreciate that they are knowledgeable about sustainable practices." mass landscapers
ReplyDelete