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.

Subscribe to Download

File Size1.49 MB
Create DateMay 15, 2017
Last UpdatedMay 25, 2017
Transform Data in Azure Data Factory using Visual Studio - Hive Activity
Deploying Predictive Model as Web Service with Azure ML Studio