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.
What you'll learn
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.
Table of contents
- Introduction 2m
- Why Migrate SSIS Packages to Data Factory? 3m
- Does Azure Data Factory Replace SSIS? 3m
- Prerequisites 1m
- What Is Azure Data Factory? 3m
- How Azure Data Factory Works? 1m
- Workflow Changes for a Developer 1m
- SSIS Migration Levels 1m
- Demo: Setting up Azure Data Factory 5m
- Integration Runtime 4m
- Demo: Creating Integration Runtime 7m
- Demo: Deploying SSIS Packages to Azure SQL Database 2m
- Azure SQL Database vs. Managed Instance 2m
- Common Concerns for Migrating to Data Factory 2m
- Summary 1m
- Introduction 2m
- Demo: Run SSIS Packages with Stored Procedure Activity 4m
- Demo: Execute SSIS Package Activity 2m
- Demo: Customize Azure SSIS Integration Runtime 5m
- Demo: Using Parameters in Data Factory 4m
- Demo: Using System Variables in Data Factory 1m
- Executing Packages with On-premise Data 3m
- Demo: Execute Packages with On-premise Data 8m
- Demo: Override SSIS Package Properties 1m
- Summary 1m
- Introduction 1m
- Triggers in Data Factory 1m
- Demo: Schedule trigger 4m
- Demo: Event based trigger 4m
- Schedule Trigger vs. Tumbling Window Trigger 4m
- Demo: Tumbling Window Trigger 4m
- Demo: Schedule Packages in SSMS 2m
- Demo: Web Activity to Schedule Integration Runtime 4m
- Demo: Azure Automation to Schedule Integration Runtime 5m
- Summary 1m
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 is very passionate about the latest and futuristic technologies and constantly updates himself with the current technology trends. He works at the intersection of education and technology. In spare time, he likes going on long road tr... more