Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore a comprehensive comparison between SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) in this informative conference talk. Delve into the features, strengths, and weaknesses of both data movement and transformation tools. Learn about their common functionalities and unique capabilities, while gaining insights into performance, administration, monitoring, troubleshooting, and cost considerations. Witness practical demonstrations showcasing real-world applications of SSIS and ADF, and discover which tool is better suited for specific tasks within the SQL Server ecosystem. Gain valuable knowledge to make informed decisions when choosing between these mature and capable data integration platforms.
Syllabus
Introduction
About Tim Mitchell
Evaluations
Agenda
Biases
SSIS History
SSIS Catalog
SSIS Strengths
SSIS Weaknesses
Azure Data Factory
Strengths
Challenges
Functionality
Simple Operations
Data Movement
Integration Services Demo
Azure Portal
Copy Data
Data Flow
Loops
Performance
Performance Demo
Performance Results
Taught by
PASS Data Community Summit