topic Re: Getting Files Via FTPconnection and apload the data in a PostgreSql BDD in Talend Studio

Getting Files Via FTPconnection and apload the data in a PostgreSql BDD

Anonymous — Fri, 08 Dec 2017 09:52:40 GMT

Hello everybody,
I'm just starting with Talend OPS, and I wanna get a file from the server ( Via the FTPConnection), make some transformations and after that apload the data in a Pstgresql table.
I use the FTPconnection and the tFTPget to recover the file I want to, but I don't know wich component use after this step in order to get just the rows I want to and put them in my table.
Any one to help me please.
Thank you !

Re: Getting Files Via FTPconnection and apload the data in a PostgreSql BDD

Anonymous — Mon, 11 Dec 2017 02:59:06 GMT

Hello,

tFileInputXXX component will get the rows you want to and load them in your table.

The work flow looks like:tFTPConnection-->tFTPGet-->tFileInputXXX-->tPostgresqlOutput

Best regards

Sabrina

Re: Getting Files Via FTPconnection and apload the data in a PostgreSql BDD

Anonymous — Mon, 11 Dec 2017 13:45:27 GMT

Hello,

thank you for your answer.
but I don't find which one of the TfileInputXXX I have to use.
on the server, the file type is .csv with "|" as a separator. I tried tu use de TfileInputRaw, but I'm getting just an object with only one line and I can't use the Tmap in order to choose the column to put in my table.

Can you help me please?

Thank you!

Re: Getting Files Via FTPconnection and apload the data in a PostgreSql BDD

Anonymous — Tue, 12 Dec 2017 12:44:31 GMT

Hello,

I'have used the Tfileinputdelimited and it works!

Thank you

Re: Getting Files Via FTPconnection and apload the data in a PostgreSql BDD

Anonymous — Wed, 13 Dec 2017 08:56:29 GMT

Hello,

Great it works. Thanks for your feedback.

Best regards

Sabrina