data factory data flow for SAP CDC connector

Question

Hi all, I am working on getting CDC data from SAP using adf.

Currently, I am facing issue to pass variables in using dynamic content dataflow.

1. Refer to the diagram, it is working fine to pass variable in the Linked service properties
2. for ODP context and ODP name, I am able to assign a variable but it does not working (highligted in yellow).

May i know if someone familiar with adf SAP cdc connector advise if this is a bug or will required specific way to configure? Appreciate the advise!

Answer 1

For SAP CDC, the properties that are most commonly set via parameters are found in the tabs Source options and Optimize. When Source type is Inline, the following properties can be parametrized in Source options.

• ODP context: valid parameter values are
  • ABAP_CDS for ABAP Core Data Services Views
  • BW for SAP BW or SAP BW/4HANA InfoProviders
  • HANA for SAP HANA Information Views
  • SAPI for SAP DataSources/Extractors
  • when SAP Landscape Transformation Replication Server (SLT) is used as a source, the ODP context name is SLT~<Queue Alias>. The Queue Alias value can be found under Administration Data in the SLT configuration in the SLT cockpit (SAP transaction LTRC).
  • ODP_SELF and RANDOM are ODP contexts used for technical validation and testing, and are typically not relevant.
• ODP name: provide the ODP name you want to extract data from.

Source : https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-advanced-topics#parametrizing-source-and-run-mode