Transferring Data from SLT Using Operational Data Provisioning

Configure the connections for transferring data between the relevant systems. In the BW system, create the objects required (DataSource and InfoPackage or data transfer process) for data transfer.

Prerequisites

Note the licensing conditions when using SAP LT Replication Server.
SAP LT Replication Server (SLT) has the minimum release version:
- Add-On DMIS 2011 SP05
- SAP NetWeaver 7.3 SPS10, 7.31 SPS09 or 7.4 SPS04 (ODP infrastructure)
Add-On DMIS_2011 SP03/SP04 or higher or 2010 SP08/SP09 is installed in the SAP source. You also need SAP Note 1863476 . If you are using Add-On DMIS 2011 SP05, you need SAP Note 1817467 .
The data transfer is possible for simple tables.

Context

Using the operational data provisioning infrastructure and trigger-based replication of SAP Landscape Transformation Replication Server (SAP LT Replication Server), you can transfer data from SAP systems to the BW system in real-time. SAP LT Replication Server is a provider for the operational data provisioning infrastructure. It can make tables from SAP sources available as delta queues. BW can be a subscriber to this delta queue and can access the data replicated using the operational data provisioning infrastructure for further processing.

Procedure

In SAP LT Replication Server, use transaction SM59 to create an RFC destination for the SAP system, which is used as a data source.
In SAP LT Replication Server, use transaction LTR to create a configuration.
In the configuration, enter the details for the source and target of the SAP LT Replication Server. The source is the SAP system to be used as a data source. The target for data transfer using ODP is the SAP LT Replication Server itself. The connection to BW is established later on by defining an ODP source system in BW.
Specifying the source:
1. Enter the RFC destination for the SAP system to be used as the source.
Specifying the target:
1. Enter the NONE as the RFC connection.
2. Choose ODQ Replication Scenario as the scenario for RFC communication.
  Using this scenario, you can specify that data is transferred using the operational data provisioning infrastructure with operational delta queues.
1. Assign a six-digit queue alias.
  The queue alias is used in BW when the source system is created as an ODP context.
Create a source system of type ODP in the BW system.
For more information, see Creating an ODP Source System
Create a DataSource in the BW system.
For more information, see Creating DataSources for ODP Source Systems
To start a data transfer, create an InfoPackage or a data transfer process (DTP) in the BW system and schedule the data transfer:
1. Using an InfoPackage, you can load the data into the BW entry layer (PSA). Here you can process the data further in BW.
2. Using a data transfer process, you can load data directly into the InfoProvider. For more information, see Loading Data from ODP Source Systems Directly into InfoProviders

Results

The InfoPackage or data transfer process creates a request, which requests the data and loads it into BW.

Next Steps

On SAP LT Replication Server, you can monitor the data request by using the delta queue monitor (transaction ODQMON). Select the queue using the provider SLT_REPLICATOR. Select the subscriber type using subscription SAP BWand select the queue name using <Queue Alias>~<Table Name>. To obtain detailed information on the data request (at data data record level), you can navigate through the views of the delta queue monitor.

In the BW system, use the extraction monitor or DTP monitor to check whether the data request was completed.