In previous chapters SAP Landscape Transformation (SLT)
, we explained basic feature and functionalities of SLT.
In this section, we will learn how to replicate data from SAP Source to HANA using SLT.
In order to replicate data from SAP source system to HANA, two major steps are involved, they are:
- Configure SAP SLT Server for SAP Source System
- Import SAP Source Data to SAP HANA through SLT
Configure SAP SLT Server for SAP Source System
Step 1: Login to SLT server using 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.
Step 2: Specify configuration details to create Schema
- Enter Schema name.
- Select SAP System as the source system.
- Enter RFC connection for SAP System.
- Enter Username / Password / Host Name and Instance number.
- Select Replication option as Real Time.
- Once all the settings are maintained click on 'OK' to create a new schema in SLT.
After configuration SAP SLT server successfully, SAP SLT Server automatically create DB connection for SAP HANA database (when we create a new configuration via transaction LTR). There is no need to create it manually.
Import SAP Source Data to SAP HANA through SLT
Once we had successfully created our schema in SLT (Source system), we will observe that a schema with the same name will be created in SAP HANA studio, which has 8 tables under it along with 2 stored procedures, 4 roles and a privilege.
The tables that are created are
The roles that are created are
The procedures that are created are
Once our schema is created, we can go ahead and replicate source system tables into our HANA database.
Step 1: Load tables from SAP ECC to SAP HANA database using below steps-
- Go to Data provisioning from Quick View.
- Select SAP HANA System.
- Click on Finish Button.
Upon clicking we are navigated to the below screen where we have different options to perform real-time replication.
Step 2: Start Replication using below 5 data provisioning options
This option is used to load all the data
from source to HANA. This is a one-time event, which starts an initial load of data from source system.
: This option is used to have real-time replication with historical data. It start initial load (if not done earlier), and also consider delta change. Database trigger and related logging table will be created for each table
It stops the current replication process for a table. It removes database trigger and logging table completely.
It pause a running replication process of a table. The database trigger will not be deleted from the source system, and recording of changes will continue. Related Information is stored in the related logging table in the source system.
Resume restarts the replication for a suspended table. After resume, the suspended replication process will resume.
To add a new table for loading or replication, click on ‘Load’ or ‘Replicate’.
Search for required table and add it to the right side.
Now ‘click’ on finish to load the data into HANA.
The above screen shows different status of data load jobs in HANA studio.
The job is said to be completed if the action type is LOAD and Status being EXECUTED.