Page 1 of 1

issue in ETL (Datastage V .8.0.1) regarding SFTP of a file

Posted: Wed Jan 28, 2009 12:18 am
by killerjean84
we are facing a issue in ETL (Datastage V .8.0.1) regarding SFTP of a file i.e uploading and downloading a file from the client server which uses SFTP,

we tried running this job through a command stage with the help of a putty Application in server editiion but its failing,

we also tried running thru FTP plugin stage in parrallel edition we are unable to achieve this,

Is there any other way this can be achieved please let me know

Posted: Wed Jan 28, 2009 7:22 am
by chulett
Secure FTP is still a feature that is coming, from what I recall, so your only option is to build a script to leverage it. If this is really a TX product question, you'd be better off posting over in the dedicated TX forum, which is where those experts hang out. For all I know, the former Mercator product already supports SFTP. :?

Whenever you go after this (new post or reply here) it would help to expand on your issues. Simply saying that "it doesn't work" doesn't give anyone much to go on, help-wise.

Re: issue in ETL (Datastage V .8.0.1) regarding SFTP of a fi

Posted: Mon Feb 02, 2009 9:01 am
by tjr
SFTP is available in DS 8.0.1. What is the error you are getting?

Re: issue in ETL (Datastage V .8.0.1) regarding SFTP of a fi

Posted: Thu Mar 05, 2009 2:10 am
by kamesh_sk
First verify if FTP and SFTP are enabled in your machine.
To test this login in some other machine and in the cmd mode type ftp and your server ip.
if it asks for a user name and password then ftp is anabled, it if says connection denied then you must eanable your FTP ports 21 and 22 in your server.To enable that you need to have the OS cd also along with you, or ask your system admin to enable it