MDM native services

Hi Hasain,

1. You cannot directly update eng_active in DB. It can cause data inconsistencies and corrupt MDM DB
2. You probably need to use local Keycloak account to access this from the Admin centre

What exactly do you want to achieve? In MDM there are 2 services:

• SOAP service - purge record
  • it can delete the record from MDM and all related data
  • https://docs.ataccama.com/mdm/latest/configuration/read-write-services.html#processpurgeservice
• REST API service - purge procedure
  • housekeeping procedure, which can hard delete all soft deleted records from MDM (where eng_existing = False). It means first you need to soft delete the reocrds through batch load/API call and then you can call this procedure to hard delete such records
  • https://docs.ataccama.com/mdm/latest/configuration/rest-api.html#purge 

Hi Oliver,

Thanks for looking into my query. I have around 2 Million records that needs to be purged. I’m looking for an efficient process to achieve this.

1. How do I set eng_existing=False? By building a plan with “execute SQL” tool to update eng_existing=false? or build separate load operation?
2. Will REST api purge procedure recalculate the survivorship after the delete? or SOAP service is the best suited for this

Hi Hasai,

1. You need to create a batch load operation and define source deletion strategy as Delete. Then the records will be deleted, eng_existing will be updated to False and also the master records will be recalculated based on the survovirshup rules

   1. 

       

2. When you call the Purge procedure, the records will be phisically deleted from MDM DB. There is no need to recalculate the survivorship as it was already done when the records were soft deleted in the previous step. 

Oliver