Question

You are building a nightly integration that copies newly created and modified Account records from Dataverse into an external reporting database. The Account table contains several million rows, and a full extract each night is too slow and consumes excessive API capacity. You want each run to retrieve only the records that changed since the previous run, including deletions, with minimal custom code. Which Dataverse capability should you use?

Accepted Answer

Enable change tracking on the Account table and use the RetrieveEntityChanges message, persisting the returned data token between runs

Answer

Register a synchronous post-operation plug-in on Create and Update of Account that writes each change to the external database

Answer

Query Accounts each night with a FetchXML filter on the modifiedon field greater than the last run timestamp

Answer

Define an alternate key on the Account table and issue UpsertRequest calls for every record each night