Cathrine Wilhelmsen

Information & Communications Technology

Business Intelligence Data Warehousing Data Integration ETL Azure Data Platform Azure Data Factory Azure Synapse Analytics Microsoft Data Platform SQL Server Integration Services SSIS Biml BimlScript Microsoft SQL Server SQL Server SQL

Oslo, Norway

Packages or Pipelines? Azure Data Factory for the SSIS Developer

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.

Session Level: 100-200 / Beginner-Intermediate
Session Length: 45-90 minutes
Prerequisites: Must have experience with SSIS development and administration. Should be familiar with Data Integration and/or ETL concepts and scenarios.

Cathrine Wilhelmsen

Tech Lead and Senior Data Management & Analytics Consultant in Skill | Microsoft Data Platform MVP

Cathrine loves data and coding, as well as teaching and sharing knowledge 🤓 She is based in Norway and works as a Tech Lead and Senior Data Management & Analytics Consultant in Skill, focusing on Data Integration and Data Warehousing. Her core skills are Azure Data Factory, Azure Synapse Analytics, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the Azure and Microsoft Data communities as a Microsoft Data Platform MVP, international speaker, blogger, organizer, and chronic volunteer. She blogs at and tweets at @cathrinew.

Cathrine is based in Norway, but loves traveling and speaking internationally.

Cathrine's full speaker profile