Mirroring Azure SQL DB into Microsoft Fabric OneLake Demo

In this video, I’ll show you how to set up and configure Mirroring between an Azure SQL Database and Microsoft Fabric OneLake.

Mirroring is a powerful, low-latency replication feature that allows you to bring your operational data directly into Fabric for analytics without the overhead of building and managing complex ETL pipelines. I’ll walk you through the source-side prerequisites, the connection process in the Fabric portal, and demonstrate how data changes in your SQL database are reflected in near real-time within your Fabric workspace.

🚀 In This Video, We Cover:

Prerequisites: Configuring SQL Authentication and enabling System Assigned Managed Identity (SAMI) on your SQL Server.

Networking: Allowing Azure services to access your SQL server for seamless connectivity.

Database Options: Using the default "AdventureWorks" database versus custom databases for mirroring.

Fabric Implementation: Step-by-step guide to creating a Mirror SQL Database item and establishing a secure connection.

Data Type Limitations: Understanding which user-defined and unsupported data types will not replicate.

Real-time Sync Test: Demonstrating row deletion in Azure SQL and verifying the update in Fabric using the SQL Analytics endpoint.

Visit the Cloud Nerchuko blog:
👉 https://cloudnerchuko.in

🔗 Resources Mentioned:

Microsoft Fabric Documentation on SQL DB Mirroring: https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-overview

Video Timeline
[00:00] Introduction to Mirroring Azure SQL Database in Microsoft Fabric
[00:22] Source-side Prerequisites: SQL Auth, SAMI, and Networking
[02:02] Reviewing the Source SQL Server and Database Configuration
[02:43] Enabling Firewall Rules for Azure Service Access
[03:20] Verifying Source Data in the Azure SQL Query Editor
[04:10] Microsoft Fabric Setup: Creating a New Workspace
[04:39] Creating the Mirror SQL Database Item and Connection String
[06:47] Selecting Tables and Identifying Unsupported Data Types
[08:13] Provisioning the Mirror Database and SQL Analytics Endpoint
[09:04] Monitoring Replication Status (Started vs. Running)
[09:48] Troubleshooting Initial Sync Latency in the T-SQL Editor
[13:03] Querying Mirrored Data and Row Count Verification
[13:42] Real-time Sync Test: Deleting a Row in the Source SQL DB
[14:00] Verifying Near Real-time Replication in Fabric OneLake
[15:18] Summary of Limitations and Wrap-up

If this tutorial helped you simplify your cloud data replication, please hit the LIKE button and SUBSCRIBE for more cloud and data engineering content!

#MicrosoftFabric #AzureSQL #OneLake #DataEngineering #CloudNerchuko #AzureTutorial #DatabaseMirroring #DataIntegration #RealTimeAnalytics

Видео Mirroring Azure SQL DB into Microsoft Fabric OneLake Demo канала Cloud Nerchuko