PaaSport to Paradise: Lifting and Shifting with Azure SQL Database + SSIS in Azure Data Factory

This session will focus on the PaaS solution for Azure SQL DB/Managed Instances (MI) + SSIS within Azure Data Factory (ADF). It allows you to lift, shift, modernize and extend ETL workflows. We first show you how to provision Azure-SSIS Integration Runtime (IR) - dedicated ADF servers for running SSIS - with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI, configure it to access data on premises using Windows authentication and virtual network injection/self-hosted IR as a proxy, and extend it with custom/open source/third-party components. We next show you how to use the familiar SSDT/SSMS tools to design/test/deploy/execute your SSIS packages in the cloud just like you do on premises. We also show you how you can modernize your ETL workflows. This includes scheduling SSIS package executions in ADF pipelines, and then combining/chaining them together with other activities. You can trigger your pipeline runs automatically (de)provision SSIS-IR just in case, etc.