Chapter 5: Integrating Data into Your Modern Data Warehouse
Extracting data from source systems and incorporating it into your modern data warehouse is one of the most important pieces of the foundation that you will create in relation to your analytical data estate.
The sheer number of possible different source formats can leave you scratching your head when you are confronted with the requirements of your users and how quickly they require their analyses and reports.
In this chapter, you will learn how to implement ETL/ELT (Extract, Transform, Load/Extract, Load, Transform) pipelines with Synapse pipelines or alternatively using Azure Data Factory. This depends on your choice of services and whether you are using the integrated Synapse experience or you only need a standalone integration service.
You will examine the different source connectors and learn how to orchestrate your integration jobs. The data flows in Synapse pipelines/Azure Data Factory will extend your toolset...
