Executing SFTP using FTP Plug-In

royarellano · Post by **royarellano** » Fri Sep 03, 2010 9:20 am

Greetings,

I have a parallel job using an FTP Plug-in stage and a sequential file stage. I am trying to get a file from another server. However, I've only been allowed to do so with an SFTP connection. I've tried manipulating the settings in various ways and I am still unable to successfully get the file from the source server. Can anyone provide exact details as to how I can do this?

Thanks.

v/r

FranklinE · Post by **FranklinE** » Tue Sep 07, 2010 8:52 am

Rumor has it that the 8x version of FTP Enterprise is supposed to be SSHv2 compliant. I'm stuck with 7x and had to get a waiver to not use SFTP.

The only workaround I know of is to run SFTP in a non-DS job and land the files on your local server, then read them with your preferred file stage. That doubles (at least) the I/O processes, but you may not have a choice.

Good luck.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Sep 07, 2010 9:01 am

I did get SFTP working with the FTP Enterprise stage in 8.1, but it required a patch from IBM if I remember correctly.

However, regardless of the working FTPE stage, you can always execute a shell script from a job sequence to do the sftp and pull the file back. That's usually faster from a transfer perspective, but it does require you to land a copy of the file.

royarellano · Post by **royarellano** » Thu Sep 09, 2010 2:46 pm

FranklinE wrote:Rumor has it that the 8x version of FTP Enterprise is supposed to be SSHv2 compliant. I'm stuck with 7x and had to get a waiver to not use SFTP.

The only workaround I know of is to run SFTP in a non-DS job and land the files on your local server, then read them with your preferred file stage. That doubles (at least) the I/O processes, but you may not have a choice.

Good luck.

Thank's, but we are not able to support FTP Enterprise stage, only the FTP Plug-In stage.

royarellano · Post by **royarellano** » Thu Sep 09, 2010 2:47 pm

asorrell wrote:I did get SFTP working with the FTP Enterprise stage in 8.1, but it required a patch from IBM if I remember correctly.

However, regardless of the working FTPE stage, you can always execute a shell script from a job sequence to do the sftp and pull the file back. That's usually faster from a transfer perspective, but it does require you to land a copy of the file.

Thank you very much, unfortunately we're not supporting FTP Enterprise stage, just the Plug-In.

I'm thinking it won't happen.

v/r
Roy