MDM Trigger Behaviour

Highlighted
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.

 

 

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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

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