topic Re: [resolved] Update a table in Talend? in Talend Studio

[resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 15:20:42 GMT

Hi,
I have six values in Excel that need to be updated at the database level which I'm unable to do in Excel. I can update those values in SQL but since I need to automate the process in Talend ETL; I need to be able to do at the ETL level. Is it possible to update those six values of a column at the Talend ETL level? Any help/assistance will be greatly appreciated.
Thanks,

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 16:50:41 GMT

Hi
Yes, this is possible with a ETL process in Talend, a simple job looks like:
tFileInputExcel--main--tMysqlOutput
tFileinputExcel: read the value from excel file
tMysqlOutput: update the value to database.
Regards
Shong

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 16:53:59 GMT

Hi Shong,
Thanks for responding. How to do I tell Talend which six values I need to update. I looked into the link but it wasn't fruition.
https://help.talend.com/search/all?query=Updating+data+in+a+database+table&content-lang=en.

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 17:02:55 GMT

Hi
For update, there must exist key column, the key column must be set on the schema of database output component. So, how the six values exist in excel file? and how do you update those value in SQL?

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 17:07:47 GMT

The six values are in Excel and I want Talend to update the table in SQL. I have already inserted the table in SQL now I want to update the table in SQL.
In Excel How I want in SQL.
440 Elwood CT 440 Elwood Ct
9720 Blanco dr 9720 Blanco Dr
etc.........
Thanks for your assistance thus far Shong.

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 17:12:03 GMT

any other columns exist in the same table?

Re: [resolved] Update a table in Talend?

Anonymous — Mon, 19 Sep 2016 17:17:13 GMT

There are about 20 columns in the Excel table but the Address is the only column that needs to have the six values updated. I also have Primary key column as well. I know I can use update syntax in SQL but when I automate the ETL process this will not be an option. That is the reason I want to do take care of this at the ETL level rather than DB level because ETL will automate the update on it's own.

Re: [resolved] Update a table in Talend?

Anonymous — Tue, 20 Sep 2016 02:13:08 GMT

Hi
If the file also has primary key column, read the primary key column and address column from the file, the primary key will be set as key column on the schema, only address column will be updated, once the job is done, schedule the job to run automatically.

Re: [resolved] Update a table in Talend?

Anonymous — Tue, 20 Sep 2016 17:17:55 GMT

Hi Shong,
It turns out my table since the source is Excel doesn't have a primary key. I tried to look for it but the table doesn't have a primary key in Excel. Is there any other way I can tell Talend to change the addresses of those six rows.
Any help provided will be greatly appreciated.
Thanks