12 Integrating Data Factory with SQL Database

This chapter covers

  • Importing data into Azure SQL Database with external data sources

  • Configuring cross-database queries in Azure SQL Database

  • Importing file data into Azure SQL Database with Azure Data Factory

In the last chapter, you learned about creating and configuring Azure SQL Database (SQLDB). Relational databases like SQLDB provide an accessible endpoint for queries into both the Serving layer and Speed layer of a Lambda architecture analytics system. In chapter 6, you saw the real-time part of the workflow, with Stream Analytics calculations that flowed into SQLDB. Chapter 10 demonstrated using Azure Data Factory (ADF) to automate the batch-processing part using Azure Data Lake ...

Get Azure Storage, Streaming, and Batch Analytics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.