June 2025
Beginner to intermediate
446 pages
10h 46m
English
Content preview from Fundamentals of Microsoft Fabric
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 11. Mirroring
We looked into SQL databases in Chapter 10, and this chapter will focus on a feature that allows you to seamlessly integrate operational data from other sources with Fabric through a smart mechanism called mirroring.
Imagine a global retail company with operations spanning multiple regions, each store with its own dedicated OLTP database, running in that store’s closest Azure region on Azure SQL database. The company headquarters, located in the United States, frequently runs complex analytical queries to assess worldwide sales trends and inventory status. Instead of creating manual ETL tasks for each of the stores or relying on slow cross-region queries, the company leverages mirroring in Microsoft Fabric. By mirroring the key datasets from the organization’s globally distributed operational databases to the US-based data warehouse in Fabric, analysts can access fresh data from all regions seamlessly without using any ETL.
This approach eliminates the latency and complexity of querying remote datasets or manually moving data in real time, providing a centralized view of global operations while ensuring the data remains localized for regional workloads. The simplicity and efficiency of mirroring transform the company’s global analytics strategy, making it faster and more scalable without extensive data movement or complex integration.
What Is Mirroring?
Mirroring creates a near real-time, read-only copy of a dataset from an external source within a Fabric ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.