Change Tracking in MDM

Description :Change Tracking is a feature in SAP MDM, Using which we can track history of table records for the repositories. There are three are options, Track Adds, is track new field value when a record added. Track Modifies, track old and new values when the field is modified. Track Deletes, tacks old-field value when a record is deleted. In addition, for each type of change you can track, the setting of the root node of the Tables and Fields hierarchy determines the default setting for new tables added to the MDM repository. Similarly, for normal tables, the setting for each table node determines the default setting for new fields added to the table. Finally, the setting for each field node determines the actual setting for the field.

This document helps you understand the Change Tracking. In addition, how to activate the change tracking? Where we can see the added/modified/deleted records?

Choose the repository, which you are going to maintain change tracking. If the repository is loaded or running, please do unload the repository, if it is loaded and running.

Figure 1
Step I>>Activate Change Tracking.

Navigate the Selected repository,
(your repository)–>Admin–>Change Tracking.
Click on Change Tracking, you will get Change Tracking Setting screen. Then choose the level of tracking root node of Table and Fields. In addition, there are three type tracking. That are Track Adds>>this option tracks new field value when a record is added, Track Modifies >> this option tracks old and new values when the field is modified, and Track Deletes >> this option tracks old field value when a record is deleted

Figure 2
In our case, I have activated Track Adds and Track Modifies.

Figure 3
Then load the Repository.

Figure 4
Step II>>Data Adding or Modifying a record

1.Logon to SAP MDM Client/Data Manager as super user ( for example I have logged in as mdmg)
2.Edit the record, see the screen shot below the data which I have edited is Id is 81 and Customer is bala

Figure 5
Step III>>Logon to MS SQL Server
Start–>Programs–>Microsofr SQL Server–>Enterprise Manager,See the screen shot below for SQL Server logon.

Figure 6
You will get the SQL Server Enterprise Manager. See the screen below. Select the Database for the respective Repository (BP3_Customer_Workshop). For the each repository, there are two databases XXXX_m000 and XXXX_z000.
There are two databases CustomerWorkshop_M000 and CustomerWorkshop_Z000

Figure 7
Select the table A2i_CM_History under the CustomerWorkshop_Z000 and select query as below screen.

Figure 8
Choose/select the fields that you want execute the report/show.

You can find the record, which I (the user name ‘mdmg’) have edited at 9/6/2006 11:44:39, as seen below screen shot.

Figure 9
Then, I logged in as Admin user for SA PMDM Client. I have modified same record as seen the screen shot below

Figure 10
Again, select the table A2i_CM_History& under the CustomerWorkshop_Z000 and select query as seen screen shot below

Figure 11
You can find the record, which Admin user have modified at 9/6/2006 11:52:02.
This data you can export to any format using Data Transformation Services (DTS) tool provided by SQL Server itself. In addition, we can get report using Java API