Advancing SAP Connectivity in Microsoft Fabric
By Ulrich Christ, Wilson Lee, Linda Wang, and Ye Xu
Microsoft Fabric offers advanced data integration features that set it apart within the industry. Through features like shortcuts and Mirroring, it enables zero-ETL approaches to data unification. Fabric Data Factory provides the industry’s largest, most widely adopted data integration capability offered as a single, cohesive SaaS led, multi-cloud ready experience. Together, these capabilities enable Fabric customers to break down the silos within data estates to unlock the true value of data no matter where it resides.
For enterprise customers, SAP represents one of the most valuable data sources, and integration of SAP data with other non-SAP data estates is one of the top requirements we hear from them. Consequently, we continue to deliver innovations in the area of SAP data integration to provide our customers with easy-to-use and yet powerful ways to leverage the capabilities of Microsoft Fabric on their SAP data.
We’ve made two major enhancements – Mirroring for SAP Datasphere and Copy Job support for SAP Datasphere – both now available in preview. These new capabilities enable customers to mirror and operationalize SAP data into Fabric OneLake with minimal latency. With their SAP and non-SAP data combined in OneLake, customers can create dashboards, run advanced analytics or leverage Fabric Data Agents in Microsoft Fabric to maximize the business value of their unified data estate.
Mirroring for SAP Datasphere: Zero-ETL, Near Real-Time Replication of your SAP data into OneLake
Mirroring in Microsoft Fabric delivers a truly game-changing, no-ETL experience—empowering you to replicate SAP data into OneLake with full fidelity and minimal operational overhead. With Mirroring for SAP Datasphere, organizations can now effortlessly bring data from their entire SAP application landscape into Fabric, all while preserving business logic, security, and data lineage. Your SAP data is always fresh, instantly available for analytics, machine learning, and reporting—no more delays or risks from manual extraction or transformation.
Mirroring seamlessly integrates Fabric’s advanced mirroring engine with SAP Datasphere’s powerful replication capabilities, unlocking connectivity through SAP’s native data extraction technologies. This means direct access to the full suite of SAP applications—whether it’s SAP S/4HANA (on-premises or cloud), SAP ECC, SAP BW, SAP BW/4HANA, or cloud solutions like SAP SuccessFactors, SAP Ariba, and SAP Concur.
“As part of our migration journey, we’ve implemented both Mirroring for SAP Datasphere and Mirroring for Oracle to replicate data into Fabric OneLake, integrating hundreds of millions of financial and other operational records. This enables unified, near‑real‑time reporting across finance and operations—enhancing transparency, accelerating close cycles, and improving decision‑making.”
Chandrashis Bhowmick, Sr Manager Architect @ CSX
With Mirroring, you can:
- Eliminate data silos by bringing SAP data alongside other enterprise sources in OneLake.
- Maintain end-to-end data lineage and governance for compliance and auditability.
- Accelerate time-to-insight with near real-time data replication no custom ETL required.
To learn more about Mirroring for SAP Datasphere, refer to the Mirrored database from SAP Datasphere documentation.
Copy job for SAP Datasphere: Enable Petabyte-Scale Data Movement with your SAP data
Copy Job in Fabric Data Factory now brings its petabyte-scale, cross-cloud data movement power to SAP data—unlocking new possibilities for enterprise data integration. Whether you’re bulk ingesting historical records, setting up blazing-fast incremental loads, or enabling native change data capture (CDC), Copy Job delivers a managed, secure, and network-compliant solution built for scale.
Powered by Copy Job’s integration with SAP Datasphere, you’re never locked into a single cloud. Move and distribute data from any SAP source—on‑premises or in the cloud—to destinations across Azure, AWS, Snowflake, and more, at petabyte scale. Fabric’s rich connectivity empowers true multi-cloud flexibility, so your SAP data is always where you need it, ready to drive analytics and innovation across your entire enterprise.
With Copy Job, you can:
- Effortlessly move SAP data—bulk, incremental, or CDC—to any destination across clouds, with flexible table and column mapping for total control.
- Rely on enterprise-grade security and compliance, leveraging VNet gateways and robust authentication.
- Unify SAP data with other sources for holistic analytics and AI, orchestrating end-to-end data movement and transformations in a single pipeline.
To learn more about Copy Job for SAP Datasphere, refer to the Copy Job with SAP Data documentation.
SAP Connectivity in Fabric Data Factory
Beyond the new announcement of Mirroring and Copy Job for SAP Datasphere, Microsoft Fabric delivers a truly comprehensive suite of built-in SAP connectors—empowering both professional developers and citizen integrators to unlock the full potential of their SAP data.
For citizen data integration, Dataflow Gen2 makes it easy to connect to semantically rich analytic assets in SAP, with features like measuring definitions, currency conversions, and user authorizations.
- SAP HANA connector: Instantly access SAP HANA or SAP HANA Cloud—whether you need analytic views or standard database tables.
- SAP BW connector: Seamlessly connect to the analytic layer (BW queries) of SAP BW, SAP BW/4HANA, and the analytic CDS layer in SAP S/4HANA.
For professional data integration, Fabric’s built-in SAP connectors power Copy Job and pipeline Copy Activities, delivering the same robust connectivity trusted in Azure Data Factory.
- SAP HANA connector: Extract massive volumes of data from SAP HANA and SAP HANA Cloud via ODBC, with advanced features like partitioning and parameterized SQL.
- SAP Table connector: Access tables, views, or CDS views in SAP S/4HANA and SAP ECC through the application layer.
- SAP BW OpenHub connector: Enable outbound integration via SAP BW’s OpenHub interface for seamless data movement.
With Fabric Data Factory, SAP connectivity is not just comprehensive—it’s powerful, flexible, and ready to accelerate your analytics and AI initiatives.
| Connector | Sources | Use Case | Fabric DI artefact |
| SAP BW (Application Server or Message Server) | SAP BW, SAP BW/4HANA SAP S/4HANA | Access to multidimensional analytic layer | Dataflow Gen2 |
| SAP HANA | SAP HANA, SAP HANA Cloud SAP Datasphere SAP BW-on-HANA, SAP BW/4HANA | Access to multidimensional analytic layer Access to SQL artifacts (tables, views) Access to HANA Calculation Views exposed by SAP BW-on-HANA or BW/4HANA | Dataflow Gen2 Pipeline Copy Job |
| SAP Table (Application Server or Message Server) | SAP S/4HANA SAP ECC | SAP data dictionary (DDIC) tables, views ABAP CDS Views | Pipeline Copy Job |
| SAP BW OpenHub (Application Server or Message Server) | SAP BW | Access to data in BW InfoProviders (ADSOs, etc.) via OpenHub destination | Pipeline Copy Job |
| OData | SAP SuccessFactors SAP C4C SAP S/4HANA SAP ECC | OData Services | Dataflow Gen2 Pipeline Copy Job |
| ODBC | SAP HANA, SAP HANA Cloud SAP Datasphere | Access to SQL artifacts (tables, views) | Dataflow Gen2 Pipeline Copy Job |
Enabling AI-Ready Data for Data Agents
The future of enterprise AI starts with unified, high-quality data—and Microsoft Fabric is leading the way. With Mirroring and Copy Job for SAP Datasphere, organizations can seamlessly bring their most critical SAP data into OneLake, right alongside data from every other part of the business. This means your entire data estate—SAP and non-SAP—is instantly accessible, always up to date, and ready to fuel the next generation of AI-powered insights.
Once your data lands in OneLake, Data Agents in Fabric can tap into this rich, curated foundation to deliver breakthrough analytics and intelligent automation. Imagine combining financial data from SAP S/4HANA with customer engagement metrics, supply chain records, and external market signals—all in one place, all ready for AI.
Explore how Data Agents in Microsoft Fabric can help you unlock the full potential of your SAP and non-SAP data, please learn more with Data Agents in Microsoft Fabric.
What’s next for SAP data in Microsoft Fabric
We are excited to announce the launch of SAP Business Data Cloud Connect for Microsoft Fabric. SAP BDC Connect for Microsoft Fabric empowers organizations to fully harness their data and applications by delivering secure, rapid access to SAP data products at scale—without the delays of data replication.
Through bi-directional, zero-copy sharing between SAP Business Data Cloud and Microsoft Fabric, customers can realize use cases that previously required moving and managing copies of data. With this Zero-Copy approach, SAP data products will be is seamlessly integrated into Microsoft OneLake, Microsoft Fabric’s AI ready data lake, and data sets shared from Microsoft OneLake will also be available in SAP Business Data Cloud to supplement intelligent applications. By utilizing Fabric’s advanced data engineering, data warehousing, and Power BI capabilities, organizations can effectively integrate SAP data with their broader ecosystem, establishing a unified foundation for their enterprise data. OneLake integration into Microsoft AI Foundry can also helps customers leverage their SAP data in building AI applications, and as OneLake is built into Microsoft 365, hundreds of millions of users can get secure access to their SAP data through the products they use everyday such as Excel and Teams.
SAP BDC integration for Microsoft Fabric will become available in calendar year 2026.
Start your Microsoft Fabric Journey Today
Microsoft Fabric Data Factory is revolutionizing how organizations integrate, manage, and activate their data. With Mirroring and Copy Job for SAP Datasphere, you can seamlessly unify SAP and non-SAP data in OneLake—eliminating silos and unlocking real-time analytics, AI, and innovation across your organization.
These capabilities empower you to:
- Instantly replicate SAP data with Mirroring for SAP Datasphere—no ETL required.
- Full control to move SAP data at petabyte scale, securely and flexibly, with Copy Job for SAP Datasphere.
- Connect and combine data sources using Fabric Data Factory’s built-in SAP connectors.
- Activate Data Agents to transform unified SAP and non-SAP data into actionable, AI-powered insights.
Now is the perfect time to start your SAP journey with Microsoft Fabric. Experience the future of data integration, accelerate your analytics, and unlock new business value.
We’re excited to see what you build and discover with these new capabilities. Stay tuned to our Fabric roadmap for upcoming innovations, and join the conversation on the Fabric blog, forums, and Ideas channels as you help shape the future of data in Microsoft Fabric!
