Could someone from Microsoft provide details on SAP Note:-3255746

Question

Hello Team,

Could you please provide an insight on ODP context in Synapse Analytics and that ABAP_CDS cannot be use directly through this methodology after SAP Note? If we have to expose SAP Data it has to be through only Odata? is that correct? Have heard about Odata CDC connector as well. Could you let us know when will that be available for public.

Answer 1

Hi @Yash Parikh
Welcome to Microsoft Q&A platform and thanks for posting your question here.

SAP Note 3255746

SAP Note 3255746 stops customers and third-party applications from using RFC modules in the ODP Data Replication API to access and extract SAP data from ABAP sources. These APIs are only for SAP’s internal use.

ODP Context in Synapse Analytics

In Azure Synapse Analytics, the ODP framework is used to get data from SAP systems. The SAP CDC connector in Synapse Analytics uses this framework to capture and replicate data changes. This connector works with SAP ECC, SAP S/4HANA, SAP BW, and SAP BW/4HANA.

ABAP_CDS Usage After SAP Note 3255746

After SAP Note 3255746, you can’t use ODP to access ABAP CDS views directly. Instead, you should use the OData API provided by SAP for data extraction. This API is stable and recommended for all customer and third-party applications.

Exposing SAP Data Through OData

To expose SAP data, including ABAP CDS views, you can use OData services. Here’s a step-by-step guide:

Create an OData Service:

In SAP, use transaction SEGW to create a new project.

Define the data model and service.

Implement the service logic.

Expose the OData Service:

Register the service in the SAP Gateway.

Activate the service.

Consume the OData Service:

Use the OData service URL to access the data from external applications or platforms like Azure Synapse Analytics.

OData CDC Connector Availability

The SAP CDC connector, which uses the ODP framework, is available for Azure Data Factory and Azure Synapse Analytics. This connector supports OData for data extraction and is designed to handle change data capture scenarios. It is now available for public use.

Summary

• SAP Note 3255746: Stops the use of RFC modules for ODP Data Replication APIs.
• ODP Context in Synapse Analytics: Uses the SAP CDC connector for data extraction.
• ABAP_CDS: Cannot be accessed directly through ODP; use OData API instead.
• Exposing SAP Data: Use OData services to expose and consume SAP data.
• OData CDC Connector: Available for public use in Azure Data Factory and Synapse Analytics.

Reference:
https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-change-data-capture
https://sap2databricks.com/unpermitted-usage-of-odp-data-replication-apis

https://techcommunity.microsoft.com/t5/azure-data-factory-blog/general-availability-of-sap-cdc-capabilities-for-azure-data/ba-p/3650246

I hope this information helps you. Let me know if you have any further questions or concerns.

Answer 2

Hi @Harishga
What about SAP Table connector? Can it still be used despite the SAP note?
Thank you very much.