topic Update or insert rows in mysqloutput in Talend Studio

Update or insert rows in mysqloutput

BNP — Sat, 16 Nov 2024 02:43:27 GMT

Hi,

I'm new to this talend. I'm using torachleinput component and tlogrow, tmysqloutput component. whatever update or insert done in the oracle database. Those data transfer into the MySQL database. I have update some data in oracle database and also inserted some new rows. But when I'm selected insert or update in action on data, in MySQL. it's not updated and it's inserted as a new record. it's not update exiting record. Can help this

Thanks in advance.

Re: Update or insert rows in mysqloutput

manodwhb — Fri, 10 Apr 2020 14:59:49 GMT

do you have key column I'm tmysqloutput component in the schema otherwise it will always inserts.

Re: Update or insert rows in mysqloutput

BNP — Fri, 10 Apr 2020 15:59:36 GMT

Hi manodwhb,

thanks for your replaying

Yes, I have selected it. otherwise its giving error. while updating the records

Capture.GIF

Re: Update or insert rows in mysqloutput

manodwhb — Fri, 10 Apr 2020 16:32:48 GMT

Do you have primarykey on same key column indatabase side too?

Re: Update or insert rows in mysqloutput

BNP — Fri, 10 Apr 2020 17:27:08 GMT

Yes.

Re: Update or insert rows in mysqloutput

manodwhb — Fri, 10 Apr 2020 17:42:01 GMT

Can you share your tmysqloutput schema screenshot ?