How to use Change Tracking in practice?

[Former Member]

Who can give an example to explain, how to use Change Tracking. And what's the impact on the process if we change the default setting?

[Former Member · Accepted solution]

Hi Alfred,

As Specified in Console reference guide:

The Change Tracking table is an MDM system table with a predefined set of fields, and records that are not directly visible in either the MDM Console or the MDM Client. Each record is created automatically by MDM when the value of any field that you are tracking is changed, providing an audit log of changes within the system.

For each change, MDM records the date, the time, the user who made the change, the old value, and the new value.

There are three type of Change Tracking Settings:

• Track Adds – track new field value when a record is added

• Track Modifies – track old and new values when the field is modified

• Track Deletes – track old field value when a record is deleted

Thanks and regards,

<b>Sagar Sonje.

Mark Helpful Answers</b>

[Former Member]

Hi ,

To track chages we are to :

1. enable change tracking in the console

2. check the corresponding <repository>_z000 table in the SQL server query for the records changed

In our case, we ave followed the steps detailed in the blog, there are a few visible differences, which are probably due to SQL server version updates. However, on executing the query we do not get any output, inspite of making changes.

Are there any other parameters to be set in SQL server ?

Thanks in advance for your suggestions,

Regards,

Anita

[Former Member]

Thanks Ravi., I am going to take a look.

[Former Member]

Hi,

you can through this blog:

/people/balas.gorla/blog/2006/09/08/change-tracking-in-mdm

I hope this will help you.

Regards,

Ravi.

Please mark helpful answers.