topic [resolved] export datas from Postgresql database to .csv file in Talend Studio

[resolved] export datas from Postgresql database to .csv file

Anonymous — Sat, 16 Nov 2024 12:27:16 GMT

Hi
I'm trying to export datas from a postgresql database in csv file.
first i created a metadata about my database, I checked the connection. I created a schema to get access to table . everything is Ok
second i drag and drop the table from the metadata in the job, the wizzard propose to create a TELTpostgresinput component. I create a tmap , a tFileoutputdelimeted.
when i try to link the TELTpostgresinput to tmap it fails!
I cannot link the TELTpostgresinput to another component except a teltpostgresmap whitch cannot be linked to the tFileoutputdelimeted.
what is the correct way?

Re: [resolved] export datas from Postgresql database to .csv file

Anonymous — Sat, 14 Jan 2012 02:19:03 GMT

Hi
Welcome to Talend Community!
Try to use tPostgreSqlInput component here. Then you will get the result.
The wizzard is to help you choose the components about postgresql. It's just a list without order.
Regards,
Pedro

Re: [resolved] export datas from Postgresql database to .csv file

Anonymous — Wed, 18 Jan 2012 10:15:01 GMT

thanks
I didn't find the rigth component because I forgot to enable Postgres in the palette project options.
I must be more concentrated!
regards