How to transfer SFTP zip files to local folder

Task is to read files from SFPT (.7z zip) and load to another server. I want to transfer the files from SFPT to local folder so that I can unzip and load to another server. I would like to know how can we achieve this in detail.

Much appreciated.
Thanks,
RK

Hi rkota,

I would recommend you commercial version of http://www.cloveretl.com/resources/releases/3-3-0-M3 which brings File Operation components. http://doc.cloveretl.com/documentation/ … files.html would solve your issue.

For non-commercial version I would recommend to handle this via SystemExecute component and external command line tools.

Hi Jaroslav,

I am new to Clover and using the Community version. I could not find any examples illustrating how to implement System Execute to transfer files from SFTP. Do you have sample code that you can share?

Also, does System Execute support sftp utilizing public-key authentication?

Thanks,

Sebastian

Hi, Sebastian,

You can just download some SFTP tool with command line support and follow manual to it. SystemExecute is not related with SFTP in any way, it is just a way to connect CloverETL graph and command line.

Regarding your question about authentication, it also depends only on the SFTP tool you choose.

This may help: http://stackoverflow.com/questions/3477 … or-windows

Best regards,