What is trigger-based replication?

The Trigger-Based Replication method uses the SAP Landscape Transformation (LT) Replication Server component to pass data from the source system to the SAP HANA database target system. Initial Load and Simultaneous Delta Replication. The initial load of business data is initiated using the SAP HANA studio.

What is the difference between SLT and bods?

BODS has an event based triggering through which dependency on the jobs can be set with respect to other jobs. SLT tasks can also be scheduled through LTR configuration in SLT server. Similarly, in SDI flowtasks can be scheduled.

What does SLT stand for SAP?

SAP Landscape Transformation Replication Server
SLT stands for SAP Landscape Transformation Replication Server (SLT) running on the NetWeaver Platform. SLT is the ideal solution for all HANA customers who need real-time (and non-realtime) data replication sourcing from SAP ERP or non-SAP systems into HANA.

How do you replicate a table from ECC to HANA?

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.

What triggers SLT?

From the above method, SAP Landscape Transformation (SLT) Replication is a trigger based data replication method in HANA system. It is used for replicating real-time data or schedule-based replication from SAP and non-SAP sources. It has SAP LT Replication server, which takes care of all trigger requests.

What is SDA and SDI?

SAP Smart data integration (SDI) is an extension of SDA (same functionality but using much broader set of preinstalled adapters from Data Provisioning Agent component) and only solution which provides – together with smart data quality (SDQ) – batch ETL, real-time replication and virtual data into one technology.

What is SDA in HANA?

SDA is a new method of SAP HANA for accessing the data stored in remote data sources. With the help of SDA, SAP HANA can create so-called “virtual table” mapping to tables located in remote data sources, and then SAP HANA can access the data directly by accessing the “virtual table”.

What is SDA in SAP HANA?

Smart Data Access is a data virtualization feature in SAP HANA that allows customers to access data virtually from remote sources such as Hadoop, Oracle, Teradata, SQL Server and SAP databases and combine it with data that resides in an SAP HANA database.

What is SAP ILM?

SAP Information Lifecycle Management (SAP ILM) component allows SAP customers to manage the full lifecycle of data in a structured, automated and compliant way. We use SAP ILM extensively to deliver successful archiving, decommissioning and GDPR projects.

How do you replicate a table in SAP?

To start the replication for a table you have to enter transaction LTRC and execute the Data Provisioning function. Specify the table name you want to replicate, the transfer option and execute it. Two important points: Ensure that a target table with the same name already exist.

What is SLT replication?

SLT is the an ETL ( Extract , Transform , Load ) tool which allows us to load and replicate data in real-time or schedule data from SAP source system or Non SAP System into SAP HANA Database. SAP SLT server uses a trigger-based replication approach to pass data from source system to target system.

What is SAP Ltrc?

LTRC (SAP LT Replication Server – Cockpit) is a standard SAP transaction code available within R/3 SAP systems depending on your version and release level.

Should you choose trigger or log-based replication?

When you set up real-time replication with SDI, you have the choice between trigger and log-based replication. I won’t go into all the pro’s and con’s of the two techniques, but in my case the choice is simple. My source database is a cloud-based MSSQL database, which does not allow access to the log files.

Is MyMy source database MSSQL or trigger-based replication?

My source database is a cloud-based MSSQL database, which does not allow access to the log files. So, trigger-based replication it is. The SAP SDI Data Provisioning Agent (this tutorial uses version 2.5.1.2);

Is there any SAP SLT replication documentation?

SAP SLT (Trigger Based) Replication Made Easy – part 1: Planning, Preparation, Installation. Disclaimer. At the time of creation of this document there was no official SAP documentation available explaining details of SLT replication. This document is based on author’s experience gained through working with SLT replication.

Why was author forced to make conclusions during SLT replication?

Author was forced to make conclusions based on observing normal behavior of SAP system during SLT replication, based on studying SLT source code and based on experimenting with SLT configuration and replication. The author therefore does not accept responsibility for potential damage done by applying information gained by reading this document.