Transitioning from SSIS to Azure Data Factory

Do you want to learn the process of transitioning from SSIS to Azure Data Factory (ADF)? In a recent webinar, Samuel Owusu teaches the differences and similarities between SSIS and ADF and how to run, schedule and monitor SSIS packages in ADF.

The presentation begins with a comparison of the two:

• SSIS – basically a data migration and ETL tool that has existed as a component of SQL Server since the SQL Server 2005 edition. Microsoft Integration Services (SSIS) is a platform for building enterprise level data integration and data transformation solutions.
• Azure Data Factory - a data orchestration tool. It is a cloud-based integration service that allows you to create data driven workflows in the cloud for orchestrating and automating data movement and transformation. This Platform as a Service offering in Azure was released in 2015.

The webinar will take a look inside of an SSIS package and an Azure Data Factory solution and then delves into the similarities and differences between these two tools. Samuel will compare things like dependencies, orchestration and pricing.

He’ll also discuss ADF strengths and some gaps it has compared to SSIS. The remainder of the webinar is spent on a demo of getting started with ADF and how to run, schedule and monitor SSIS packages in Azure Data Factory.

So, if you’re looking to make this transition and want to learn the process, this webinar is for you. Watch the complete webinar below.

If you want to learn more about SSIS, Azure Data Factory or need help with implementation of either of these platforms, we can help. Our team of experts has the right knowledge and can show you the right solutions, so your business can operate optimally and leverage data as an asset. Pragmatic Works consulting and managed services offerings will help you take your business from good to great. Contact us to start a conversation today.