Creating Azure Data Factory

This section will introduce us to the Azure Data Factory. In this section, we will go through the most simple definition created using a Data Copy wizard. A goal of our example is to copy data from some SQL Server database tables into a CSV file stored in an Azure storage account.

As a prerequisite, we need an Azure subscription. A free subscription is enough. In the subscription, create an SQL Server database from a sample. This will create a database named AdventureWorksLT. After doing this, create an Azure storage account containing one blob storage in a folder named files. These preparation tasks are quite simple and we will not spend too much time describing how to do them. When our environment is prepared, ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.