Microsoft Fabric: Import On Premise SQL Server 2022 Data into Microsoft Fabric with Data Pipelines!!

Bradley Ball, aka @SQLBalls, walks us through how to install, setup, and configure a data gateway. Then how to register that data Gateway in Microsoft Fabric. We then use a Data Pipeline to import data from #SQLServer2022 into #MicrosoftFabric!

Chapters
00:00 Importing Data with Microsoft Fabric
01:21 Demo - Our SQL 2022 Data
01:42 Demo Install on-premises data gateway
02:31 Demo Configure SQL Server 2022 Connection
03:36 Demo Super Importaint Configure your ADLS Gen 2 Storage for Staging
03:57 Demo Create Data Pipeline
05:01 Demo Configure Staging
05:45 Demo Validate Data Import



Install an on-premises data gateway
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field
Twitter: https://twitter.com/TalesftField
Linkedin: https://www.linkedin.com/company/100091910/
Blusky: https://bsky.app/profile/talesfromthefield.bsky.social

Bradley Ball
Twitter: https://twitter.com/SQLBalls
Linkedin: https://www.linkedin.com/in/sqlballs/
Blusky : https://bsky.app/profile/sqlballs.bsky.social


Daniel Taylor
Twitter: https://twitter.com/dbabulldog
Linkedin: https://www.linkedin.com/in/danieltaylor3/
Blusky: https://bsky.app/profile/dbabulldog.bsky.social

Neeraj Jhaveri
Twitter: https://twitter.com/neeraj_jhaveri
Linkedin: https://www.linkedin.com/in/neerajjhaveri/
Blusky: https://bsky.app/profile/neerajny.bsky.social

Josh Luedeman
Twitter: https://twitter.com/joshluedeman
Linkedin: https://www.linkedin.com/in/joshluedeman/
Blusky: https://bsky.app/profile/joshluedeman.bsky.social

Andrés Padilla
Twitter: https://twitter.com/nodestreamio
Linkedin: https://www.linkedin.com/in/andrespadillaandrade/