MDM Trigger Behaviour

NilanJ — Fri, 16 Mar 2018 20:06:40 GMT

I'm trying to create an MDM job/trigger so that when a new record is created via the WebUI, it will automatically enrich that with the current datetime (insertdate), and the username of the person who created the record (insertby).

My current workflow has a trigger which triggers a job that starts with tMDMTriggerInput, (the exchange doc has all the information I need) grabs the key, username and current time and writes it to mdm as an update in a tMDMOutput component.

However, I cannot update the record in MDM with the datetime and username, because the trigger and job seems to occur before the record commits - so there is no record to update at runtime.

I also have a job that adds an update_date and update_by fields. This works fine, because when a person updates an already existing record in MDM, there is already a record to update and it all works fine.

So my question is, how can I enrich an insert of data to MDM via the webUI.

Re: MDM Trigger Behaviour

ashok5 — Wed, 02 May 2018 01:51:09 GMT

Hi Nilan,

MDM Trigger is very similar to oracle DB trigger, MDM Trigger will work on CURD (Create, update, Read, Delete) operations, you can enrich the data on create operation, are you getting any error in MDM logs, can you please provide your trigger setting screenshot as well as job screenshot

I hope you have provided the entity as "Update" and Trigger xpath expression value as "CREATE" (Case sensitive) and the corresponding condition.

Please refer to the attached screenshot

Thanks

Ashok

MDM_Trigger.JPG

topic Re: MDM Trigger Behaviour in Talend Data Catalog

MDM Trigger Behaviour

Re: MDM Trigger Behaviour