Skip to main content Skip to complementary content

FTP properties

Properties to configure to open an FTP connection.

FTP connection

Property

Configuration
Selection Select or enter FTP.
Configuration
Engine Select your engine in the list.
Connection type Select FTP, SFTP or FTPS in the list.
Main File protocol Select the type of protocol to be used to connect to the server.
Host Enter the IP address or hostname of the FTP server.
Port Enter the listening port number of the FTP server. If blank, the default port will be used (21 for FTP).
Use credentials Enable this option if user authentication (username and password) is required to access the FTP server.
Use client certificate Enable this option if a client certificate is required to access the SFTP server.

Enter the user key you generated and the pass phrase.

This option is only available if you selected the SFTP connection type.
Advanced Trust type
Select one of the options depending on the type of server certificate verification you prefer:
  • All indicates no verification.
  • Valid indicates the verification of the certificate only.
  • None indicates the default JVM verification.

This option is only available if you selected the FTPS connection type.
Protocol

Enter the protocol used to initiate the secured connection. Use one of the following values: SSL, SSLv2, SSLv3, TLS, TLSv1, TLSv1.1, TLSv1.2.

This option is only available if you selected the FTPS connection type.
Keep-alive timeout Sets the maximum waiting time in milliseconds before sending another control keep-alive message.
Keep-alive reply timeout Sets the maximum time in milliseconds to wait for keep-alive message replies before continuing.
Connection timeout (ms)

Sets the maximum waiting time in milliseconds before cancelling the connection.

This option is only available if you selected the SFTP connection type.
Authentication timeout (ms)

Sets the maximum waiting time in milliseconds before cancelling the authentication.

This option is only available if you selected the SFTP connection type.

FTP dataset

Property Configuration
Dataset name Enter a display name for the dataset. This name will be used as a unique identifier of the dataset in all Talend Cloud apps.
Connection Select your connection in the list. If you are creating a dataset based on an existing connection, this field is read-only.
Description (optional) Enter a description for the dataset.
Main Path Enter the path to the file to be read/written.
Format Alternatively, select in the list the format of the file to be retrieved and enter or select the information related to this file format:
  • CSV:
    • Line separator type: Select the type of line separator used in the file to be read/written, or select Other in order to enter another line separator manually.
    • Encoding type: Select the file encoding type in the list, or select Other in order to enter another encoding type manually.
    • Set header: Enable the toggle to set a line or lines as header. In the Number of lines list, select the number of header lines in the file to be read/written.
    • Field separator type: Select the type of field separator used in the file to be read/written, or select Other in order to enter another field separator manually.
      Information noteNote: When you enable the Header option, Space cannot be used as a field separator.
  • JSON:
    • JSON Pointer: Enter the JSON pointer expression.
  • Excel:
    • Excel format: Select the format/version corresponding to the file to be retrieved.
    • Sheet name: Enter the name of the specific Excel sheet you want to be retrieved.
    • Set header: Enable the toggle to set a line or lines as header. In the Number of lines list, select the number of header lines in the file to be read/written.
    • Set footer: Enable the toggle to set a line or lines as footer. In the Number of lines list, select the number of footer lines in the file to be read/written.
  • Avro: No specific parameters required for this format.
Advanced Escape character CSV-specific parameter allowing you to enter the escape character between double quotation marks. By default, it is /.
Quote character CSV-specific parameter allowing you to enter the enclosure character (only one character) between double quotation marks. For example, """ needs to be entered when double quotation marks (") are used as the enclosure character.
Infer all JSON numbers as double JSON-specific parameter allowing you to identify all JSON numbers as the double datatype.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here