Change Tracking Option in Console

[Former Member]

I have enabled change tracking option in console at Table and field level for add/modify/delete.

Please let me know where I can see the logs for the changes accomplished.

[former_member205403 · Accepted solution]

Hi Sudha,

the easiest and best way to check change logs is the CHANGE TRACKER APPLICATION.

Once you set change tracking ON in MDM console, configure change tracker application by following steps mentioned in below link

http://help.sap.com/saphelp_nwmdm71/helpdata/en/49/a42bce34de1b93e10000000a42189b/frameset.htm

You can also check in database table A2i_CM_History, but this is not recommended way...

I think below thread will also interest you, which is on same topic i.e. how to track changes in MDM.

Hope this helps.

Best Regards,

Shiv

[Former Member]

Hi Sudha

You can only change the settings for the Change Tracking table for an MDM repository that is mounted and unloaded

A separate user interface is available for viewing change information tracked on this table. This interface can be viewed as a stand-alone application, as an iView, or it can be integrated into the MDM Data Manager

follow the below steps to configure change tracker

1.Create a data source for the relevant JDBC connector, (MS SQL, Oracle, Max DB, or DB2).

2.Import the Change Tracker application .sca file using the Software Deployment Manager (SDM):

3.Define the schema configuration file (only if necessary - for example, if the schema is different from the default structure).

4.Set up the MDMChange Tracker application depending on the use mode.

The MDM Change Tracker application can be run in three modes:

1.Standalone Mode

2.Incorporated into the Web tab of the MDM Data Manager

3.Use it as an iView in conjunction with standard MDMiViews on a portal page

Note: Enabling change tracking can dramatically degrade MDM system performance when records are modified.

[Former Member]

Hi Sudha,

See as per your console settings, everything happened at Database Level table A2i_CM_History so its up to you how do you want to see these record changes either through some Portal application for end user or at database level or through some other UI.

[How to Configure SAP MDM Change Tracker for Any Repository to bring this changes on Webdynpro Application for end user|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/807861ac-f941-2c10-8f8d-c57f9d421b99?quicklink=index&overridelayout=true]

Please refer this blog if you want to see these changes at the database level just for complete understanding.

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

See figure 5 of this blog before data changes in Data Manager and the same data record in figure 9 of database.

Now when he make changes to record in figure 10 Data manager the same gets reflected into Database figure 11.

In fig 11 , please carefully see all the columns NewValue, OldValue, EventTime, FieldName, UserName etc.

Hope you got now clear idea about change tracking in MDM

Regards,

Mandeep Saini

[Former Member]

Hi Sudha

Change tracking once enabled can be seen oonly via the change tracker view which needs to be deployed separately. Its a separate IView built in from SAP and needs to be deployed for viewing the changes, there are no separate logs.

To know more on how to deploy the change tracker view please refer to following links-

1. http://help.sap.com/saphelp_mdm550/helpdata/en/45/C7B20339EE570AE10000000A114A6B/content.htm

2. http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/807861ac-f941-2c10-8f8d-c57f9d421...

ALso refer to following thread on similar topic

Hope this helps-Ravi

[former_member182007]

you can follow

http://help.sap.com/saphelp_mdm550/helpdata/en/42/e965b4f7f23ee5e10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_mdm550/helpdata/en/45/c7b20339ee570ae10000000a114a6b/frameset.htm

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.

A separate user interface is available for viewing change information tracked on this table. This interface can view as a stand-alone application, an iView, or integrated into the MDM Data Manager (u201CConfiguring a Change Trackeru201D in the MDM 5.5 Portal Content Developmentu201D document for more information).

Hope it helps

Deep