MDM Trigger Behaviour

Four Stars

MDM Trigger Behaviour

Hi

 

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.

 

 

Highlighted
Six Stars

Re: MDM Trigger Behaviour

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

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now