Secure transfer of data files using DataMigrator can be done using an SFTP (SSH File Transfer Protocol) server as a data source or target. When adding a connection for a Flat File or Delimited Flat File adapter, there is a choice of which file protocol to use: FTP or SFTP.
An SSH (Secure Shell) connection without a password should be established from the local to remote server prior to starting the DataMigrator server.
To configure a connection to an FTP server:
Name or IP address of the FTP or SFTP server.
Directory on the FTP or SFTP server to connect to. This value is optional. If it is not specified, either of the following will be used:
User ID to connect to the FTP or SFTP server.
Password to connect to the FTP or SFTP server.
The file protocol that is being used, either FTP or SFTP (SSH FTP).
Select the profile in which to store the CONNECTION_ATTRIBUTES command.