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

 

 

1 REPLY
Moderator

Re: Talend MDM Portal Auto-Increment & DB Identity

Hello,


nctalend wrote:

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.

 

 


Do you want to sync up your data when insert data from Web UI and DB? Here is online document about:TalendHelpCenter:Managing the values of auto increments in the data container browser

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.