Skip to Main Content
Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse
book

Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse

by Mark Beckner
December 2018
Beginner to intermediate content levelBeginner to intermediate
116 pages
2h 22m
English
De Gruyter
Content preview from Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse

Chapter 1 Copying Data to Azure SQL Using Azure Data Factory

In this chapter we’ll build out several components to illustrate how data can be copied between data sources using Azure Data Factory (ADF). The easiest way to illustrate this is by using a simple on-premise local SQL instance with data that will be copied to a cloud-based Azure SQL instance. We’ll create an ADF pipeline that uses an integration runtime component to acquire the connection with the local SQL database. A simple map will be created within the pipeline to show how the columns in the local table map to the Azure table. The full flow of this model is shown in Figure 1.1.

Figure 1.1: Components and flow of data being built in this chapter

Creating a Local SQL Instance

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

Ahmad Osama
ETL with Azure Cookbook

ETL with Azure Cookbook

Christian Cote, Matija Lah, Madina Saitakhmetova

Publisher Resources

ISBN: 9781547401291