Chapter 2 Azure Data Lake Server and ADF Integration

Having explored the basic approach to copying data to an Azure SQL instance using an ADF pipeline in the previous chapter, we’ll now expand our data storage options by working with Azure Data Lake Server (ADLS) storage. With ADLS, just about any type of data can be uploaded, such as spreadsheets, CSV files, database dumps, and other formats. In this chapter, we’ll look at uploading CSV and database extracts containing simple sales information to ADLS. This sales information will be related to the customer data that was used in the previous chapter. For example, the CSV file will contain the customer ID that can be related to the record in the Azure SQL database. This relationship will be made ...

Get Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.