From SQL SSIS to MS Fabric: Your ETL ReImagined
Description
You're a SQL SSIS ninja, and now Microsoft Fabric is calling your ETL pipelines to the cloud. In this session, you will learn how to bridge your SSIS skills to the more scalable and more performant and integrated SaaS environment with live demos and feature comparisons.
Key Takeaways
- You're a SQL SSIS ninja, and now Microsoft Fabric is calling your ETL pipelines to the cloud
- In this session, you will learn how to bridge your SSIS skills to the more scalable and more performant and integrated SaaS environment with live demos and feature comparisons
- Feature-oriented — demos and capabilities focus
My Notes
Action Items
- [ ]
Resources & Links
Slides
From SQL SSIS to
MS Fabric:
Your ETL Re-Imagined
Armando Lacerda
Cloud Solution Architect
alacerda@mvp.ms
http://aka.ms/Armando
Data Architect and Engineer
Microsoft MVP | Certified Trainer
Agenda
Scalability points
Bridging Orchestration Skills
Bridging Data Integration Skills
NEWS
FLASH
SSIS is not dead !
NEWS
FLASH
SSIS is a valid option for
data integration in the cloud.
NEWS
FLASH
SSIS can be faster to write to
SQL Server than Fabric items
In Summary ...
MS Fabric has multiple data transformation engines
MS Fabric has 3 orchestration engines
The choice of which one to use is based on: dataset size, dataset type and
team knowhow.
Like in SSIS, we find in Fabric both control flow and data flow with similar
functionalities.
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel
How was
the session?
Complete Session Surveys in
for your chance to WIN
PRIZES!