Skip to Content

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

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…

 

Thanks

Sumit

 

 

 

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply