Working with ODP Context - SLT based extraction


After completing this lesson, you will be able to:

  • Load data to SAP BW/4HANA from SLT using ODP

Load data to SAP BW/4HANA from SLT using ODP

SAP LT Replication Server as a provider for ODP

SAP Landscape Transformation Replication Server (SAP LT Replication Server) is a tool that can extract data in real-time from the application tables of supported applications and databases, to SAP BW∕4HANA. Supported applications include SAP Business Suite and SAP S/4HANA and any ABAP-based application. Popular databases are also supported, including Oracle and MS SQL Server. Extraction is based on the use of database triggers that signal to the replicator to transfer the new or changed records in the source tables to SAP BW/4HANA. This is done in real-time.


The databases for which a database specific library exists are supported. Currently, these are SAP ASE, Oracle, Informix, MS SQL, Max DB, IBW DB2 and DB4, AS/400, SAP HANA. Refer to SAP Note 2695198 - Which database does SLT support ? SAP Landscape Transformation replication server.

Trigger-based replication (SAP LT Replication Server) enables delta processes to be implemented for tables that do not have any delta-enabled fields. This means you can implement a delta process for DataSources (extractors) that do not include delta logic. If you are working with large master data tables that do not have delta logic and are only changed infrequently, you can significantly reduce the administration effort compared to running full load processes.

SAP LT Replication Server offers a useful alternative for data transfer to SAP BW∕4HANA in the following cases:

  • Joins or transformation logic is not required during the extraction. Only data from individual tables is extracted.

  • The DataSources (extractors) that you want to replace using the SAP LT Replication Server are DataSources on simple tables/views that do not provide a delta mechanism, and only contain minimal extractor logic.


Consider the following points if you want to use this transfer method to replace DataSource based extractors:

  • Many extractors contain extractor logic (associations and content logic) that is very complicated to reconstruct in the SAP BW∕4HANA system.

  • Many extractors can guarantee a consistent delta transfer to the SAP BW∕4HANA system by using the delta queue.

SAP LT Replication Server provides the operational data provisioning infrastructure with the source tables as delta queues. The data from the delta queue can be replicated to the SAP BW∕4HANA system as a subscriber. The data is loaded with a data transfer process directly into the InfoProviders. The ODP infrastructure (with delta queues) takes over important services such as monitoring data requests. In addition, the ODP infrastructure has been prepared to support SAP BW∕4HANA and other subscribers with SLT data transfer (for example, SAP Data Services).


You can find more documentation regarding transferring data from SLT using ODP here:

Log in to track your progress & complete quizzes