Azure Data Factory - Your New SSIS

This session presents Azure Data Factory (ADF) as a modern replacement for SQL Server Integration Services (SSIS), offering a scalable, cloud-native platform for building ETL/ELT pipelines. We’ll cover key ADF components including pipelines, activities, datasets, linked services, data flows, and integration runtimes. The session also addresses deployment practices, monitoring, scheduling, and cost management.

A live demo and walkthrough of a real-world pipeline—originally designed for SQL Saturday Jacksonville—will illustrate how ADF can be used to solve practical data integration challenges with minimal code.

Prerequisites

Participants should have:

1. A basic understanding of ETL/ELT concepts.
2. Familiarity with SQL Server Integration Services (SSIS) or other data integration tools.

General knowledge of Azure services and cloud-based data workflows.
Some experience with SQL and data pipelines is helpful but not required.

Session Goals
By the end of this session, attendees will:

1. Understand the core components of Azure Data Factory (ADF), including pipelines, activities, datasets, linked services, and data flows.
2. Learn how ADF compares to and improves upon SSIS in a cloud-native environment.
3. Gain insight into best practices for deployment, monitoring, scheduling, and cost management in ADF.
4. See a real-world ADF pipeline in action through a live demo, originally built for SQL Saturday Jacksonville.
5. Leave with practical knowledge to start building or migrating data integration solutions using ADF.

Sponsor

Needed