# How to transfer SFTP zip files to local folder

**URL:** <https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128>\
**Category:** CloverDX Platform\
**Created:** [October 22, 2012, 12:00am UTC](https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128 "2012-10-22T00:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rkota](https://avatars.discourse-cdn.com/v4/letter/r/a8b319/32.png) [@rkota](https://forum.cloverdx.com/u/rkota)\
**Post date:** [October 22, 2012, 12:00am UTC](https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128/1 "2012-10-22T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [October 23, 2012, 8:40am UTC](https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128/2 "2012-10-23T08:40:17Z")

</div>

Hi rkota,

I would recommend you commercial version of [http://www.cloveretl.com/resources/releases/3-3-0-M3](http://www.cloveretl.com/resources/releases/3-3-0-M3) which brings File Operation components. [http://doc.cloveretl.com/documentation/ … files.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/copyfiles.html) would solve your issue.

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

---

<div class="post-metadata">

**Author:** ![sbullen](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@sbullen](https://forum.cloverdx.com/u/sbullen)\
**Post date:** [February 6, 2013, 4:39pm UTC](https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128/3 "2013-02-06T16:39:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![imriskal](https://avatars.discourse-cdn.com/v4/letter/i/b38774/32.png) [@imriskal](https://forum.cloverdx.com/u/imriskal)\
**Post date:** [February 14, 2013, 12:20pm UTC](https://forum.cloverdx.com/t/how-to-transfer-sftp-zip-files-to-local-folder/1128/4 "2013-02-14T12:20:33Z")

</div>

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](http://stackoverflow.com/questions/3477471/whats-a-decent-sftp-command-line-client-for-windows)

Best regards,
