SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
HANA Admin Basics
+
-
Data Provisioning
+
-
SAP HANA Cockpit
+
-
HANA MDC
+
-
Availability and Scalability

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.
SAP Landscape Transformation Replication Server SLT

This will navigate us to the below screen:
SAP Landscape Transformation Replication Server SLT
Click on ‘New’ to create a new schema in LTR.


Step 2: Specify configuration details to create Schema
SAP Landscape Transformation Replication Server SLT
  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.

SAP Landscape Transformation Replication Server 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.
SAP Landscape Transformation Replication Server SLT
Upon clicking we are navigated to the below screen where we have different options to perform real-time replication.
SAP Landscape Transformation Replication Server SLT

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’.
SAP Landscape Transformation Replication Server SLT

Search for required table and add it to the right side.
SAP Landscape Transformation Replication Server SLT
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.




Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

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

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy