Data entities does not have ModifiedDateTime column

(3) Share

Report

Posted on by martinarul

231

/Dear Experts,

Dynamics 365 FO data entities does not have ModifiedDateTime column. Then how to handle Incremental push/change tracking from Azure Data Factory to Snowflake.

Should I add the ModifiedDateTime column manually only in all of the entities? Or can we use RowVersion CT Enabled /Change tracking column that is available in entities?

Suggestion will be much appreciated.

Regards

Martin

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (0)

Martin Dráb 238,749 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If you want to add ModifiedDateTime field, you need to think about how you want to populate it. Entities often consists of several tables and if you use ModifiedDateTime of just one of them, you'll miss changes of the entity coming from other tables. I did see an implementation where a computed column was added to entities, providing the highest ModifiedDataTime of all records involved.

I don't know your exact scenario, but I would indeed consider change tracking (such as Track changes for finance and operations virtual tables in Dataverse).

Moved from Integration, Dataverse, and general topics forum to Finance | Project Operations, Human Resources, AX, GP, SL forum.

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You may consider using Change tracking for entities for non-BYOD case. Take a look at docs here: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-change-track

Was this reply helpful? Yes No
André Arnaud de Cal... 303,314 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Can you explain your exact requirement? Do you need the modifieddatetime in snowflake or do you intend to use it to recognize changes?

Have you considered the Synapse link or Fabric link? This is based on export of contents from tables with incremental changes.

Was this reply helpful? Yes No
martinarul 231 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Sorry for the late reply.

We are integrating D365FO data from Azure blob storage to Snowflake.

My concern here is how to do incremental load of data as we do not have modifieddatetime column in entities.

Example: I am pushing customer master. Instead of loading all the customers every time, I want to load only the newly created/modified customer after the initial load.

currently we are doing full load every time the job is run.

Was this reply helpful? Yes No
Diego Mancassola 671 on at

Like (0)

Report
Copy link

Link copied!

Hello, if you need the time stamp of last modification for incremental export, you can adopt a calculated column on the entity witch represent the max of modified datetime fields of all (significant) tables of entity.

But, for better understand, how data passed out from D365FO to Blob Storage? You have to push data in incremental way in this step and then push to snowflake? If true, how this step is done?

As suggested you can evaluate the Synapse o Fabric, these support natively the incremental push of data.

Was this reply helpful? Yes No