Question

A retail company runs an on-premises SQL Server order-management system and an Azure SQL Database for its e-commerce site. The analytics team needs a near real-time consolidated view of orders in Azure Synapse Analytics with minimal impact on the source systems. New and changed rows must be captured continuously (not via nightly full loads), and the solution should require minimal custom code. Which data integration approach should you recommend?

Accepted Answer

Enable change data capture on the sources and use an Azure Data Factory mapping data flow with incremental (CDC) extraction to load Synapse

Answer

Schedule an Azure Data Factory copy pipeline that performs a full table extract every hour into Synapse

Answer

Export the databases to BACPAC files nightly and import them into a dedicated SQL pool in Synapse

Answer

Use AzCopy to replicate the underlying database files to Azure Blob Storage and query them with serverless SQL