Load Data into SQL Data Warehouse with Data Factory

Description

Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. In this lab we will load data from On-Premises SQL Server database to Azure Data Warehouse using Azure Data Factory in Azure portal. Data Management Gateway will also be used to associate with data movement from On-Premises SQL server to Azure Data Warehouse. In the first exercise, we will learn to create Azure SQL Server, SQL Data Warehouse, Resource Group and Azure Storage account. In the second exercise, we will learn to create On-Premises SQL Server Source for Azure Data Factory. In the third exercise, we will learn to create Azure SQL Data Warehouse destination for Azure Data Factory.

Exercise 1: Create Azure SQL Server, SQL Data Warehouse, Resource Group and Azure Storage account
Exercise 2: Create On-Premises SQL Server Source for Azure Data Factory
Exercise 3: Create Azure SQL Data Warehouse destination for Azure Data Factory