Introduction
Since 2005, SQL Server Integration Services (SSIS) has provided many organizations with a platform for developing Extract, Transformation, and Load (ETL) solutions for on-premises data warehouses, analytical solutions and in some cases migration projects. Years of investment in understanding an organization's data, and the development efforts to create data integration pipelines, have to be considered when moving to a cloud data integration solution. Azure Data Factory provides the capability to lift and shift SSIS solutions to the cloud so that you can use them immediately.
Tip
Data Factory in Microsoft Fabric is the next generation of Azure Data Factory, with a simpler architecture, built-in AI, and new features. If you're starting a new data integration project, consider Microsoft Fabric Data Factory. Existing Azure Data Factory workloads, including Azure-SSIS IR, can continue to run in Azure Data Factory.
After completing this module, you're able to:
- Describe SQL Server Integration Services
- Explain the Azure-SSIS integration runtime
- Set up the Azure-SSIS integration runtime
- Run SSIS package in Azure
- Migrate SSIS packages to Azure
Prerequisite
Before taking this module, it's recommended that the student is able to:
- Log in to the Azure portal
- Explain and create resource groups
- Describe Azure Data Factory and its core components
- Ingest data into Azure Data Factory using the Copy Activity