Share via

Azure Data Factory SAP CDC Connector and Support

Kapil Mishra 20 Reputation points
2024-09-23T17:42:50.29+00:00

Hi Team,

I want to know if Azure data Factory SAP connectors will remain supportive in the future. As per SAP note # 3255746, seems like any third-party tools that use ODP framework will be restricted by SAP hence want to know the future of SAP CDC connectors. Below is the link to the connectors I am referring to:

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,655 questions
Accepted answer
  1. Amira Bedhiafi 34,336 Reputation points Volunteer Moderator
    2024-09-23T21:03:21.91+00:00

    SAP has introduced significant changes related to the usage of the Operational Data Provisioning (ODP) API by third-party applications like Azure Data Factory (ADF). According to SAP Note 3255746, third-party tools that use the ODP framework, such as the SAP CDC connector in ADF, will no longer be permitted to access SAP data through RFC modules. Instead, SAP encourages using OData APIs for compliant data extraction going forward :

    https://sap2databricks.com/unpermitted-usage-of-odp-data-replication-apis

    https://learn.microsoft.com/en-us/answers/questions/1659375/sap-cdc-and-sap-tables-connectors-regarding-sap-no

    This restriction impacts various tools that rely on ODP, including ADF, and poses challenges for organizations currently using these connectors for real-time data integration. Microsoft has acknowledged this shift and is working on adapting its connectors to support SAP OData, but the transition may lead to performance concerns, as OData is generally slower compared to RFC-based methods.

    https://github.com/MicrosoftDocs/azure-docs/issues/121058

    https://bryteflow.com/sap-bans-sap-rfc-extraction/

    If you are using the SAP CDC connector in ADF, you should prepare for potential disruptions and explore alternatives, such as transitioning to OData-based connectors when they become available. It is advisable to keep an eye on official announcements from both SAP and Microsoft regarding the development of compliant connectors. https://www.cubeserv.com/en/sap-integration-in-azure-synapse-and-azure-data-factory/

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.