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.