What’s new with SAP connectivity in Microsoft Fabric – July 2025
For enterprise customers, SAP represents one of the most valuable data sources. Integration of SAP data with other non-SAP data estates is a frequent requirement of Microsoft Fabric customers. Consequently, we are continually working to expand the options for SAP data integration to ensure that every customer has a viable solution tailored to their specific needs.
In this blog post, we have an update on the most recent advances we have made this year regarding data integration options from SAP sources.
Options for integrating data from SAP into Fabric
A fundamental principle of Microsoft Fabric is to address the needs of all analytics use cases across all personas including data engineers, data scientists, business analysts and citizen developers. This is also reflected in the options Fabric offers for SAP data integration which aim to cover all relevant SAP source systems, on-premises or cloud deployments as well as data integration patterns ranging from simple batch integration to low-latency change data capture.
To achieve this, we are offering rich connectivity options to integrate your SAP data into Microsoft Fabric:
- Through built-in connectivity, readily available to solve all standard SAP integration use cases out of the box.
- By providing a platform and closely collaborating with our broad ecosystem of partners to cover additional use cases and offer customers choice.
- By deepening the integration with SAP’s strategic analytics portfolio to provide a seamless experience for customers with a combined SAP and Microsoft strategy for data.
To keep thing concise, we will focus on options 1 and 2 for now. The integration with SAP’s analytics portfolio, including SAP Business Data Cloud and SAP Datasphere, is an extensive topic that will be covered in future posts.
Built-in connectivity
To enable comprehensive analytics and AI use cases, data integration is a key aspect of Microsoft Fabric. Data Factory currently offers a set of 170+ connectors out of the box covering a wide range of enterprise and web sources. In addition, via the extensibility provided by the connector SDK, customers and partners have added thousands of additional custom connectors.
For business users and citizen data integrators, Data Factory provides access to the analytic layers of SAP BW and SAP S/4HANA via the SAP BW connector and to SAP HANA via the SAP HANA connector. Both connectors are integrated with Fabric data flows and allow users to wrangle, enrich and blend the source data with custom data sets for self-service scenarios.
For large-scale professional data integration, Fabric provides comprehensive SAP connectivity as well, covering a wide range of SAP applications and use cases:
The SAP HANA connector, released in March 2024, is available in Fabric pipelines. It offers advanced scalability options, including built-in support for partitioning or for complex SQL queries using pipeline parameters. The SAP HANA connector can be used in Fabric Copy Jobs as well.
Beyond this, we are excited to announce that we now offer two of the most highly requested SAP connectors in Fabric pipelines as well:
- The SAP Table connector provides access to SAP tables/views or CDS views via the SAP application or message server. For large data volumes it offers partitioning capabilities to chunk and transfer data in smaller units.
- The SAP BW OpenHub connector can extract data at scale from BW InfoProviders like ADSOs, InfoCubes, etc. via SAP BW’s OpenHub destinations.
All built-in SAP connectors are based on the On-premises data gateway (OPDG). On the server or virtual machine which hosts OPDG, customers also need to install the required SAP drivers (e.g. the SAP .Net Connector or the SAP HANA ODBC driver).
For OData-based SAP scenarios, like extraction from SAP SuccessFactors or OData services in ABAP-based SAP applications like SAP ECC and SAP S/4HANA, we recommend using the generic OData connector in Fabric pipelines or data flows.
Let’s summarize the sources and use cases for the built-in SAP connectors:
| Connector | Sources | Use Case | Fabric DI artefact |
| SAP BW (Application Server or Message Server) |
|
|
Dataflow Gen2 |
| SAP HANA |
|
|
|
| SAP Table (Application Server or Message Server) |
|
|
|
| SAP BW OpenHub (Application Server or Message Server) |
|
|
|
| OData |
|
|
|
| ODBC |
|
|
|
SAP-certified partners integrating with Fabric
At FabCon Europe in September 2024, we announced our collaboration with several partners specialized on SAP data integration: Integrate your SAP data into Microsoft Fabric. By that time, all these partners had enabled their solutions to ingest data as files into Fabric OneLake, covering a broad range of scenarios, from table snapshots, over data extraction from SAP transactions, mass-data enabled extraction from BW or S/4HANA analytic queries to trigger-based change data capture.
Open mirroring for SAP sources
Capturing change data from SAP is challenging, yet crucial for many enterprise scale analytics scenarios. We have been working with many SAP-certified partners to deeply integrate with Mirroring in Microsoft Fabric. Mirroring in Microsoft Fabric enables customers to leverage these partner solutions to land the initial and delta data in Fabric OneLake, and leverage Fabric’s powerful change data capture engine in Mirroring to deliver data ready for analytics efficiently and in near real-time.
For more details on open mirroring, refer to the Introducing Open Mirroring in Microsoft Fabric blog post.
The integration with Mirroring in Microsoft Fabric has been released, in collaboration with several SAP-certified partners. This integration allows for new methods to transfer SAP data into Fabric OneLake and utilize Microsoft Fabric and Power BI for analytics.
In February 2025, we announced the availability of dab Nexus and Simplement Roundhouse as our first partner solutions supporting open mirroring for SAP: Open Mirroring for SAP sources – dab and Simplement.
This month, we are excited to announce three more SAP-certified partners (SAP Certified Solutions Directory) joining our open mirroring ecosystem:
- With release 2502, SNP Glue added support for open mirroring into Microsoft Fabric. For more information on open mirroring with SNP Glue, refer to Unlocking SAP data for advanced analytics with SNP Glue and Microsoft Fabric.
- The ASAPIO integration Add-on now enables mirroring from SAP sources into Microsoft Fabric through its Fabric connector.
- Theobald Xtract Universal integrates with open mirroring starting with version 2025.3.26.15: Change Data Capture from SAP to Fabric.
For an introduction to our open mirroring partners, their offerings and live demos, check out the SAP-on-Azure podcast episodes #225 and #234.
Conclusion
Having their SAP data available in Fabric and combining it with other sources for comprehensive analytics is one of the top requirements of our customers. However, individual customer requirements, use cases and preferences vary widely. Our goal is therefore to provide every customer with a suitable option to leverage their SAP data in Microsoft Fabric. This blog post summarizes the latest advancements around built-in connectors and integration with partner solutions.
Beyond this, there are options for customers to leverage SAP Datasphere to integrate data from SAP applications with Fabric. Microsoft also continues to partner deeply with SAP to bring additional integrations between SAP Business Data Cloud and Azure. This will be the focus of some of our future set of posts.
