6. Azure Data Factory | Copy Data from On-Prem SQL Server to ADLS Gen2 | SHIR Setup

In this video, we demonstrate how to copy data from an On-Premise SQL Server to Azure Data Lake Storage Gen2 using Azure Data Factory (ADF).

We also cover the complete installation and configuration of SQL Server Express 2022 and Self-Hosted Integration Runtime (SHIR) on a local laptop or computer.

This session is part of our Azure Data Factory & Azure Data Engineering course and focuses on real-time enterprise integration scenarios.

📌 Topics covered in this session:
✔ What is On-Premise SQL Server
✔ What is Azure Data Factory (ADF)
✔ What is Self-Hosted Integration Runtime (SHIR)
✔ Why SHIR is required for On-Prem to Cloud data movement
✔ Installation of SQL Server Express 2022
✔ Create sample database and tables in SQL Server
✔ Installation of SHIR on local computer / laptop
✔ Register SHIR with Azure Data Factory
✔ Create Linked Service for On-Prem SQL Server
✔ Create Linked Service for ADLS Gen2
✔ Create Dataset and Pipeline
✔ Copy data from On-Prem SQL Server to Data Lake Storage Gen2
✔ Debug and validate pipeline execution
✔ Real-time hybrid data integration use case

📌 Architecture Used:
On-Prem SQL Server
→ Self-Hosted Integration Runtime (SHIR)
→ Azure Data Factory
→ Azure Data Lake Storage Gen2

👉 Join now in Cloudpandith Training Institute and enhance your career by learning MS Azure Data Engineering course by real-time experts and with live project scenarios.

👩 For more details about Course Content visit:
https://www.cloudpandith.com

👩 Azure Data Engineer Demo Every Saturday 10 AM.

✍️ Message for more Details on WhatsApp:
https://wa.me/918904424822

✍️ Book Slot with Trainer to Meet:
https://meetpro.club/mallaiahsomula

🫵 Read about your Trainer:
https://goo.gl/maps/9jGub6NfLH2jmVeGA

☎️ Call Us @ 8904424822

Join our WhatsApp Group for Free Question & Answers Documents:
https://chat.whatsapp.com/Gow6Qxi77FN...

Join our Telegram Group for Free Question & Answers Documents:
https://t.me/+PGnxzlaFpvo1MWJl

🔥 This video is useful for:
✔ Azure Data Engineers
✔ ADF Developers
✔ ETL Developers
✔ Professionals working with Hybrid Architecture
✔ Interview & real-time project preparation

👍 Like | Share | Subscribe to CloudPandith for more Azure Data Factory tutorials
#AzureDataFactory
#ADF
#OnPremSQLServer
#SHIR
#ADLSGen2
#HybridIntegration
#AzureDataEngineering
#CloudPandith