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

Length: 116 pages
Edition: 1
Language: English
Publisher: De|G Press
Publication Date: 2018-12-17
ISBN-10: 1547417358
ISBN-13: 9781547417353
Sales Rank: #1568435 (See Top 100 Books)

With constantly expanding options such as Azure Data Lake Server (ADLS) and Azure SQL Data Warehouse (ADW), how can developers learn the process and components required to successfully move this data? Quick Start Guide to Azure Data Factory, Azure Data Lake Server, and Azure Data Warehouse teaches you the basics of moving data between Azure SQL solutions using Azure Data Factory. Discover how to build and deploy each of the components needed to integrate data in the cloud with local SQL databases. Mark Beckner’s step by step instructions on how to build each component, how to test processes and debug, and how to track and audit the movement of data, will help you to build your own solutions instantly and efficiently. This book includes information on configuration, development, and administration of a fully functional solution and outlines all of the components required for moving data from a local SQL instance through to a fully functional data warehouse with facts and dimensions.

Cover
Title Page
Copyright
Contents
Chapter 1: Copying Data to Azure SQL Using Azure Data Factory
    Creating a Local SQL Instance
    Creating an Azure SQL Database
    Building a Basic Azure Data Factory Pipeline
    Monitoring and Alerts
    Summary
Chapter 2: Azure Data Lake Server and ADF Integration
    Creating an Azure Data Lake Storage Resource
    Using Git for Code Repository
    Building a Simple ADF Pipeline to Load ADLS
    Combining into a Single ADF Pipeline
    Data Lake Analytics
    Summary
Chapter 3: Azure Data Warehouse and Data Integration using ADF or External Tables
    Creating an ADW Instance
    ADW Performance and Pricing
    Connecting to Your Data Warehouse
    Modeling a Very Simple Data Warehouse
    Load Data Using ADF
    Using External Tables
    Summary
Index