How can i read a File locate on sFTP

[Latsche]

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]

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]

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

[Latsche · Accepted solution]

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]

Hello,

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

Best regards

Sabrina