The Integration Blueprint: Choosing the Right Path in Microsoft Fabric

Data Engineers in Toronto November 2026 Semimonthly Meeting Topic: The Integration Blueprint: Choosing the Right Path in Microsoft Fabric Abstract: In a world of multiple tools and endless data sources, how do you design the right integration strategy in Microsoft Fabric? Join Javier and Gaston, two Microsoft MVPs in Data Platform for a live demo-driven session that breaks down the real-world patterns, use cases, and best practices for landing, transforming, and orchestrating data in Microsoft Fabric. Whether you’re working with a Lakehouse, Data Warehouse, Eventhouse, or SQL Database, this session gives you the playbook to select and combine the right tools for the job. We’ll walk through: • Landing data using Data Pipelines, OneLake shortcuts, and external connections • Transforming and cleaning data using Notebooks (Spark) for scale and flexibility • Business logic and last-mile transformation using Dataflows Gen2 • How to orchestrate it all using Fabric Data Pipelines for repeatable, maintainable workflows • When and why to land your data into Lakehouses, Data Warehouses, Eventhouses, or SQL endpoints. You’ll walk away with: • A clear understanding of which tools to use when across the Fabric integration stack • A working knowledge of how to combine multiple integration techniques in one solution • Architecture patterns and decision criteria for building scalable data landing zones • Live demos you can replicate to accelerate your own Fabric journey Speaker: Javier Villegas, IT Director & Microsoft MVP Data Platform Speaker Profile: Javier Villegas is IT Director (DBA & BI Services) at Mediterranean Shipping Company with 30 years of experience working with SQL Server, Including Azure SQL. His specialization is Administration, Performance Tuning, High Availability and Disaster Recovery. Javier is a Microsoft MVP Data Platform since 2016 and MCT He is a frequent speaker in technical conferences and events such as SQL Saturdays, PASS Virtual Groups, PASS Ma