topic How can i read a File locate on sFTP in Talend Studio

How can i read a File locate on sFTP

Latsche — Tue, 28 Jun 2022 09:19:32 GMT

Hi,

how could i read a File locate on a sFTP-Server?

I do not want to download the File with tFTPGet, because there could be other files. I want directly load the Data in the File to Database.

How do i have to configure the tFileInputDelimited do solve this? Is There another Component to reach the solution?

The Error.png shows the Error. Its says, that the File does not found. The Error Message comes from tFileInputDelimited_1.

Pictures attached.

Kind Regards

gjeremy1617088143 — Tue, 28 Jun 2022 09:24:03 GMT

hi @Yannick Berthelsen , you can take a look at tFileFetch Component :

https://help.talend.com/r/en-US/7.3/internet/tfilefetch

Send me love and kudos

Latsche — Tue, 28 Jun 2022 11:05:37 GMT

Thank you for the fast Answer. Im using sFTP, so it didnt work. Sry my bad.

Latsche — Tue, 28 Jun 2022 12:53:52 GMT

Solved!

This is the Solution. The Solution is attached.

The Java Code is documented here:

https://stackoverflow.com/questions/14617/how-to-retrieve-a-file-from-a-server-via-sftp

https://stackoverflow.com/questions/14223239/jsch-certificate-based-authentication-and-login-auth-cancel

Anonymous — Wed, 29 Jun 2022 02:50:09 GMT

Hello,

Great it is solved and thanks for sharing the solution with us on Community.

Best regards

Sabrina