Change Tracking in MDM

[Former Member]

Hi,

Is there any way in MDM of setting a threshold time after which records in Change Tracking Database get deleted automatically.

Like if i want to set that data older than 1 month should get deleted.

Regards,

Kshitij

[former_member189669]

Hi Kshitij,

MDM provides an option to activate change tracking ONLY(Change tracking table).

Control over Tracked changes for records in a repository can be done only at DB level.

DBMS specific archiving tools need to be used as MDM doesnt provide this option.

You can set up cleaning A2i_CM_History table using TRUNCATE command in a simple query where EventTime = Current Date-30days.

Set up a stored procedure to run the query > schedule stored procedure to run it at a particular time.

Also pls refer to SAP note 1343132 - Archiving MDM change tracking A2I_CM_HISTORY best practices.

Regards,

Vinay M.S

Edited by: Vinay Simha on Nov 1, 2009 9:56 AM

Edited by: Vinay Simha on Nov 1, 2009 10:00 AM