Mirroring for Oracle in Microsoft Fabric (Preview)
With this new capability, organizations can bring their Oracle data—whether on-premises, in Oracle Cloud Infrastructure (OCI), or on Exadata—directly into OneLake, Fabric’s unified Data Lake. Meaning your Oracle data is always fresh, instantly query able, and seamlessly integrated with the rest of your analytics stack—without the complexity of traditional ETL.
Integrating Oracle Data Seamlessly into OneLake
Mirroring in Microsoft Fabric is a low latency, near real-time data replication solution that continuously brings external data sources into OneLake, Fabric’s unified data lake. Unlike traditional ETL pipelines, mirroring requires no transformation or migration steps—data is simply and efficiently kept in sync. Your external data becomes instantly query able in the Fabric Data Warehouse view and is immediately available for analytics, AI/ML, and reporting scenarios across Power BI and other Fabric workloads.
Unlocking the Power of Mirroring Oracle in Fabric (Preview)
Once mirrored, Oracle data sits alongside other cloud data sources, enabling cross-cloud querying, unified semantic models, and integrated analytics within the Fabric ecosystem.
With Mirroring for Oracle, you can:
- Continuously replicate tables from Oracle into OneLake with zero ETL.
- Combine Oracle data with other mirrored sources like Google BigQuery, Snowflake, and SQL Server.
- Run cross-cloud SQL queries directly in Fabric.
- Build semantic models that unify data across your entire estate.
What’s Supported?
- Oracle on-premises (e.g., VM, Azure VM)
- Oracle Cloud Infrastructure (OCI)
- Oracle Exadata
Autonomous databases are not supported at this time. Supported Oracle versions (versions 11 and above) must have LogMiner enabled. Database administrators may need to configure archived redo log files and supplemental logging to ensure successful replication.
More details on what permissions are needed, and the limitations can be found in the What is Mirroring in Fabric documentation.
Why This Changes the Game
Enterprises rely on Oracle databases to run mission-critical workloads, but historically, unlocking insights across Oracle and other data systems has required costly, slow ETL pipelines. With Mirroring for Oracle, Microsoft Fabric removes this friction:
- No ETL required – replicate data continuously and near real-time.
- Unified data estate – Oracle data joins seamlessly with BigQuery, Snowflake, SQL Server, and more in OneLake.
- Cross-cloud analytics – run SQL queries that span Oracle and other sources in a single Fabric warehouse.
- End-to-end integration – Power BI dashboards, AI/ML models, and downstream pipelines can run on always-fresh Oracle data.
- Faster time-to-insight – organizations can modernize their analytics stack without waiting for batch ETL jobs or migrations.
This is a major step in helping customers break down cloud silos and modernize their data strategy with Fabric.
Early adopters have highlighted just how much faster and easier insights have become with Oracle mirroring:
“CSX Transportation aims to leverage Mirroring for Oracle in Microsoft Fabric to manage and access operational data. We’re now able to stream real-time data from multiple on-premises Oracle systems across our rail network directly into Fabric—eliminating the complexity of traditional ETL pipelines. With billions of rows ingested and refreshed hourly, we finally have a unified, scalable data foundation to drive predictive analytics, reporting, and machine learning. This has significantly accelerated our ability to make data-driven decisions across the organization” – Chandra Bhowmick, CSX
Dive Deeper and Learn More
Mirroring for Oracle is just the beginning. This capability will continue to evolve based on your feedback. Our roadmap includes enhancements to user experience, telemetry and monitoring, and performance and scalability—all with the goal of making mirroring even more seamless and powerful.
- Explore the Mirroring for Oracle Overview documentation.
- Review Oracle mirroring prerequisites and setup guidance.
With Mirroring for Oracle in preview, Microsoft Fabric takes another leap toward a unified, real-time, cross-cloud data platform. Your Oracle data doesn’t have to live in a silo—it can power insights alongside all your other cloud data, seamlessly and instantly.
