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:
- SLT (SAP landscape Transformation)
- DXC (Direct Extractor Connection)
- Through Flat file
- Through Data services
- 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.
- 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
- The SAP Note (1605140) provides complete information to install SLT system.
- The below figure shows SLT inside a SAP source system.
- 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:
- 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
- Logging Tables
- Read Modules
- Control Module (Transformation)
- 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:
- Create schema in SLT using the transaction code LTR
- 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:
- 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:
Proceed to the next page to continue reading…