January Meeting - Azure Data Factory CI/CD and SSIS

Welcome to the first MDPUG meetup of 2020! We will focus on Azure Data Factory, the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Join us in Teknologihuset for networking, food, and two great sessions!

Agenda:
17:00–17:30: Food, mingling and kicking off 2020, MDPUG
17:30 – 18:30 From 0 to hero. Azure data factory CI/CD experiences – Trøyel Nerbø, RAV Norge
18:30 – Small break
18:40 – 19:30 SSIS and ADF – Anna Belaia and Antonio Aballos Castillo, Avanade

ABSTRACTS:

From 0 to hero. Azure data factory CI/CD experiences
Do you want to do CI/CD using Azure Data Factory? I have. This session will cover how to do it, showcasing the do's and don'ts and experience using Terraform and Azure DevOps to deploy and successfully use Continuous Integration (CI) and Continuous Deployment (CD) using Azure Data Factory.

We will set up a development, test and production Azure Data Factory using variables and release pipelines in Azure DevOps. Fun times guaranteed!

SSIS & ADF
Azure Data Factory is offering capabilities to run SQL Server Integration Services packages (SSIS) since last year. In this session, we will review the new options, run a demo to show how to use them, and share some key points to consider when starting to use the Integration Runtime functions