PaaSport to Paradise: Lifting & Shifting with Azure SQL Database/Managed Instance and SSIS in Azure Data Factory


This session focuses on the all-PaaS solution of Azure SQL Database/Managed Instance and SSIS in Azure Data Factory (ADF) to lift & shift on-premises ETL workloads and modernize ETL workflows in the cloud.

We will 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 Database server/Managed Instance or local file shares/Azure Files to store your SSIS projects/packages and extend it with custom/Open Source/3rd party components. 

We will also show you how to configure Azure-SSIS IR to access data on premises using Windows authentication, Virtual Network (VNet) injection, Self-Hosted IR as proxy, etc.  Preserving your skillsets, you can then use the familiar SQL Server Data Tools (SSDT)/SQL Server Management Studio (SSMS) to design/deploy/configure/execute/monitor your SSIS packages in the cloud just like you do on premises. 

Next, we will guide you to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to leverage ADF connectivity (+80 connectors), store secrets in Azure Key Vault (AKV), connect using Azure Active Directory (AAD) authentication with ADF managed identity, automatically provision Azure-SSIS IR on demand/just in time, trigger SSIS jobs/runs by file arrivals/deletions, splice advanced data transformations, such as Power Query Source, Data Quality (Matching/Cleansing) components, etc.  


Interested in additional SentryOne webinars?  Check our webinar library.

Available On Demand

John Welch

John Welch

Senior Vice President of Product Engineering, SentryOne

John leads the development of a suite of data and BI products that make developing, testing, managing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community and is an SSAS Maestro. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), SQLBits, and others. He has also contributed to multiple books on SQL Server and business intelligence.

Sandy Winarko

Sandy Winarko


Sandy Winarkois a seasoned Product Manager with extensive experience in the US, Europe, and Asia, combining commercial/technical responsibilities in principal/senior roles at various TMT (Technology, Media, and Telecommunications) companies, such as Microsoft/Skype/Nokia, BSkyB (British Sky Broadcasting), and C&W (Cable & Wireless).  At Microsoft, he is currently driving the efforts to modernize SSIS (SQL Server Integration Services) on premises and in the cloud as part of ADF (Azure Data Factory).

Companies with the highest demands for database performance choose SentryOne