2.6 SAP Data Services with SLT

The instructions are intended for SAP ETL or Technical consultants who have basic experience with the configuration of SAP Basis, SAP DS ,AWS S3 and AWS IAM.

Lab 6: ODP Framework using SAP Data Services

SAP Landscape Transformation Replication Server (SLT) overview:

➡️ SLT supports near real-time and batch data replication from SAP applications. Real-time data extraction is supported by creating database triggers in the source SAP application.

➡️ For replication targets, SAP SLT supports by default SAP HANA, SAP BW, SAP Data Services, SAP Data Hub, and a set of non-SAP databases. For a list of non-SAP targets, see Replicating Data to Other Databases documentation.

➡️ For replicating data to targets that are not supported by SAP yet, customers can implement their own customizations using the Replicating Data Using SAP LT replication server SDK. A detailed implementation guide is available in SAP support note 2652704 – Replicating Data Using SAP LT Replication Server SDK (requires SAP ONE Support access).

The key considerations for extraction using SAP SLT include the following:

  • It supports both full data extraction and change data capture. Trigger-based extraction supports change data capture even on source tables that don’t have updated date and timestamp.

  • Additional custom development in ABAP is required to integrate with targets not supported by SAP.

  • Additional licensing cost for SAP Data Hub, SAP Data Services, or other supported databases to replicate data to S3.

  • Additional custom development effort in AWS Glue when replicating from an SAP-supported database to S3.

  • An SAP SLT enterprise license might be required for replicating to non-SAP-supported targets

In this lab we will show you how to set up a solution for replicating data from SAP applications, such as SAP S/4HANA or SAP Business Suite, to Amazon S3 by using SAP Landscape Transformation (LT) Replication Server and SAP Data Services (DS).

Operational Data Queue(ODQ):

  1. The Operational Data Provisioning(ODP) framework supports extraction and replication scenarios for various target SAP applications, known as subscribers. The subscribers retrieve the data from the delta queue for further processing.

  2. Data gets replicated as soon as a subscriber requests the data from a data source through an ODP context. An Operational Data queue is used to maintain the different queues of data between publishers and subscribers. See SAP documentation to learn about ODP and ODQ framework.

Complete the below prerequisites before your start the SAP Data Services lab:

  • Create an Amazon S3 Bucketand a folder within the bucket for example “Product”

  • Create an AWS IAM role to provide full access for this bucket

  • Create AWS IAM user with programmatic access and attach the role to the user.

  • Download the access key and secret key information for the user. This is used to apply these credentials in SAP Data services.

  • We assume that you have access to SAP S/4HANA/SAP ECC Business Suite with embedded SLT or stand alone SLT and SAP Data Services. Work with with your organization SAP admin to get necessary access to valid SAP systems.

Below is a list of the steps for this lab: