Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tfilefetch with ftp protocol and authentication

Hello Talend users.
I need to get a single xml file from a ftp server, i think tfilefetch fits my needs because it is not neccesary to download the file, just to get the content for later use as a lookup table (see "use cache to save the resource"). 
But i have been unable to figure out how to set host, username and password in tfilefetch component, if you choose the "http" protocol, you can set those settings, but i need to set them for the "ftp" protocol. 
Any help will be much appreciated.  
Regards
Juan
Labels (3)
5 Replies
Anonymous
Not applicable
Author

Hi,
So far, tfilefetch component is used to retrieve a file via a defined protocol(http, https, ftp, smb).
Have you tried to use component tFTPGet to retrieve your selected file from remote FTP directory and copy them to a local directory?
Best regards
Sabrina
Anonymous
Not applicable
Author

Yes, sure i can use a tFTPGet, but some features of tFileFetch seemed very attractive, ie. the ability to store the contents in a cache, and i just need to get the contents of a single file, just the content, no need to download the file. 
Anonymous
Not applicable
Author

Hi,
You can take a try on ftp protocol and set a ftp URL format.

ftp:/xxx:xxxx

Best regards
Sabrina
Anonymous
Not applicable
Author

Hello.

I finally figured out how to accomplish the task, if you use the ftp protocol with tFileFetch the URI must have the following format:

ftp://username:password@www.myserver.com/project/2012/Project.zip

 

The component is very rigid so be careful if you want to append name=value pairs separated by "&"

 

Regards.

Anonymous
Not applicable
Author

Hi jcalfucura,
Thanks for your suggestion and solution. It's really helpful.
Best regards
Sabrina