topic Re: [resolved] Transform Google sheets into CSV and postgreSQL in Talend Studio

[resolved] Transform Google sheets into CSV and postgreSQL

Anonymous — Mon, 05 Dec 2016 16:40:10 GMT

Hi,
I have a situation where I humbly request your assistance. I have Google sheets data which I am converting into csv files---this works great. Now I need to tell Talend that besides converting Google sheets data into csv file, also make a table in postgreSQL. How can I do this? Is it possible with Talend? Please provide insights.

Re: [resolved] Transform Google sheets into CSV and postgreSQL

Anonymous — Mon, 12 Dec 2016 07:14:01 GMT

Hi
I guess you have read the related topic, you can use tFileFetch component to download the CSV file, and then use tFileInputDelimited to read the file and load them to PostgreSQL.

Regards
Shong

Re: [resolved] Transform Google sheets into CSV and postgreSQL

Anonymous — Mon, 12 Dec 2016 15:27:06 GMT

Thanks Shong!!!