Microsoft Fabric: Import On Premise SQL Server Data into Fabric SQL Database!
Azure SQL Database in Microsoft Fabric, aka Fabric SQL Database, aka #FabSQL is here! Now we need to get data into it! In this video Bradley Ball, aka @SQLBalls , guides you through installing an On Premise Data Gateway, connecting it to your #MicrosoftFabric Tenant, and then building a Dynamic Data Pipeline to import the data into Fabric SQL DB!
Chapters
00:00 Dynamic Import for Fabric SQL Database
00:58 Demo Enable Fabric SQL Database at the Tennant
01:36 Demo Create Fabric SQL Database
02:03 Demo Install On Premise Data Gateway
02:52 Demo Create Connection to On Premise SQL Server
03:38 Demo T-SQL Query to Dynamically Get Tables & Schemas
03:58 Demo Create Dynamic Data Pipeline to Import Data
07:18 Demo Validate Data Transfer
08:01 Demo Check the Mirror for Replication
SQL database in Microsoft Fabric (Preview)
https://learn.microsoft.com/en-us/fab...
Microsoft Fabric decision guide: choose a SQL database
https://learn.microsoft.com/en-us/fab...
Install an on-premises data gateway
https://learn.microsoft.com/en-us/dat...
Data Factory documentation in Microsoft Fabric
https://learn.microsoft.com/en-us/fab...
Ingest data into your Warehouse using data pipelines
https://learn.microsoft.com/en-us/fab...
/*******************
/CONNECT WITH US!!
/*******************
Tales from the Field
Twitter: / talesftfield
Linkedin: / 100091910
Blusky: https://bsky.app/profile/talesfromthe...
Bradley Ball
Twitter: / sqlballs
Linkedin: / sqlballs
Blusky : https://bsky.app/profile/sqlballs.bsk...
Daniel Taylor
Twitter: / dbabulldog
Linkedin: / danieltaylor3
Blusky: https://bsky.app/profile/dbabulldog.b...
Neeraj Jhaveri
Twitter: / neeraj_jhaveri
Linkedin: / neerajjhaveri
Blusky: https://bsky.app/profile/neerajny.bsk...
Josh Luedeman
Twitter: / joshluedeman
Linkedin: / joshluedeman
Blusky: https://bsky.app/profile/joshluedeman...
Andrés Padilla
Twitter: / nodestreamio
Linkedin: / andrespadillaandrade