Dell Boomi AtomSphere

SFTP operation

The SFTP operation defines what to do with the connection, such as setting the directories to read to or write from.

The operation supports the following actions:

  • Get — Used to download data from the SFTP server. The FTP operation does not use the MGET command, so you cannot specify a list of files to retrieve such as “file1 file2 file3”. You can, however, specify wildcards for file name pattern-matching.

  • Send — Used to upload data to the SFTP server.

The SFTP operation does not support MGET or MPUT. Therefore, you cannot specify a list of files as a filter, such as file1 file2 file3. The FTP operation does not use the MPUT command to send multiple files in a single transmission. Instead, the operation sends documents as separate PUT commands.

Options tab

These fields appear on the Options tab depending the Connector and SFTP actions:

Name Description
Connector Action Gets or Sends files using the overwrite rules in the SFTP Action setting.
SFTP Action The GET actions set what to do when encountering file(s) with the same name:
  • Get — retrieve but do not delete the file(s) from the server.
  • Get and Delete — retrieve and delete the file(s) from the server. Dell Boomi recommends this action for executing in production mode to prevent processing the same files twice.

  • Get and Move — retrieve and automatically move the file(s) to the designated Move To Directory.

The SEND actions set what to do when encountering file(s) with the same name in the Remote Directory:
  • PUT-Rename When File Exists — rename the new file by attaching an incremental number. For example, if output.txt is being written and it exists, then output1.txt is attempted, then output2.txt, etc., until a name is found that does not exist.

  • PUT-Append When File Exists — append the data to the end of the new file name.

  • PUT-Error When File Exists — throw an error, which causes the process to fail.

  • PUT-Overwrite When File Exists — overwrite the old file.

Remote Directory Designates the directory on the SFTP server from which Dell Boomi AtomSphere reads files or to which data is uploaded. If there is no designated Move To Directory, the files remain in the remote directory.
File Filter (Get) Reads only files with a file name that matches the file filter, which use the wildcard characters * and ?.
Maximum Files to Read (Get) Sets the maximum number of files to read at one time. The default value "0" gets all matching files in the directory.
Move To Directory (Get and Move, Send) Designates the directory to automatically move the data to after it has been successfully uploaded or downloaded.

Optionally use if another application is sending files to or retrieving files from the Move To Directory. Boomi AtomSphere can first write the files to the Remote Directory to avoid the risk that the application might read in the file(s) before the upload or download is completed. After the files are successfully loaded, Boomi AtomSphere moves them to the Move To Directory.

Force Move (Get and Move, Send) When Move to Directory is designated, this setting:
  • If on, the connector's special logic moves files to the designated Move To Directory.
  • If off, some SFTP servers allow a move while other servers return an error.

Archiving tab

See the Connector operation’s Archiving tab for more information.

Tracking tab

See the Connector operation’s Tracking tab for more information.

Caching tab

See the Connector operation’s Caching tab for more information.

Related References