SFTP with FTP stage version 8.1

ray.wurlod · Post by **ray.wurlod** » Mon Mar 09, 2009 12:07 am

Has anyone had a chance yet to play with using port #22 with the FTP stage in version 8.1 ?

If so please post your observations here. Did it work? Did it work well? How (in the stage design) did you specify the keys file on the remote server?

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Jun 10, 2009 10:51 am

1) Isn't working - neither server nor PX FTP Enterprise
2) Used SSH and ssh-keygen for setup. Had to buy a 3rd party tool for Windows (Pragma Systems FortressSSH) to get that side working.
3) Have a call into IBM for three days now - no response.

basu.ds · Post by **basu.ds** » Thu Jun 11, 2009 12:20 am

Hi
FTP stage works in server 8.1 but you will have to mention the file path as given ftp://160.61.16.2/\ETRAVEL.csv.
SFTP does not work could not find as how to specify the private key generated by the SSH tool for windows.
If any one have solution for SFTP on windows please let me know

Thanks...........

chulett · Post by **chulett** » Thu Jun 11, 2009 5:15 am

What do you mean by 'could not find as how to specify the private key'? There's nothing to 'specify' in the stage, once the RSA key is setup properly it should just work. Talk to a SysAdmin.

kamesh_sk · Post by **kamesh_sk** » Mon Jun 22, 2009 6:25 am

HI,

Chullet even i also have the same problem with SFTP.Could not clearly figure out as how to set up the RSA keys. Can you explain how to set up the RSA keys?... I understand that specifying the RSA keys is out of control of DS SFTP stage. Am i right?

chulett · Post by **chulett** » Mon Jun 22, 2009 6:29 am

Right, has nothing to do with DataStage directly. Best to just google for it, for example here is a Linux version but the instructions are fairly generic.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Jul 08, 2009 1:31 pm

Ok- after struggling with this for a while, I finally decided it wasn't me that had the problem - the stage wasn't working. So I called IBM and sure enough, several weeks later I've finally gotten a patch and SFTP now works. Since it is the PX version - I'm not going to reply with details in this thread, I'll start a new thread in the EE forum.

for more details on the PX solution check here:
viewtopic.php?p=333066

ray.wurlod · Post by **ray.wurlod** » Wed Jul 08, 2009 4:54 pm

Unfortunately the original requirement was to get it working in a server job.

lstsaur · Post by **lstsaur** » Wed Jul 08, 2009 8:46 pm

That's what I thought that you asked how to make FTP stage but using port 22 to work for server job.