Has anyone seen an issue after setting up a passwordless sftp connection between servers and then attempted to use the FTP Enterprise transform as a target and set to sftp mode?
I can perform a command line sftp 'put' to the target server without any issues.
However, when attempting to use the FTP Enterprise target stage in sftp mode, the file gets created on the remote server, but has no content.
Th strangest part is that the DataStage job runs to completion with no errors or warnings.
Any advice or guidance on how to debug this issue would be greatly appreciated.
FTP Enterprise Transform in sftp mode.
Moderators: chulett, rschirm, roy
FTP Enterprise Transform in sftp mode.
Mike Czerniawski
type "sftp -V" or even "ssh -V"
The Enterprise stage is coded to the open source APIs. If your brand of SSH is not coded to the open source APIs, you're going to have to do the following:
A) influence IBM to create a patch for you to enable your flavor of SSH/SFTP to be functional with their tool. (not an easy task, trust me, been there done that)
B) scrap the ftp enterprise stage and go with an Execute Sequencer Stage and do a command line call for your SFTP needs. (we did that).
Since your file is a 0 byte file on your target system... that means you actually did an SSH connection and that something else is at fault. You might want to verify your settings. Try SFTPing to yourself first. Work out the kinks locally, then go remotely.
Is the version of SFTP common between both systems?
The Enterprise stage is coded to the open source APIs. If your brand of SSH is not coded to the open source APIs, you're going to have to do the following:
A) influence IBM to create a patch for you to enable your flavor of SSH/SFTP to be functional with their tool. (not an easy task, trust me, been there done that)
B) scrap the ftp enterprise stage and go with an Execute Sequencer Stage and do a command line call for your SFTP needs. (we did that).
Since your file is a 0 byte file on your target system... that means you actually did an SSH connection and that something else is at fault. You might want to verify your settings. Try SFTPing to yourself first. Work out the kinks locally, then go remotely.
Is the version of SFTP common between both systems?
So yes, your SFTP is open source.
The FTP Enterprise stage should interface with it properly.
Look to see if you have proper file permissions on the directory you are writing into. Look to see if you have read authority on the file you are sending. (I know it worked from the command line, but when you execute in DataStage you could be credentially mapped to execute as someone else.)
The FTP Enterprise stage should interface with it properly.
Look to see if you have proper file permissions on the directory you are writing into. Look to see if you have read authority on the file you are sending. (I know it worked from the command line, but when you execute in DataStage you could be credentially mapped to execute as someone else.)