Four Stars

Talend MDM Portal Auto-Increment & DB Identity

Hi - 

 

I have a scenario wherein users can enter data into a table through the Talend MDM Portal or directly into the Table using some Talend Job. The table has a key column which is set to type 'Auto-Increment' in MDM Datamodel and we also need to have the ability to have the key incremented in DB if data is inserted through some other process.

 

Question : Is there a way to achieve this in Talend and letting it know to sycn up the Keys from Portal to the ones on the DB? Since we have noticed that if we insert directly into DB them Talend MDM Portal doesnt check the ID's and it is incrementing from the point when the last record was entered via the portal.

 

Eg: 

Entries made via Talend MDM Portal:

id  | Name

-----------

1 | w

2 | x

 

On Entry 'y' made manually into the table

id | Name

----------

1 | w

2 | x

3 | y

 

Making another entry for 'z' after above via portal

 

Expected Behaviour:

 

id | Name

----------

1 | w

2 | x

3 | y

4 | z

 

Seen Behaviour (Talend is updating the entry for 'y' that was made manually with entry that we do for z instead of inserting another record with a id of 4)

 

id | Name

----------

1 | w

2 | x

3 | z

 

 

  • MDM