How to replicate data from SAP Source to HANA
using SLT
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:
1. Configure SAP SLT Server for SAP Source System
2. 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
1. Enter Schema name.
2. Select SAP System as the source system.
3. Enter RFC connection for SAP System.
4. Enter Username / Password / Host Name and Instance number.
5. Select Replication option as Real Time.
6. 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
DD02L
DD02T
RS_LOG_FILES
RS_MESSAGES
RS_ORDER
RS_ORDER_EXT
RS_SCHEMA_MAP
RS_STATUS
The roles that are created are
<SCHEMA_NAME>_DATA_PROV
<SCHEMA_NAME>_POWER_USER
<SCHEMA_NAME>_USER_ADMIN
<SCHEMA_NAME>_SELECT
The procedures that are created are
RS_GRANT_ACCESS
RS_REVOKE_ACCESS
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-
1. Go to Data provisioning from Quick View.
2. Select SAP HANA System.
3. 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
Load: 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.
Replicate: 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
Stop Replication: It stops the current replication process for a table. It removes
database trigger and logging table completely.
Suspend: 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: 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.
