Back to the future: Accelerating the cloud migration of legacy SSIS with Azure Data Factory

%3CLINGO-SUB%20id%3D%22lingo-sub-865529%22%20slang%3D%22en-US%22%3EBack%20to%20the%20future%3A%20Accelerating%20the%20cloud%20migration%20of%20legacy%20SSIS%20with%20Azure%20Data%20Factory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-865529%22%20slang%3D%22en-US%22%3EThis%20session%20focuses%20on%20the%20new%20features%20to%20unblock%2Faccelerate%20cloud%20migration%20of%20legacy%20SQL%20Server%20Integration%20Services%20(SSIS)%2C%20such%20as%202008%20or%20earlier%20versions%2C%20with%20Azure%20Data%20Factory%20(ADF).%20We%20first%20show%20you%20how%20to%20provision%20Azure-SSIS%20Integration%20Runtime%20(IR)%20%E2%80%93%20dedicated%20ADF%20servers%20for%20running%20SSIS%20%E2%80%93%20and%20extend%20it%20with%20custom%2Fopen%20source%2Fthird-party%20components.%20We%20next%20show%20you%20how%20to%20enable%20the%20following%20scenarios%3A%20running%20SSIS%20packages%20stored%20in%20Azure%20Files%20as%20first-class%20activities%20in%20ADF%20pipelines%2C%20accessing%20Azure%20SQL%20DB%2FManaged%20Instance%20with%20OLEDB%20connectors%20that%20are%20configured%20for%20Azure%20Active%20Directory%20authentication%20with%20ADF%20managed%20identity%2C%20testing%20SSIS%20packages%20in%20ADF%20from%20SSDT%2C%20scheduling%20SSIS%20jobs%20in%20ADF%20from%20SQL%20Server%20Agent%2Fthird-party%20orchestrators%20that%20invoke%20Azure-enabled%20dtexec.exe%2C%20etc.%20Finally%2C%20we%20show%20you%20the%20complete%20SSIS%20Migration%20Playbook%20to%20perform%20batch%20package%20assessments%20and%20batch%20package%2Fjob%20migrations%20using%20Database%20Migration%20Assistant%2FService%2C%20dtutil.exe%2C%20scripts%2C%20etc.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-865529%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDatabases%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWRK3007%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Community Manager
This session focuses on the new features to unblock/accelerate cloud migration of legacy SQL Server Integration Services (SSIS), such as 2008 or earlier versions, with Azure Data Factory (ADF). We first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – and extend it with custom/open source/third-party components. We next show you how to enable the following scenarios: running SSIS packages stored in Azure Files as first-class activities in ADF pipelines, accessing Azure SQL DB/Managed Instance with OLEDB connectors that are configured for Azure Active Directory authentication with ADF managed identity, testing SSIS packages in ADF from SSDT, scheduling SSIS jobs in ADF from SQL Server Agent/third-party orchestrators that invoke Azure-enabled dtexec.exe, etc. Finally, we show you the complete SSIS Migration Playbook to perform batch package assessments and batch package/job migrations using Database Migration Assistant/Service, dtutil.exe, scripts, etc.

View this session in the session catalog

View session