Cathrine Wilhelmsen

Information & Communications Technology

Business Intelligence Data Warehousing Data Integration ETL Azure Data Platform Azure Data Factory Microsoft Data Platform SQL Server Integration Services SSIS Biml BimlScript 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

Senior BI Consultant at Inmeta | Data Platform MVP

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.


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

Cathrine's full speaker profile