topic Is it possible to update a table schema (rows) using only talend in Data Quality

Is it possible to update a table schema (rows) using only talend

MMaiza — Fri, 15 Nov 2024 22:08:31 GMT

hello !

i am new to Talend and i am currently using Tos ESB,

i am wondering if it's possible to "ALTER TABLE" in a sense if my source DB table gets a column updated in a table

how can one update the column to the destination DB table.

with a good job flow i could make it so that it updates table then updates data but i'm at a loss with the "ALTER table" part

Re: Is it possible to update a table schema (rows) using only talend

Anonymous — Thu, 02 Feb 2023 17:25:06 GMT

You can do this using the tDBRow component. Here is a post from a while ago where it talks about something very similar. It also points to a knowledge base article which goes into more detail....

https://community.talend.com/s/feed/0D73p000004kTCXCA2?language=en_US

Re: Is it possible to update a table schema (rows) using only talend

MMaiza — Fri, 03 Feb 2023 10:44:24 GMT

Thank you for sharing ! this sparked a possible solution i'll try it.