Prerequisites and setup for the SAP CDC connector

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Learn about the prerequisites for the SAP CDC connector in Azure Data Factory and how to set up the solution in Azure Data Factory Studio.


To use the SAP CDC capabilities in Azure Data Factory, be able to complete these prerequisites:

Set up SAP systems to use the SAP ODP framework

To set up your SAP systems to use the SAP ODP framework, follow the guidelines that are described in the following sections.

SAP system requirements

The ODP framework is part of many SAP systems, including SAP ECC and SAP S/4HANA. It is also contained in SAP BW and SAP BW/4HANA. To ensure that your SAP releases have ODP, see the following SAP documentation or support notes. Even though the guidance primarily refers to SAP BW and SAP Data Services, the information also applies to Data Factory.

Set up the SAP user

Data extractions via ODP require a properly configured user on SAP systems. The user must be authorized for ODP API invocations over Remote Function Call (RFC) modules. The user configuration is the same configuration that's required for data extractions via ODP from SAP source systems into BW or BW/4HANA. For more information, see these SAP support notes:

Set up SAP data sources

ODP offers various data extraction contexts or source object types. Although most data source objects are ready to extract, some require more configuration. In an SAPI context, the objects to extract are called DataSources or extractors. To extract DataSources, be sure to meet the following requirements:

  • Ensure that DataSources are activated on your SAP source systems. This requirement applies only to DataSources that are delivered by SAP or its partners. DataSources that are created by customers are automatically activated. If DataSources have been or are being extracted by SAP BW or BW/4HANA, the DataSources have already been activated. For more information about DataSources and their activations, see Installing BW Content DataSources.

  • Make sure that DataSources are released for extraction via ODP. This requirement applies to DataSources that customers create as well as DataSources created by SAP in older releases of SAP ECC. For more information, see the following SAP support note 2232584 - To release SAP extractors for ODP API.

Set up the SAP Landscape Transformation Replication Server

SAP Landscape Transformation Replication Server (SLT) is a database trigger-enabled CDC solution that can replicate SAP application tables and simple views in near real time. SLT replicates from SAP source systems to various targets, including the operational delta queue (ODQ). You can use SLT as a proxy in data extraction ODP. You can install SLT on an SAP source system as an SAP Data Migration Server (DMIS) add-on or use it on a standalone replication server. To use SLT as a proxy, complete the following steps:

  1. Install NetWeaver 7.4 SPS 04 or later and the DMIS 2011 SP 05 add-on on your replication server. For more information, see Transferring Data from SLT Using Operational Data Provisioning.

  2. Run the SAP Landscape Transformation Replication Server Cockpit (LTRC) transaction code on your replication server to configure SLT:

    1. Under Specify Source System, enter the RFC destination that represents your SAP source system.

    2. Under Specify Target System, complete these steps:

      1. Select RFC Connection.

      2. In Scenario for RFC Communication, select Operational Data Provisioning (ODP).

      3. In Queue Alias, enter the queue alias to use to select the context of your data extractions via ODP in Data Factory. Use the format SLT~<your queue alias>.

    Screenshot of the SAP SLT configuration dialog.

For more information about SLT configurations, see Replicating Data to SAP Business Warehouse.

Validate your setup

To validate your SAP system configurations for ODP, you can run the RODPS_REPL_TEST program to test extraction, including SAPI extractors, CDS views, and BW objects. For more information, see Replication test with RODPS_REPL_TEST.

Known issues

The following SAP support notes resolve known issues on SAP systems:

Next steps

Set up a self-hosted integration runtime for your SAP CDC solution