Azure Data Factory (ADF) is a hybrid data integration service that lets you build, orchestrate, and monitor complex and scalable data pipelines - without writing any code! The first version of Azure Data Factory may not have lived entirely up to its nickname "SSIS in the Cloud," but the second version has been drastically improved and expanded with new capabilities.
But wait, what's that? You have already invested years and millions in a comprehensive SSIS solution, you say? No problem! You can lift and shift your existing SSIS packages into Azure Data Factory to start modernizing your solution while retaining the investments you have already made.
In this session, we will first go through the fundamentals of Azure Data Factory and see how easy it is to build powerful data pipelines or migrate existing SSIS packages. Then, we will explore some of the major improvements in Azure Data Factory v2, including Mapping and Wrangling Data Flows for creating visual data transformations. Finally, we will look at how to trigger and schedule our packages or pipelines, and how to monitor our solution once it has been deployed.
Interested in additional SentryOne webinars? Check our webinar library.
Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at sentryone.com/blog/author/kevin-kline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.
Cathrine loves teaching and sharing knowledge. She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.