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.
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
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
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
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
I hope this blog will be useful for real time SAP MDM Change Tracking implementation.