Migrating SSIS Packages to Azure Data Factory

Lift and shift your SSIS Packages to the cloud. In this course, you will learn the benefits of cloud migration and how to run, schedule, secure and monitor your SSIS Packages with Azure Data Factory v2.
Course info
Rating
(45)
Level
Intermediate
Updated
Mar 26, 2019
Duration
2h 6m
Table of contents
Course Overview
Getting Started with Azure Data Factory
Running SSIS Packages in Azure Data Factory
Securing data in Azure Data Factory
Scheduling SSIS Packages in Azure Data Factory
Monitoring Azure Data Factory Pipelines
What's Next?
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Mar 26, 2019
Duration
2h 6m
Description

High upfront infrastructure costs. Management Overhead. Software licensing. Sounds familiar? These age-old problems have reduced your organization's competitiveness. In this course, Migrating SSIS Packages to Azure Data Factory, you will gain functional knowledge to lift and shift SSIS Packages from On-premise SQL Server to cloud. First, you will learn about the numerous benefits of cloud migration that solve your problems. Next, you will discover different ways to run your SSIS packages in the cloud, covering a range of scenarios, along the way dealing with the security of data and packages. Then, you will use different methods of scheduling SSIS Packages and Integration runtime in Data Factory. Finally, you will explore how to monitor your Data Factory Pipelines. When you’re finished with this course, you will have the skills and the knowledge to build production-grade Data Factory pipelines that run your SSIS Packages.

About the author
About the author

Ravikiran is an independent cloud consultant and author focused on developing solutions in Microsoft Azure. His interests include everything in the cloud space, DevOps and Machine Learning with contributions in domains like Healthcare, Banking and Web Analytics. He works at the intersection of education and technology.

More from the author
Building Tabular Models in SSAS
Intermediate
2h 31m
Apr 2, 2020
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone! I am Ravikiran, and this is my Migrating SSIS Packages to Azure Data Factory course. Azure Data Factory is a fully managed service for creating data-driven workflows. With Data Factory, you can lift and shift your SSIS packages to the cloud for the much-needed scale and for your business to remain competitive. In this course, we will build Data Factory pipelines from scratch that run your SSIS packages handling data whether they are in cloud or in on-premises Datastores. Some of the major topics that we will cover include building a case for lifting and shifting SSIS packages to Data Factory, running SSIS packages in Data Factory, security of the data in cloud, scaling SSIS packages in Data Factory, and monitoring Data Factory pipelines. By the end of this course, you will have a solid foundation to build production-grade Data Factory pipelines that run your SSIS packages. But before you begin, make sure you have some familiarity with SSIS and cloud fundamentals.