Chapter 11: Implementing ETL Using Azure Data Factory
In Section 1 of this book, you learned how to design and implement operational databases using Azure SQL Database and Azure Cosmos DB. Operational databases are databases where new data comes into existence; for instance, data pertaining to new customers and data regarding new orders is added to the database.
In Section 2 of this book, you learned how to design and implement analytical databases using Azure SQL Database, Azure Synapse Analytics, and an Azure Storage account. We used the data from our operational databases, supplemented with external data, log data, and streaming data, to populate these analytical databases to perform analytics on the data.
This section introduces Azure Data Factory, the tool to use when you need to enter data into analytical databases. The process of moving data from operational databases to analytical databases is called the Extract, Transform, Load (ETL) process. Azure Data Factory is the...
