This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift & shift, modernize, and extend ETL workflows. You will first learn to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI and extend it with custom components. You will also learn to configure SSIS IR to access data on premises using Windows authentication and Virtual Network injection. You can then use the familiar SSDT/SSMS tools to manage your SSIS packages in the cloud just like you do on premises. You will next learn to modernize your ETL workflows by invoking SSIS package executions as first-class activities in ADF pipelines, allowing you to chain them with other activities, automatically (de)provision SSIS IR just in time, store secrets in Azure Key Vault, and splice advanced transformations, such as Power Query Source, Data Quality Tasks, etc.
No material found.