topic Re: Insert/Update row by row in multiple My SQL tables in Talend Studio

Insert/Update row by row in multiple My SQL tables

Anonymous — Sat, 16 Nov 2024 08:08:52 GMT

I have the following problem:

I have 2 mysql databases,

Database1
Tables:
1.status_Table
2.product
3.product_attributes
4.manufacturer
5.prod_category
6.distributor

Database2
Tables:
1.product
2.product_attributes
3.manufacturer
4.prod_category
5.distributor

There are some ids in status_Table. All other tables in Database1 contains records against each id in status_Table.
I need to Insert/Update row by row in each mysql table in Database2 from corresponding table in Database1 against each id .
That is,
Database1.product ------> Database2.product
Database1.product_attributes ------> Database2.product_attributes
Database1.manufacturer ------> Database2.manufacturer
Database1.prod_category ------> Database2.prod_category
Database1.distributor ------> Database2.distributor

And at the end of every single row i want to change the status of each id in Database1.status_Table.
How can I do this?

Re: Insert/Update row by row in multiple My SQL tables

vapukov — Wed, 06 Jun 2018 10:32:56 GMT

depend from how many rows possible different "best ways"

as variant:

read status_Table
iterate over all id's - store id to variable,
fetch one record from table (use id in WHERE conditions) - do this for all tables in Your list
INSERT/UPDATE in tMySQLOutput component
update status_Table for selected ID for example tMySQLRow

Re: Insert/Update row by row in multiple My SQL tables

Anonymous — Wed, 06 Jun 2018 11:17:03 GMT

What are the components used for this. Can u please explain this workflow with talend components using any example??

Re: Insert/Update row by row in multiple My SQL tables

vapukov — Wed, 06 Jun 2018 11:40:37 GMT

sample flow:

how work each component - please check Talend docs, it pretty good

Re: Insert/Update row by row in multiple My SQL tables

Anonymous — Wed, 06 Jun 2018 12:22:48 GMT

The tDB components need external jar files. So is there any solution using other components??

Re: Insert/Update row by row in multiple My SQL tables

vapukov — Wed, 06 Jun 2018 12:35:57 GMT

between DBInput and DB2Input little difference (like between Mazda and Hammer)
https://en.wikipedia.org/wiki/IBM_Db2

You need tMySQL* (Input/Output/Row)

it just in Talend Studio 7 they make it universal DBInput with additional settings