You're reading from ETL with Azure Cookbook Practical recipes for building modern ETL solutions to load and transform data from any source

Product type Paperback

Published in Sep 2020

Publisher Packt

ISBN-13 9781800203310

Length 446 pages

Edition 1st Edition

Languages

Python

Tools

Azure

Concepts

Databases

Authors (3):

Christian Cote

Matija Lah

Madina Saitakhmetova

View More author details

Table of Contents (12) Chapters

Preface

1. Chapter 1: Getting Started with Azure and SSIS 2019

2. Chapter 2: Introducing ETL FREE CHAPTER

3. Chapter 3: Creating and Using SQL Server 2019 Big Data Clusters

4. Chapter 4: Azure Data Integration

5. Chapter 5: Extending SSIS with Custom Tasks and Transformations

6. Chapter 6: Azure Data Factory

7. Chapter 7: Azure Databricks

8. Chapter 8: SSIS Migration Strategies

9. Chapter 9: Profiling data in Azure

10. Chapter 10: Manage SSIS and Azure Data Factory with Biml

11. Other Books You May Enjoy

Leave a review - let other readers know what you think

Chapter 1: Getting Started with Azure and SSIS 2019

In this cookbook, we are going to cover Extract, Transform, Load (ETL) development with Microsoft Azure. We will start with Microsoft SQL Server 2019 Integration Services (SSIS) and then gradually move on to data management capabilities in Azure. Throughout this cookbook we will use hands-on examples, which will not only provide you with genuine first-hand experience in SSIS development but also demonstrate how to design a working ETL solution or a module that could be built into an ETL solution.

Let's start by establishing your development environment. We are going to guide you through the installation of a new SQL Server instance, including all the components needed for on-premises as well as cloud-based SSIS solution development. You are also going to install the tools used in administering and maintaining SQL Server instances – either on-premises or in the cloud. You are also going to install the tools used in developing, testing, and deploying your SSIS solutions. You will finish this chapter by creating an Azure subscription, which will allow your on-premises development environment to extend into the cloud.

This chapter covers the following recipes that will help you get started with SSIS development on-premises as well as in the cloud: