Show TOC

Transferring Data with SAP Landscape Transformation Replication ServerLocate this document in the navigation structure

Using SAP Landscape Transformation Replication Server (SAP LT Replication Server), you can provide real-time data from tables of supported sources for BW. This is achieved by using the trigger-based replication functionality of the SAP LT Replication Server.

Trigger-based replication (SAP LT Replication Server) allows delta processes to be used for tables that do not have any delta-enabled fields. This allows you for example to use delta processes for DataSources (extractors) without delta logic. If you are working with large master data tables without delta logic that are only changed very infrequently, you can significantly reduce the administration effort for frequent full processes by using trigger-based replication (SAP LT Replication Server) as the transfer method.

Note Note the licensing conditions when using SAP Landscape Transformation Replication Server.

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

  • The tables in the source are simple tables without joins or transformation logic.

  • 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.

Caution

Note the following points if you want to use this transfer method to replace extractors:

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

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

Therefore we recommend that you only replace complex extractors with SAP LT Replication Server in exceptional cases.

Two interfaces are available for transferring data using SAP LT Replication Server:

  • Operational Data Provisioning

    Data transfer using operational data provisioning is supported for tables from SAP systems.

    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 in BW as a subscriber.

    If you use operational data provisioning, you can load the data directly into the InfoProviders (bypassing the PSA layer) by using a data transfer process. 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 BW and other subscribers with SLT data transfer (for example, SAP Data Services).

    .
  • Web service

    Data transfer using the Web service interface is supported for tables from SAP systems and for tables from non-SAP systems.

    SAP LT Replication Server replicates the data in a Web service DataSource of the BW Persistent Staging Area, where the data is available for further processing.

    If you use the Web service interface, the data can be pushed at regular time intervals to BW, where it can be updated using real-time data acquisition.