To create a resource group, we need to log on to the Azure portal by typing the following URL in a browser: http://Portal.Azure.com.

From the resource panel, click on the + New icon and enter resource group in the search box, as shown in the following screenshot:

Clicking on the search results opens the Resource group blade. We simply need to click Create at the bottom of the screen.

As shown in the following screenshot, we'll fill the textboxes with the following properties:

• Resource group name: ADFV2Book.
• Subscription: Should be filled with the active subscription used to create the resource group.
• Resource group location: We can choose any location we want. Location is not that important for a resource group but for compliance reasons, we should use a location where all our Azure artifacts will be created.

Once we click on Create at the bottom of the...

Now, we'll create the factory. The goal of the exercise is to copy data from a SQL Server table and bring it in an Azure Blob storage.

Log in to the Azure portal (http://Portal.Azure.com). In the resource section, click the + New icon. Click on Data + Analytics and select Data Factory, as shown in the following screenshot:

The New data factory blade opens. As shown in the following screenshot, fill the textboxes with the following values:

• Name: The name of the factory might be later registered as DNS. It should be unique if at all possible. To make it unique, we might use our initials in front of it. There are naming rules for data factories, which can be found at https://docs.microsoft.com/en-us/azure/data-factory/naming-rules.
• Subscription: Should be filled with the active subscription used to create the data factory.
• Resource Group: We're...

At the heart of the Azure ecosystem is the blob storage service. This service, as its name indicates, provides file storage. There are different types of blobs, as not all of them are created equally. The next few sections will describe the different blobs and their usage.

Blob containers are the first level of blob storage. All blobs need a container as root access. It's like a folder in a standard operating system.

There are several types of blobs for different usage. The next sections briefly describe the various blob types. For more information, please see the following link: https://docs.microsoft.com/en-us/azure/storage/.

Block blobs are used by most Azure data transfers. They can store application files (CSV, ZIP, and so on), tables used by NoSQL applications, and queues used by streaming services such as Azure ML (short for Azure Machine Learning). Throughout the examples in this book, we'll use block blobs as storage for some of our data transfers.

We'll now set up a database that will be used by our factory to copy data from. The Wide World Importers sample database is available at: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0.

A BACPAC is a file that contains database structures and data, similar to a database backup. The difference is that a BACPAC is a snapshot of a database at a specific time. A database backup is much more than that: the database can be restored up to the last few seconds. Also, a database backup can be incremental—that is, contain data and structures since the last backup. A BACPAC always contains all data.

The version we're using is the standard one, as shown in the following screenshot:

We'll now upload the BACPAC to the storage that we created in the previous section:

1. Open Microsoft Azure Storage Explorer...

In this chapter, we created our factory with a pipeline that copies data from an Azure SQL database to an Azure storage account. The following chapters will dig more into the various services available in Azure as well as how we can integrate an existing SSIS solution into the factory.