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