Advanced SAP Data Integration with Microsoft Fabric: Mirroring and Copy Job
Ulrich Christ, Wilson Lee, Linda Wang, and Ye Xu introduce new SAP data connectivity features in Microsoft Fabric, detailing Mirroring and Copy Job for zero-ETL and scalable data integration for unified analytics and AI scenarios.
Advanced SAP Data Integration with Microsoft Fabric: Mirroring and Copy Job
By Ulrich Christ, Wilson Lee, Linda Wang, and Ye Xu
Microsoft Fabric now offers cutting-edge SAP data integration capabilities designed to unify enterprise data in the cloud for advanced analytics and AI applications. With newly announced Mirroring for SAP Datasphere and Copy Job support, organizations gain:
Key Capabilities
- Mirroring for SAP Datasphere: Achieve zero-ETL, near real-time replication of SAP data directly into OneLake, maintaining business logic, security, and data lineage. Supports major SAP applications (SAP S/4HANA, ECC, BW, SuccessFactors, Ariba, Concur) via native extraction technologies.
- Copy Job for SAP Datasphere: Move SAP data (bulk, incremental, CDC) at petabyte scale to destinations across Azure, AWS, Snowflake, and more. Enables managed, secure, cross-cloud data movement that powers holistic analytics and innovation.
Fabric Data Factory Integration
Fabric Data Factory provides:
- A wide suite of built-in SAP connectors (HANA, BW, ECC, S/4HANA, OData, ODBC, OpenHub) for both citizen and professional data engineers.
- Features for mapping tables, managing schema, and orchestrating full-scale integration pipelines in a multi-cloud context.
- Dataflow Gen2 and Pipeline support for easy access to analytic layers, SQL artifacts, and native SAP business objects.
Example Connector Table
| Connector | SAP Sources | Use Case | Fabric Artefact |
|---|---|---|---|
| SAP BW | SAP BW, BW/4HANA, S/4HANA | Multidimensional analytics layer | Dataflow Gen2 |
| SAP HANA | HANA, HANA Cloud, Datasphere | SQL tables, views, Calculation Views | Dataflow Gen2, Pipeline, Copy Job |
| SAP Table | S/4HANA, ECC | DDIC tables, ABAP CDS Views | Pipeline, Copy Job |
| SAP BW OpenHub | BW | Outbound integration with InfoProviders | Pipeline, Copy Job |
| OData | SuccessFactors, C4C, S/4HANA, ECC | OData services | Dataflow Gen2, Pipeline, Copy Job |
| ODBC | HANA, HANA Cloud, Datasphere | Access SQL tables, views | Dataflow Gen2, Pipeline, Copy Job |
AI-Ready Data and Data Agents
Unified data in OneLake enables Data Agents in Fabric to deliver advanced analytics and AI-powered automation. Integration points create cross-domain reporting (e.g., finance and customer metrics), all available in a single, secure environment—enhancing decision-making and business intelligence.
Upcoming: SAP Business Data Cloud Connect
SAP BDC Connect for Microsoft Fabric will soon allow zero-copy data sharing, securely integrating SAP data products into OneLake and making them accessible from both Microsoft 365 and SAP applications. Advanced data engineering, warehousing, and Power BI features will support enterprise-grade AI and analytics use cases for SAP and non-SAP estates.
Resources and Next Steps
- Mirrored database from SAP Datasphere documentation
- Copy Job with SAP Data documentation
- Data Agents in Microsoft Fabric
- Fabric roadmap
- Fabric blog
- Fabric forums
Organizations can now instantly replicate and unify SAP data, activate holistic analytics, and prepare their data estates for a new generation of AI-driven insights using Fabric’s expanding platform.
This post appeared first on “Microsoft Fabric Blog”. Read the entire article here