Microsoft Fabric: Import On Premise SQL Server 2022 into Microsoft Fabric using Data Factory!!

Bradley Ball, aka ‪@SQLBalls‬ , walks us through how to install, setup, and configure a Self Hosted Integration Runtime. Then to create a Linked Service to your SQL Server 2022 Instance and your Microsoft Fabric Lakehouse. We then use a #datapipeline to import data from #SQLServer2022 into #MicrosoftFabric! From there we use a #Spark #Notebook to show how we ingest the data into a #Lakehouse #Table!

Chapters
00:00 Introduction
00:57 The Architecure of the Demo
01:37 Demo - Our SQL Server 2022 Data
01:55 Demo - Install Self Hosted Integration Runtime
02:08 Demo - Register Self Hosted Integrtion Runtime in Data Factory
02:53 Demo - Create Linked Service for SQL 2022 Instance
03:28 Demo - Create Linked Service for Microsoft Fabric Workspace
05:01 Demo - Create Copy Data Pipeline from SQL 2022 to Microsoft Fabric
07:14 Demo - Run the Pipeline
07:30 Demo - Ingest the Data into a Lakehouse Table
07:57 Demo - How to Ingest the Data in a Spark Notebook
08:49 A Note about Microsoft Fabric vs Microsoft Fabric Tables import
09:42 Sound Off We Would Love to Hear from You

Copy and transform data in Microsoft Fabric Lakehouse (Preview) using Azure Data Factory or Azure Synapse Analytics
https://learn.microsoft.com/en-us/azu...


Quickstart: Register an application with the Microsoft identity platform
https://learn.microsoft.com/en-us/ent...

How to read and write data with Pandas in Microsoft Fabric
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