Head to Head - SSIS Versus Azure Data Factory
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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
Related Courses
Doing More with Less - The Challenges Ahead for Every Data ProfessionalPASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube