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

Unlock powerful ETL capabilities with Azure Data Factory (ADF) and SQL Server Integration Services (SSIS)! This session dives into a comprehensive PaaS solution leveraging Azure SQL Database or Azure SQL Managed Instance (MI) alongside SSIS within Azure Data Factory to streamline your data integration workflows.

Key takeaways include:

• Lift and Shift ETL Workflows: Learn how to seamlessly migrate existing SSIS packages to the cloud with minimal disruption.
• Modernize ETL Processes: Discover how to evolve your ETL strategies using the power of Azure Data Factory.
• Extend ETL Functionality: Integrate custom, open-source, and third-party components into your SSIS packages to meet your specific data processing needs.

Here's a detailed look at what we'll cover:

• Provisioning Azure-SSIS Integration Runtime (IR): We'll guide you through setting up dedicated ADF servers for running SSIS, with the Azure-SSIS Integration Runtime. This includes configuring the SSIS catalog (SSISDB) hosted on Azure SQL DB/MI.
• On-Premises Data Access: Learn to securely connect to your on-premises data sources using Windows authentication and leveraging virtual network injection or a self-hosted IR as a proxy.
• Familiar Development Tools: Utilize your existing skills with SSDT/SSMS to design, test, deploy, and execute your SSIS packages directly in the cloud, replicating your on-premises development experience.
• Modern ETL with ADF Pipelines: Transform your ETL workflows by invoking and scheduling SSIS package executions as first-class activities within ADF pipelines.
• Pipeline Orchestration: Combine and chain SSIS packages with other ADF activities to create robust and automated data pipelines.
• Event-Driven Automation: Trigger pipeline runs based on events, enabling real-time data processing.
• Dynamic IR Management: Automate the (de)provisioning of the SSIS IR, ensuring optimal resource utilization and cost efficiency.

This session provides a complete overview of building a scalable, reliable, and cost-effective ETL solution using Azure SQL Database, Azure SQL Managed Instance, SSIS, and Azure Data Factory. It's perfect for data engineers and ETL developers looking to modernize their data integration strategies in the cloud.