Data Integration Connections

Data Integration Connections

FTP/SFTP Connection Properties

FTP/SFTP Connection Properties

The following table describes the FTP/SFTP connection properties:
Connection property
Description
Runtime Environment
Runtime environment that contains the Secure Agent to use to access the files.
User Name
User name used to log in to the FTP server.
Password
Password for the user name used to log in to the FTP server.
Host
Host name or IP address of the FTP/SFTP host.
Port
Network port number used to connect to FTP/SFTP connection. Default port is 21 for FTP and 22 for SFTP.
Local Directory
Directory on a local machine that stores the local file. The local machine must also run the Secure Agent used to run the corresponding task. Enter a local directory or use the Browse button to select a local directory.
Remote Directory
Directory on the FTP/SFTP host that stores the remote flat file. Depending on the FTP/SFTP server, you might have limited options to enter directories. For more information, see the FTP/SFTP server documentation.
Date Format
Date format for date fields in the flat file.
Default date format is: MM/dd/yyyy HH:mm:ss
Code Page
Code page compatible with the system where the source or target flat file resides. Select one of the following code pages:
  • MS Windows Latin 1. Select for ISO 8859-1 Western European data.
  • UTF-8. Select for Unicode data.
  • Shift-JIS. Select for double-byte character data.
  • ISO 8859-15 Latin 9 (Western European).
  • ISO 8859-2 Eastern European.
  • ISO 8859-3 Southeast European.
  • ISO 8859-5 Cyrillic.
  • ISO 8859-9 Latin 5 (Turkish).
  • IBM EBCDIC International Latin-1.
  • Japanese EUC (with \ <-> Yen mapping
  • IBM EBCDIC Japanese
  • IBM EBCDIC Japanese CP939
  • PC Japanese SJIS-78 syntax (IBM-942)
  • PC Japanese SJIS-90 (IBM-943)
  • MS Windows Traditional Chinese, superset of Big 5
  • Taiwan Big-5 (w/o euro update)
  • Chinese EUC
  • ISO 8859-8 Hebrew
  • PC Hebrew (old)
  • PC Hebrew (w/o euro update)
  • EBCDIC Hebrew (updated with new sheqel, control characters)
This is a Secure FTP Connection
Indicates whether the connection is secure or not secure. Select to create an SFTP connection.

0 COMMENTS

We’d like to hear from you!