Monday 4 June 2018

Change Tracking in D365

Change tracking is a feature that enables incremental export of data from Microsoft Dynamics 365 for Finance and Operations, by using Data management.
In an incremental export, only records that have changed are exported. To enable incremental export, you must enable change tracking on entities. If you don't enable change tracking on an entity, you can enable only full export each time

Go to Data management >> Data entities >> select one entity >> Options >> Change tracking




Option
How changes are tracked
Enable primary table
Changes that are made to any fields in the primary table trigger a change in entity. Changes that are made to fields in secondary tables don't trigger a change in entity.
Enable entire entity
Changes that are made to any fields in any table in the entity trigger a change in entity.
Enable Custom query
Select a set of custom fields from any tables that must trigger a change in entity.

When adding an entity for data export, you have the ability to choose incremental export(called “incremental push”) or full push.
In an incremental push, only records that have changed are exported.
In an full push, all records will export.

In order for incremental push to work, you do need to enable Change tracking in the Dynamics AX database and specify an appropriate change tracking option as described above