SAP connectors overview
APPLIES TO: Azure Data Factory Azure Synapse Analytics
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.
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. SAP BW/4HANA isn't supported by this connector.|
|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). This includes 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 syste, 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.|