Question

A logistics company uses a Dataverse-based model-driven app to manage thousands of daily shipment records. The finance department needs a nightly export of aggregated shipment data into an existing Azure SQL Database for their reporting warehouse. The export must run unattended, transform the data, and handle large batches reliably without requiring users to be signed in. As the Power Platform developer, which integration approach should you recommend?

Accepted Answer

Use an Azure Synapse Link for Dataverse to continuously replicate tables, then run an Azure Data Factory pipeline on a nightly schedule to aggregate into Azure SQL

Answer

Build a scheduled Power Automate cloud flow that queries Dataverse and inserts rows into Azure SQL using the SQL Server connector

Answer

Register a Dataverse plug-in on the shipment table's Create message to write each record to Azure SQL synchronously

Answer

Create a canvas app screen with a button that finance staff click each night to trigger the export via Power Fx Patch calls to a custom connector