Originally posted by: jvanboga
Unless you have the WTX security pack you will need to install a Secure FTP client on a windows machine. If you have the security pack there should be an example of an SFTP command line. Is you have a SFTP application installed on the box you should be able to execute it via WTX using the '-cmd' function.
The nice thing about using an SFTP package is that it should hold all of the important informtation like user names, passwords, URLs, paths, keys etc. All you'll need to code is the command to execute the application, tell it which connection you want to run and give it some file info. Something like '-cmd sftp_application connection_id local_data_path/file_to_transport optional_destination_pathing optional_logging'. Do some research, last time I looked you could get some reasonably priced and reliable SFTP apps for under $500. You can easily spend more than that trying to do this on your own. You may have already.
That said:
This is a sample FTP command for FTP over VPN on a Windows platform:
-implicit -URL FTPS://username:
pw@sftp.url:port/path/filename sendfile;type=A
This is a sample FTP Command for a standard FTP on a Windows platform:
-URL FTP://username:pw@url:port(optional if port is 21)/path/filename
As shown both would be relevant to output card settings. So performed as shown above you'd need to either set the values when you define the output card or override the default card setting via a run command.
Another way would be to incorporate the above in a rule that would look somehting like
run("ftp", "example from above", package(data_card_to_send))
or
run("ftp", "example from above", seriestotext(data_to_send))
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender