Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Mirroring in Fabric offers a simple way to avoid complex ETL (Extract, Transform, Load) processes and seamlessly integrate your existing SAP estate with the rest of your data in Fabric. You can continuously replicate your SAP data directly into Fabric's OneLake. Once in Fabric, you can take advantage of powerful capabilities for business intelligence, AI, data engineering, data science, and data sharing.
Why use mirroring in Fabric?
With Mirroring in Fabric, you don't need to piece together different services from multiple vendors. Instead, you can enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs, and built for openness and collaboration between Microsoft, SAP, and the 1000s of technology solutions that can read the open-source Delta Lake table format.
What analytics experiences are built in?
Mirroring creates a mirrored database and a SQL analytics endpoint in your Fabric workspace. The mirrored database manages replication of data into OneLake and conversion to Parquet, enabling downstream scenarios like data engineering, data science, and more.
Each mirrored SAP database has an autogenerated SQL analytics endpoint that provides a read-only analytical experience on top of the Delta tables created by the mirroring process. You can browse mirrored tables, build no-code queries and views, create SQL views and stored procedures, and query data across warehouses and lakehouses in the same workspace.
For more information on analytics capabilities and compatible tooling, see Mirroring objects.
Mirroring for SAP via SAP Datasphere
Mirroring for SAP combines the replication capabilities of SAP Datasphere with the Fabric mirroring. In a two-step process, SAP Datasphere replication flow extracts data (initial snapshot and changed records) from your SAP source system and lands it in an Azure Data Lake Storage (ADLS) Gen2 container. The mirroring replication engine then connects to that storage container and continuously merges the data with the mirrored database tables in OneLake.
This solution supports all types of SAP sources offered by SAP Datasphere, including SAP S/4HANA, SAP ECC, SAP BW/4HANA, SAP BW, and SAP Datasphere itself.
For a tutorial on configuring your mirrored SAP in Fabric, see Tutorial: Configure Microsoft Fabric mirrored databases from SAP via SAP Datasphere.
SAP mirroring cost considerations
Fabrics compute used to replicate your data into Fabric OneLake is free. The Mirroring storage cost is free up to a limit based on capacity. For more information, see Cost of mirroring and Microsoft Fabric Pricing. The compute for querying data using SQL, Power BI, or Spark is charged at regular rates.
Fabric doesn't charge for network data ingress fees into OneLake for Mirroring.
SAP Datasphere Premium Outbound Integration pricing applies when mirroring SAP data via SAP Datasphere.