- Course
- Cloud
- Data
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 | 1m 36s
- Why Migrate SSIS Packages to Data Factory? | 3m 23s
- Does Azure Data Factory Replace SSIS? | 3m 7s
- Prerequisites | 34s
- What Is Azure Data Factory? | 3m 4s
- How Azure Data Factory Works? | 1m 11s
- Workflow Changes for a Developer | 50s
- SSIS Migration Levels | 1m 18s
- Demo: Setting up Azure Data Factory | 5m 24s
- Integration Runtime | 3m 52s
- Demo: Creating Integration Runtime | 6m 32s
- Demo: Deploying SSIS Packages to Azure SQL Database | 2m 20s
- Azure SQL Database vs. Managed Instance | 2m 23s
- Common Concerns for Migrating to Data Factory | 1m 50s
- Summary | 58s