Can SFTP be used within FTP plug in Stage

just4geeks · Post by **just4geeks** » Tue Oct 14, 2008 5:54 pm

Hi All,

I am working on a DataStage Upgrade Project. Previously we were using FTP Stage to tranfer the data to other servers.

In new system, we have to use SFTP. Can this be done using existing FTP stage?

If yes then How?

If no, then what are workarounds to resolve this issue.

I have researched in this forum but could not get a satisfied answer.

Thanks in Advance.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 14, 2008 6:39 pm

There's no such thing as an FTP plug in stage in ProfileStage. Please post in the correct forum.

filename.txt · Post by **filename.txt** » Tue Oct 14, 2008 6:41 pm

I think you cannot use FTP stage for SFTP.

Passing password for SFTP is different than that you do FTP.

I would suggest the easiest way is to ask your unix admins to have a pairing between two servers (source & your local file server) by sharing keys.

With this you don't have to use any username or password..and still you can have secured transfers.

you have to write a small script to pull those files (use get or mget).

This password less transfer from from SFTP is easy and secured.

just4geeks · Post by **just4geeks** » Tue Oct 14, 2008 11:34 pm

Hi ,

Thanks for your inputs. Sorry for putting it to wrong forum. Moving to right place.

Thanks again!