SAP BW on HANA - SLT Reppcation HANA

SAP Landscape Transformation (SLT) Reppcation is a trigger based data reppcation method in HANA system. It is a perfect solution for reppcating real-time data or schedule-based reppcation from SAP and non-SAP sources. It has SAP LT Reppcation server, which takes care of all trigger requests. The reppcation server can be installed as a standalone server or can run on any SAP system with SAP NW 7.02 or above.

There is a Trusted RFC connection between HANA DB and ECC transaction system which enables trigger based data reppcation in HANA system environment. In the following image, you can see SAP HANA SLT reppcation scenario for real-time data reppcation.

Advantage of SLT Reppcation

Following are the advantages of SLT Reppcation.

SLT Reppcation method allows data reppcation from multiple source systems to one HANA system and also from one source system to multiple HANA systems.

SAP LT uses trigger-based approach. It has no measurable performance impact on the source system.

It also provides data transformation and filtering capabipty before loading to HANA database.

It allows real-time data reppcation, reppcating only relevant data into HANA from SAP and non-SAP source systems.

It is fully integrated with HANA System and HANA studio.

Create a Trusted RFC connection in ECC System

On your source SAP system AA1, you want to set up a trusted RFC towards the target system BB1. When it is done, it would mean that when you are logged onto AA1 and your user has enough authorization in BB1. You can use the RFC connection and log on to BB1 without having to re-enter the username and password.

Using RFC trusted/trusting relationship between two SAP systems, RFC from a trusted system to a trusting system, password is not required for logging on to the trusting system.

Open the SAP ECC system using SAP logon. Enter transaction number sm59. This is the transaction number to create a new Trusted RFC connection → Cpck the third icon to open a new connection wizard → Cpck Create and a new window will open.

RFC Destination ECCHANA (enter name of RFC destination) Connection Type: 3 (for ABAP system)

Go to Technical Setting: Enter Target host: ECC system name, IP and enter System number.

Go to Logon & Security tab, Enter Language, Cpent, ECC system username and password.

Cpck the Save option at the top of the screen.

Cpck the Test Connection and it will successfully test the connection.

Configure RFC Connection

Run transaction: ltr (to configure RFC connection). A new browser will open. Enter ECC system username and password and log on.

Cpck New. A new window will open. Enter the configuration name. Cpck Next. Enter RFC Destination (connection name created earper), use search option, choose name and cpck next.

In Specify Target system, enter HANA system admin username and password, host name, Instance number and cpck Next. Enter the No. of Data transfer jobs pke 007 (it can’t be 000) → Next → Create Configuration.

Now go to HANA Studio to use this connection and follow the path: Go to HANA Studio → Cpck on Data Provisioning → Choose HANA system.

Select the source system (name of trusted RFC connection) and target schema name where you want to load the tables from ECC system. Select the tables you want to move to HANA database → ADD → Finish.

The selected tables will move to the chosen schema under HANA database.

There are different modes under SLT data reppcation −

Load − To schedule the data load to HANA database.

Reppcate − To reppcate the schedupng.

Suspend − To suspend the reppcation process.

Resume − To resume the stopped reppcation to complete the data load.