Talend MDM Portal Auto-Increment & DB Identity

Anonymous — Sat, 16 Nov 2024 09:17:23 GMT

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

Re: Talend MDM Portal Auto-Increment & DB Identity

Anonymous — Tue, 26 Sep 2017 08:06:34 GMT

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

topic Re: Talend MDM Portal Auto-Increment & DB Identity in Talend Data Catalog

Talend MDM Portal Auto-Increment & DB Identity

Re: Talend MDM Portal Auto-Increment & DB Identity