How to transfer SFTP zip files to local folder

rkota

• October 22, 2012 00:00

• Answered

Follow

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

• 

  admin

  • October 23, 2012 08:40

  0

  Comment actions Permalink

  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.
• 

  sbullen

  • February 06, 2013 16:39

  0

  Comment actions Permalink

  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
• 

  imriskal

  • February 14, 2013 12:20

  0

  Comment actions Permalink

  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,

Please sign in to leave a comment.