Bring Your Own Database(BYOD) in D365FO - Enabling Change Tracking

Hi, 

In my previous post, I demoed the process of exporting the data through full push mode and incremental push mode using BYOD from D365FO. In this post, will demonstrate the export of data with the help of advanced feature namely Change Tracking. Change Tracking is a feature helps us to push only the modified data from the tables that are part of the chosen entity. We have three options to utilize this feature namely Enable Primary table, Enable Entire entity and Enable custom query and here I will export the data from vendor group entity using the first option.

Step 1: Traverse to the entity publish page(Path: Data management workspace > Configure entity export to database > Publish button) and select Vendor groups entity. Select Change Tracking on the toolbar and select Enable Primary table option(as shown below).

Step 2: On selecting this option, we can examine the Change tracking field for vendor groups entity changed to Primary Table.

Step 3: Now tracking is enabled on the primary table i.e Vendor group. So, will update the description field value of vendor group 60.

Before update: Description field value is "Added vendor"(colored in red).

After update: Description field value is updated to "Added vendor updated"(colored in red).

Step 4: Will trigger the data project that will export the vendor group data through BYOD from D365FO.The expected behavior is to process only one record that is been updated and execution summary confirms the same.  

Step 5: Now we need to confirm that the updated record is exported. So, queried staging table in the target database and description value of vendor group 60 is updated to "Added vendor updated". 

Step 6: Change tracking can also be disabled on the desired entity if we feel we no longer need change tracking. Under change tracking select Disable Change Tracking option to disable it. I have selected vendor groups entity to disable the tracking.

Step 7: Once we disable change tracking then we get an info message stating "Change tracking has been disabled successfully for the entity: Vendor groups".

Thus, we enabled change tracking, tracked the change and disabled it after usage.

Regards,

Chaitanya Golla