FTP properties

FTP connection

Select FTP in the list and configure the connection.

Select your engine from the list and set the main and advanced settings.

Main settings
Property	Configuration
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 settings
Property	Configuration
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.

After configuring the connection, give it a display name (mandatory) and a description (optional).

Dataset configuration
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.

After configuring the dataset, give it a description (optional).

Main settings
Property	Configuration
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: Header `Space` 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 settings
Property	Configuration
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.