Loading Data to SAP HANA – Using SLT

Hello Everyone,

                Data can be loaded from any source system to target system through many ways. This process of data loading is generally coined as DATA PROVISIONING. In HANA too, we have many data provisioning options.

Here are the list of data provisioning techniques often used for HANA as target system:

  1. SLT (SAP landscape Transformation)
  2. DXC (Direct Extractor Connection)
  3. Through Flat file
  4. Through Data services
  5. Using HANA inbuilt EIM (Enterprise Information management) tools

In this article, we are going to look at one the procedure of loading real time data from SAP/Non-SAP source system to HANA called SLT (SAP Landscape Transformation).

One of the main features of HANA is that, we can provide real time data to the customer at any point of time. This is made possible with the help of SLT (SAP Landscape Transformation) where real time data is loaded to HANA from SAP or Non-SAP source systems.

 

Architecture of SLT:

The architecture of SLT differs slightly based on the type of source system. Let’s look at each one of these in detail.

  1. SAP source system to HANA:
  • If your source system is SAP then you can install SLT as separate system or in Source itself.
  • Real-time replication works based on a DB Trigger.
  • The connection type between Source and SLT is RFC Connection.
  • The Connection between SLT and HANA is DB Connection.
  • The below figure shows SLT as a separate system where source is SAP

1

  • The SAP Note (1605140) provides complete information to install SLT system.
  • The below figure shows SLT inside a SAP source system.

2

  • Note: If you install SLT in Source system itself, then we no more need to have an RFC Connection.

   2.  Non-SAP source system to HANA:

3

  • The above figure shows real time replication of data from non-sap sources to HANA system. When the source is non-sap we have to install SLT as a separate system.
  • The main changes when compared to first scenario where source is SAP System are
    • Connection between Source and SLT is going to be a DB Connection.
    • Read modules will be in SLT instead of Source.

Components of SLT:

The main components involved in real-time replication using SLT are

  1. Logging Tables
  2. Read Modules
  3. Control Module (Transformation)
  4. Write Module
  • Logging Tables: Logging tables are used to capture the changed/new records from application tables since last successful replication to HANA.
  • Read Modules: Read modules are used to read the data from application tables for initial loading and convert the cluster type tables into transparent.
  • Control Module: The control module is used to perform small transformation on the source data. Data from here will be moved to write tables.
  • Write Tables: The functionality of write table is to write the data to HANA system.

Procedure to replicate data from SAP Source to HANA:

In order to replicate data from SAP source system to HANA, 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

Create the schema in SLT using the transaction code LTR:

  • Open the SLT system and enter transaction code LTR.
  • This will navigate us to the below screen:

4

  • Click on ‘New’ to create a new schema in LTR (Schema acts as a connection between the source and target system).
  • We will then be redirected to below screen:

5

Proceed to the next page to continue reading…

16 comments

  1. Very good blog. very easy understanding

  2. Hi ,

    thanks for the blog. its easy to understand, however I have a doubt. Instead of replicating the complete table from ECC, can we just select few columns like for eg only selected columns from any standard table like VBAK and get it replicated ? Please advice if you have any link or doc or reference for the same. Appreciate it.

    Cheers
    DR

    • Hi Daniel,

      Yes it is possible. You can delete the unwanted columns using SLT Advanced Replications with either IUUC_REPL_CONTENT or LTRS tcode.

      Best Regards,
      SAP Student.

  3. Hi,

    What would be the difference in configuration if hana is on cloud (HEC) ?
    And is the Hana system needed to be a BW system if we want reporting to be done from ECC after replication ?

  4. hi,
    where i found the configuration and monitoring dashboard in hana in hanastudio or saplogon

  5. V Madhu Sreenivasa Rao

    Yes the blog is very nice but you missed some of the points like installing DMIS componet, assigning role to RFC user, how to make database connections and creating user in HANA database to access Schema. Your done a really good job. Thanks a lot

  6. Very good blog… Easy understanding.. this will surely help lot of people … thanks for sharing.. 🙂

  7. Hi Team,

    I have some doubts about SLT
    1) Can we replicate table from one source to multiple tragets in HANA?
    2) SLT is not loading data, Structure only replicated what could be the reason and how to proceed furhter?

  8. Hi
    How can we perform selective loads , say based on fiscal year.

    thanks

    • Hi Aparajit,

      Instead of ‘Replicate’, use ‘Load’ option and before starting your load you can apply filters in SLT using tcode ‘IUUC_REPL_CONTENT’ for individual tables.

  9. Thanks for Posting this,very nice SAP HANA Server Access post for SAP Aspirants. Keep Posting

  10. Very good blog. very easy understanding

  11. very good blog

  12. Do we require data provisioning when in the back-end there is HANA database?
    We can connect modelling studio directly to HANA database?
    So do we require data Provisioning in those scenario?
    If yes then why?

    • Hi Gaurav,

      SAP HANA is just a database, you need to data into it using some mechanism before you start accessing data for modeling. So yes you need data provisioning to load data into HANA.

  13. Hi,
    How to use ‘LTRS’ to filter fields of table ?
    i.e. We only need some data from field “BUKRS” of the table “ANLA”

    Do you have any doc or link?
    Tks!

Leave a Reply

Your email address will not be published. Required fields are marked *

one × one =