Connections > Connection properties > FTP/SFTP connections

FTP/SFTP connections

File Transfer Protocol (FTP) connections enable you to use FTP to access source and target files. Secure File Transfer Protocol (SFTP) connections use secure protocols, such as SSH, to access source and target files.
When you configure an FTP/SFTP connection, you define the following directories:
Local directory
Directory local to the Secure Agent that contains a copy of the source or target files.
Remote directory
Location of the files you want to use as sources or targets.
Informatica Intelligent Cloud Services validates the file in the local directory, not the remote directory. When you configure FTP/SFTP connections, ensure that the local directory contains valid copies of all source and target files. When you configure a task with an FTP/SFTP connection, Informatica Intelligent Cloud Services uses the file structure of the local file to define the source or target for the task. The file structure of the local file must match the source or target file in the remote directory. Informatica Intelligent Cloud Services also uses the local file to generate data preview. If the data in the local file does not match the data in the source or target file in the remote directory, data preview might display inaccurate results.
When Informatica Intelligent Cloud Services runs a data integration task with a FTP/SFTP target connection, it creates a target file based on the target defined in the task. As it completes the task, Informatica Intelligent Cloud Services writes the target file to the remote directory, overwriting the existing file.

FTP/SFTP connection properties

The following table describes the FTP/SFTP connection properties:
Connection property
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 for the user name used to log in to the FTP server.
Host name or IP address of the FTP/SFTP host.
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.

Key exchange algorithms and ciphers

You can use the following key exchange algorithms and ciphers for SFTP connections:
Key exchange algorithms

FTP/SFTP connection rules and guidelines

Consider the following rules and guidelines for FTP/SFTP connections: