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.

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