Originally posted by: SystemAdmin

I have a remote server that will allow SFTP connection via OpenSSH on port 22.
I want to use the FTP DataStageTX adapter to write a file on this remote server.
From the datastage server, I can issue the following command:

sftp myremoteserver
SSH is configured to allow a manual password if it cannot authenticate by any other means. So if I now enter a password, in I go.

So for the datastage adapter I am thinking I need to do this:

PUT ( "FTP", "-URL FTPS://<user>:<password>@myremoteserver/<target directory>/<filename>", Mydata)

This tries to use the default FTP port 21 instead of ssh (22). So If I add myremoteserver:22 to the URL I still have an issue:
FTP Adapter, Version 8.0(81)
Copyright © 2004, Ascential Software Corporation. All rights reserved
Built for SUN on Jul 2 2005 at 03:38:19.
Retry Count is 0. Retry Interval is 0. OnFailure is Rollback.
Fetch Unit is 0. Card Mode is Integral.
Will process 7842797 bytes of data.
Run Started at 16:16:38.423 on 11/25/05.
Options used: trace,name,url,pkey,kpass
URL FTPS://dstx:*****@x20mlogp01:22/tmp/20051125081538.20051125090529.xhexgcht01 will be used.
WSAStart: Entering
WSAStart: bWSStarted = 0, nWSClients = 0
WSAStart: SSL library load succeeded.
Sockets Client ID 1 enabled.
WSAStart: Exiting (rc = 1)
Using explicitftps: protocol.
Server host is 'x20mlogp01'.
Using port '22' for the connection.
Connecting to 'x20mlogp01'.
Socket Opened.
Connected.
<AUTH TLS-P
>SSH-2.0-OpenSSH_4.0 (E)
>Protocol mismatch. (E)
> (I)
<AUTH SSL
> (I)
WSATerm: Entering
WSATerm: bWSStarted = 1, nWSClients = 1
Sockets Client ID 1 disabled.
WSATerm: nWSClients remaining = 0
WSATerm: Exiting
Run Terminated at 16:16:38.868 on 11/25/05.

The default SSL protocol in Datastage is SSLv23 so this should be okay.

Maybe I am missing the point of how this works but any help would be appreciated.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I use Putty for sftp and run it with the batch adapter. Howerver, it's not very good for error reporting.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Have you purchased & installed the security option?
Do you have a firewall or proxy server between you and the FTP server?
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Yes, I have the security option installed. I'm assuming I have to use the -PKEY and KPASS flags to the FTP adapter but looking to understand this overall process and get it working.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I might be missing something here - but I didn't think the Ascential security option was compatible with OpenSSH (as OpenSSH is SFTP, rather than the security pack's FTPS - poss cause of different protocol error msg?). At least this is what I gathered and then was confirmed by UK Ascential support. This was on 6.5.2 and 6.7.1

Please let us know if you do get it working (with error reporting; commit/rollback) though as it would be very useful.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Jon, I think you hit the nail on the head: I found this:

Firstly, there is an enhancement to standard FTP (as defined in RFC 959), which uses the same FTP commands (and protocol) over secure sockets, i.e. over SSL/TLS. This is variously known as FTPS, FTP-SSL, and FTP-over-SSL. There are many FTP servers that support FTPS.

There is also another protocol, unfortunately known as SFTP, which also provides secure file access, but which is not related to the standard FTP protocol. This is implemented using SSH (Secure SHell), a suite of secure network connectivity tools (when used with SSH2 this is known as SFTP). The primary purpose of SSH is to enable users to remotely log into a machine over a secure connection.

The two protocols are completely different and not related.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Well that would certainly explain it. Many thanks for your comments.
I think my solution will have to involve a batch adapter that does the sftp access for me.
Thanks everyone.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange