6. Azure Data Factory | Copy Data from On-Prem SQL Server to ADLS Gen2 | SHIR Setup
Автор: Cloudpandith
Загружено: 2026-01-12
Просмотров: 89
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: