We have a need to do a file transfer using SFTP. We've done FTP before. Has anyone done this before in a .fex? Would you be willing to share the code? This is actually for a Data Migrator program but I thought the same code would be applicable. Thanks.

This message has been edited. Last edited by: Kerry,

Haven't done it, but should be easy.

Just check out the command, and its options, and take into account where the command is being executed from.

I got the sftp working from the UNIX script. Now I need to test the code in WF or Data Migrator. Thanks.

Are you able to run it from either:

! {script}

or

-UNIX {script}

Make sure you add the path to the script, if it isn't in the loca directory or path.

Is the sftp script different from the ftp script? If the only difference is using sftp iso ftp but everything else is the same then there may be an extra solution. Create a symbolic link to sftp called ftp. When you then call ftp, it will actually start sftp in stead.

Executing the sftp script works fine in UNIX but when calling it using !/home/bus/scripts/sftp_test.sh I get a "HOST KEY VERIFICATION FAILED" and the connection closes. I'm going to trace it next and if that doesn't help I'll open a case with IBI.

I got it working from the server now so all is OK. I actually needed to execute it from Data Migrator but there's no reason it shouldn't work in WebFOCUS also.
Thanks for your suggestions.