Just to be clear, do you have the optional Cloverleaf software that performs SFTP? Otherwise the FTP protocol included with basic Cloverleaf cannot handle SFTP handshaking, at least that is my understanding.
Just to be clear, do you have the optional Cloverleaf software that performs SFTP? Otherwise the FTP protocol included with basic Cloverleaf cannot handle SFTP handshaking, at least that is my understanding.
No we don’t have optional Cloverleaf software that performs SFTP.
I’m finding out how limited my understanding of SFTP is lately, but I can tell you we do all of our SFTP transfers in batch scripts run out of cron. We use Expect to simulate user interaction necessary to wait for the password prompt and send the password. It would be much easier and supportable if we had the Cloverleaf add-on.
However, someone on Clovertech has come up with a really neat way to run SFTP using a proc that executes code in START mode and RUN mode. I’d have to search to dig up that discussion, or you could search on SFTP. The discussion was maybe a year ago. We have not used that method because our SFTP transfers are part of larger batch processes that move data around between facilities and have multiple steps. Also some of the files are big and we would have to dedicate threads to them that had Recovery off. We run about 40 file transfer interfaces through Cloverleaf and about 90 in batch scripts. If we converted to Cloverleaf that would be somewhere between 40 and 60 more threads, depending on how generic the threads were and if we had to pass in arguments or use some kind of context-based routing.
If you don’t use the official SFTP module from Infor then another option would be to use SSHFS to mount the remote site as a filesystem and use fileset-local to send the file.