How To replicate Data from SAP Source System To HANA Database
In this blog
In order to replicate data from SAP source system to HANA database, two major steps are involved, they are:
1. Create schema in SLT using the transaction code LTR
2. Replicate the tables of source system to HANA studio
Advantages of SLT Replication:
- SLT Replication method allows data replication from multiple source systems to one HANA system and also from one source system to multiple HANA systems.
- SAP LT uses trigger based approach. It has no measurable performance impact in source system.
- It also provides data transformation and filtering capability before loading to HANA database.• It allows real-time data replication, replicating only relevant data into HANA from SAP and non-SAP source systems.
- It is fully integrated with HANA System and HANA studio.
Below are the different types of activities that are available while performing real time replication:Below are the different types of activities that are available while performing real time replication:
3. Stop Replication
Let’s look at each of the activity in detail:
• Load: This option is used to load all the data from source to HANA. Logging tables will not be created in this and real-replication is not done.• Load: This option is used to load all the data from source to HANA. Logging tables will not be created in this and real-replication is not done.
• Replicate: This option is used to have real-time replication with historical data. All the data is loaded to HANA and logging tables will be created source for real-time replication.
• Stop Replication: Replication is stopped for the table and logging tables will be deleted in source system.
• Suspend: Replication is stopped for the table but logging tables will be there in source system.
• Resume: We can resume the replication for suspended tables.
Implementing SLT configuration with load process
SAP landscape transformation replication server (“SLT”)
• Is for all sap Hana customers who need real-time or scheduled data replication, sourcing from sap and non-sap sources
• Uses trigger-based technology to transfer the data from any source to sap Hana in real-time.
SLT server can be installed on the separate system or on SAP ECC system.
Benefit of SLT system
- Allows real-time or schedule time data replication.
- Allows real-time or schedule time data replication.• During replicating data in real-time, we can migrate data in sap Hana format.
- SLT handles cluster and pool tables.
- This is fully integrated with sap Hana studio.
- SLT have table setting and transformation capabilities.
- SLT have monitoring capabilities with SAP Hana solution manager.
Logon to SAP ECC 6.0 EHP 7 system
I. Creation of RFC connection – while configuring SLT in LTRC transaction we need to pass RFC connection. In case there is no suitable RFC connection available or there is issue with existing RFC connections, we can easily create RFC connection to meet our requirement as follows –
Enter tcode sm59 and click enter
Here you have RFC connections
Click on create
Provide RFC connection destination details, then select connection types as below screenshot
Under technical settings tab give target host and system number
Next enter logon details
Click on connection test and click on yes
RFC Destination Saved
ii. SLT configuration steps:
Enter t-code LTRC and click enter
If any configurations are already created delete them we have limited system resource availability. Whenever you need to create new configuration delete existing system. We can’t create more than two configurations so we have deleted it
Click on Yes
Now lets create new Configuration
Provide details and click next
Enter RFC destination and click Next
Enter DB connection details and click next
Enter job options and click next
Now verify details and click create
Now configuration created
Now go to start ->click on all programs->click on Hana studio
Now expand system->expand catalog->search schema
Now click on data provisioning->select system->click finish
Now select source system and target schema and click refresh
In Hana system also we see the same options
whenever we selected target schema automatically data load management loaded and show the tables like d002t, d008l, d002l
By default these three tables are replicated
DD02L: this is stop replication table which contains all the table details stored inside the table
DD02T: These tables contains text related to standard tables
DD08T: these table holds information about table relationship how tables are interconnect to each other
Check and wait until the replication takes place
If you want to know what jobs are running gotoecc enter sm37 tcode and click enter
We can use options from anywhere like SAP GUI and SAP HANA both are same
Let us start load process on ECC->click on data provisioning with standard table
Load: This option is used to load all the data from source to HANA. Logging tables will not be created in this and real-replication is not done.
Enter table name and click start load and execute
The table is scheduled with start load
Back to hana studio and click refresh
After the table is in status executed then it is replicated to SAP HANA
Now right click on table loaded ->click on open data preview
here you can see the table loaded with data
Go back to ECC system
Enter table name and click start replicate
REPLICATION: replication is an option we going to use frequently changing the data scenarios.
Here we see the t001 table is scheduled
Click on refresh the t001 table is replicate
Go back to hana studio click refresh here also we see the t001 table is replicate
In Hana studio schema is created
Expand system->expand our schema->expand tables
We see the all the tables
Click STOP replication
The t001 table stop is executed
Go back to ECC system the t001 table is removed
You can find more technical information and installation guides
Installation guide: http://www.saphana.com/docs/DOC-1352
Deep dive how-to guides / videos: https://www.youtube.com/watch?v=4B55DrzFyIM&list=PLkzo92owKnVzc_3KBaxtgRpGOTVv0o2Wp
Please let me know your experience with SAP SLT.
Thank you for reading…