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