Sap landscape transformation replication server

How To replicate Data from SAP Source System To HANA Database

By admin Last updated Feb 1, 2022

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:

1. Load

2. Replicate

3. Stop Replication

4. Suspend

5. Resume

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

S8 1498541

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

S10 8363700

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

S12 9211709

Next enter logon details

Click on connection test and click on yes

S14 7540279

RFC Destination Saved

S16 8191305

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

S19 5256996

Provide details and click next

Enter RFC destination and click Next

S21 4608600

Enter DB connection details and click next

Enter job options and click next

S23 6203139

Now verify details and click create

Now configuration created

S25 9832444

Now go to start ->click on all programs->click on Hana studio

Now expand system->expand catalog->search schema

S27 8114067

Now click on data provisioning->select system->click finish

S29 3127747

Now select source system and target schema and click refresh

In Hana system also we see the same options

S37 8523748

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.

S32 3801327

Enter table name and click start load and execute

The table is scheduled with start load

S34 7889270

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