topic Re: update data base with auto increment key in Talend Studio

update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 13:50:26 GMT

hello guys

iwant to update table with auto increment key when i chose insert or update i have error you must have a key

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 14:28:22 GMT

Hi,with auto increment for insert you don't need a primary key, but for update you need the primary key.

also it's better to separate insert and update.

Send me love and kudos

Re: update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 14:45:39 GMT

thank you for your answer but how i can update table with primary key auto increment in data base ???

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 15:05:05 GMT

for update you have to know the key value before the update, without it you can't update with tDBoutput.

Coul you be more precise on your scenario ?

Re: update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 15:09:19 GMT

ido migration data from oracle to postgrsql and in postgresql i have id auto increment for the table and i havn't another key, i want to update with this key auto increment but i didnt found him in talend

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 16:47:40 GMT

Ok let me understand,does oracle table have a specific primary key wich is the same in postgre or can you identify fields wich can make a row unique?

Re: update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 16:56:16 GMT

no i havnt another row unique

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 17:39:59 GMT

Ok let try in an other way.

if both tables were in postgre with the fields they already have could you achieve this and how?

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 17:41:38 GMT

Also maybe you could post the structure of postgre table and oracle Table, it could really helps

Re: update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 17:48:10 GMT

the bdd they havnt same structure i extract data in csv file after that i load them in postgresql. ican update with in postgresql with primary key auto increment but i want to do this with talend.

Re: update data base with auto increment key

gjeremy1617088143 — Fri, 15 Oct 2021 18:07:05 GMT

Ok so if you have the primary key on both you could set it on the output schema

And you use insert or update in the tdboutput. Maybe you have to desactivate auto increment in postgre table before if you want to preserve the id of oracle table for The insert. You could execute raw sql in tDBrow component

Re: update data base with auto increment key

AYAHIAOUI1629282039 — Fri, 15 Oct 2021 18:12:16 GMT

no i didnt import oracle id