Load Data into SQL Data Warehouse with Data Factory

Home/Azure SQL Data Warehouse/Load Data into SQL Data Warehouse with Data Factory

Load Data into SQL Data Warehouse with Data Factory

$15.00 $4.00

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

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

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.