Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Hands-On Data Warehousing with Azure Data Factory

You're reading from  Hands-On Data Warehousing with Azure Data Factory

Product type Book
Published in May 2018
Publisher Packt
ISBN-13 9781789137620
Pages 284 pages
Edition 1st Edition
Languages
Concepts
Authors (3):
Christian Cote Christian Cote
Profile icon Christian Cote
Michelle Gutzait Michelle Gutzait
Profile icon Michelle Gutzait
Giuseppe Ciaburro Giuseppe Ciaburro
Profile icon Giuseppe Ciaburro
View More author details

Prepare the data to ingest


Now that we've created our cluster and folder, we must prepare some data to work with. For this book, we're using the data warehouse data available in the on-premise SQL database we created in the first chapters. This will allow us to see another integration runtime: self-hosted. We'll copy the data in the Azure storage account created previously in this chapter.

Setting up the folder in the Azure storage account

Going back to the Azure portal, we'll create a blob container and call it sales-data, as shown in the following screenshot:

Enter a valid name: sales-data. Click on OK when done. This creates the container in the adfv2book blob storage account, as shown in this screenshot:

Now that the container is ready, let's go back to the factory to prepare the self-hosted runtime.

Self-hosted integration runtime

A self-hosted integration runtime is necessary when we want to access data in the on-premise Windows machine from ADF. This is a secure tunnel that allows ADF to...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}