Can Azure Data Factory SAP ODP connector read from cluster tables like PCL2 & PCL4 ?

Sreedhar Vecireddy [svecireddy] 20 Reputation points
2024-04-26T22:54:01.79+00:00

Does Azure Data Factory connector "SAP CDC" uses ODP framework of SAP?
Can SAP CDC connector read from SAP Cluster tables from ECC system specifically PCL2 & PCL4 cluster tables?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,814 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 25,946 Reputation points
    2024-04-28T17:25:22.9966667+00:00

    ADF provides connectors such as the SAP Table connector and the SAP CDC which is specifically designed to capture and transfer change data from SAP systems to Azure, using ODP as its framework.

    Regarding your question about whether the SAP CDC connector can read from cluster tables like PCL2 and PCL4 in an SAP ECC system, it's important to understand the limitations and capabilities of this connector. SAP cluster tables, such as PCL2 and PCL4, store data in a format that is not directly accessible via standard SQL queries because the data in these tables is stored in a compressed and serialized format. This makes direct access and extraction of data from cluster tables challenging.

    The standard functionality of the ADF SAP CDC connector using the ODP framework does not inherently support direct extraction from SAP cluster tables. Typically, to access data from these tables, one might use ABAP programs or function modules in SAP to decompress and deserialize the data before it can be extracted and transferred.

    https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-introduction-architecture

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.