SAP knowledge center 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 a collection of assets to power your SAP workloads. These assets include SAP connectors and templates as well upcoming solution accelerators provided by both Microsoft and partners. The SAP knowledge center is a consolidated location summarizing the available assets along with giving a comparison of when to use which solution.
Azure Data Factory and Synapse pipelines support extracting data using the following SAP connectors
- SAP Business Warehouse Open Hub
- SAP Business Warehouse via MDX
- SAP CDC
- SAP Cloud for Customer
- SAP ECC
- SAP HANA
- SAP Table
For a more detailed breakdown of each SAP connector along with prerequisites, see SAP connectors.
Azure Data Factory and Synapse pipelines provide templates to help accelerate common patterns by creating pipelines and activities for you that just need to be connected to your SAP data sources.
See pipeline templates for an overview of pipeline templates.
Templates are offered for the following scenarios
- Incrementally copy from SAP BW to ADLS Gen 2
- Incrementally copy from SAP Table to Blob
- Dynamically copy multiple tables from SAP HANA to ADLS Gen 2
For a summary of the SAP specific templates and how to use them see SAP templates.
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.