Hands-On-Lab: Load Data into SQL Data Warehouse with Data Factory

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.

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.

Get weekly learning resources from SQLMaestros, right in your inbox. Subscribe to our Bulletins.