Edit

SAP connectors overview

  • Article

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

Azure Data Factory and Azure Synapse Analytics pipelines provide several SAP connectors to support a wide variety of data extraction scenarios from SAP.

Tip

To learn about overall support for the SAP data integration scenario, see SAP data integration whitepaper with detailed introduction on each SAP connector, comparison and guidance.

The following table shows the SAP connectors and in which activity scenarios they're supported as well as notes section for supported version information or other notes.

Data store Copy activity (source/sink) Mapping Data Flow (source/sink) Lookup Activity Notes
SAP Business Warehouse Open Hub ✓/− ✓ SAP Business Warehouse version 7.01 or higher. This connector doesn't support SAP BW/4HANA.
SAP Business Warehouse via MDX ✓/− ✓ SAP Business Warehouse version 7.x.
SAP CDC ✓/- Can connect to all SAP releases supporting SAP Operational Data Provisioning (ODP). You can use the connector with most SAP ECC and SAP BW releases, as well as SAP S/4HANA, SAP BW/4HANA and SAP Landscape Transformation Replication Server (SLT). Regarding prerequisites for the SAP source system, follow SAP system requirements. For details on the connector, follow Overview and architecture of the SAP CDC capabilities
SAP Cloud for Customer (C4C) ✓/✓ ✓ SAP Cloud for Customer including the SAP Cloud for Sales, SAP Cloud for Service, and SAP Cloud for Social Engagement solutions.
SAP ECC ✓/− ✓ SAP ECC on SAP NetWeaver version 7.0 and later.
SAP HANA ✓/✓ ✓ Any version of SAP HANA database
SAP Table ✓/− ✓ SAP ERP Central Component (SAP ECC) version 7.01 or later. SAP Business Warehouse (SAP BW) version 7.01 or later. SAP S/4HANA. Other products in SAP Business Suite version 7.01 or later.