Fabric Insider Ep. 9 — Data Integration, Migration & Future of ETL Microsoft Fabric | Wee Hyong Tok

Is ETL as we know it coming to an end? What does AI mean for the future of data integration? And what is the easiest migration path from ADF, Synapse, or SSIS to Microsoft Fabric? In this episode of Fabric Insider, I sit down with Wee Hyong Tok — Principal Product Manager at Microsoft — for a wide-ranging conversation on the present and future of data integration in Microsoft Fabric. From Dataflows and Pipelines to Apache Airflow, DBT, Copy Jobs, Mirroring, SCD Type 2, MCP Servers for Data Factory, and what AI means for the ETL developer's career — this episode covers the full landscape of data integration in Fabric in 2026. 📌 What we cover in this episode: 🔌 Data Integration in Fabric — Dataflows, Pipelines, Copy Job, Mirroring, and simplified ingestion ✈️ Apache Airflow in Fabric — what it is, why you should use it, and the right scenarios 🛠️ DBT integration with Microsoft Fabric — what is possible today 🚀 Why should you migrate to Fabric Data Factory? ⏰ When is the right time to migrate? 🔄 ADF and Azure Synapse Pipelines to Fabric Data Factory — current status, improvements, and what to use today 📦 SSIS migration to Fabric — how simple is it really? 🤔 Will ETL development eventually disappear? Copy Job, Mirroring, and the no-ETL future 🔢 SCD Type 2 simplified in Copy Job — how it works 🤖 MCP Server for Data Factory — what it covers, Dataflows, Power Query, Pipelines 🧠 AI impact on ETL developers — what should they consider for the path forward? 🗺️ New features coming up 🎙️ Fabric Insider Series — direct conversations with Microsoft product team members on what is new, what is coming, and what matters most in Microsoft Fabric and Power BI. 🔗 Wee Hyong Tok on LinkedIn: https://www.linkedin.com/in/weehyongtok/ 📺 Full Fabric Insider Playlist: https://www.youtube.com/playlist?list=PLMXQvYI7QV6f8vUxtlFuGzQk-tYj3uOTn 🎧 Fabric Insider on Spotify: https://open.spotify.com/show/4eJrCr5UOWZ7ggmrVUce6l?si=Jx18sgdaScCgR3P1oDz-dw 📚 Fabric Insider Blog Series: https://radacad.com/category/fabric-insider-2026/ 💡 Power BI / Fabric Ideas: https://ideas.fabric.microsoft.com 💬 Microsoft Fabric Reddit: https://www.reddit.com/r/MicrosoftFabric/ 📌 Previous Fabric Insider Episodes: 🎙️ Ep. 1 — Wilson Lee: Fabric Mirroring, Copy Job & SAP Integration 🎙️ Ep. 2 — Zoe Douglas: Power BI Visualization Updates & Roadmap 🎙️ Ep. 3 — Miguel Escobar: Power Query, Dataflows & What's Next 🎙️ Ep. 4 — Santhosh Kumar Ravindran: Fabric Spark Performance & Custom Live Pools 🎙️ Ep. 5 — Christian Wade: What's Hot and New for Power BI Semantic Models 🎙️ Ep. 6 — Yitzhak Kesselman: Real-Time Intelligence & Fabric IQ 🎙️ Ep. 7 — Rie Merritt: Everything About the Microsoft MVP Program 🎙️ Ep. 8 — Hasan Abo-Shally: Fabric MCP Servers, CLI & AI Agents 📖 Related resources on RADACAD: 🔗 Getting Started with Data Pipelines in Fabric Data Factory: https://radacad.com/getting-started-with-data-pipelines-in-fabric-data-factory/ 🔗 Different Versions of Dataflow in Power BI and Microsoft Fabric: https://radacad.com/different-versions-of-dataflow-in-power-bi-and-microsoft-fabric/ 🔗 What is Microsoft Fabric: https://radacad.com/what-is-microsoft-fabric/ 🔗 RADACAD Blog: https://radacad.com/blog/ 🌐 RADACAD Website: https://radacad.com 🔗 Corporate Training: https://radacad.com/corporate-training/ 🔗 Power BI Training: https://radacad.com/power-bi-training/ 🔗 Microsoft Fabric Training: https://radacad.com/microsoft-fabric-training/ #MicrosoftFabric #DataIntegration #FabricDataFactory #ETL #ApacheAirflow #DBT #CopyJob #Mirroring #FabricInsider #WeeHyongTok #ADF #SSIS #SynapseAnalytics #MigrationToFabric #AIAgents