Talend MDM Portal Auto-Increment & DB Identity

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

 

 

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.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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