File Transfer Protocol (FTP)

Fivetran supports syncing files from an FTP or FTPS server to your destination.

NOTE: We do not support servers that are configured to reuse connections that have the same TLS session. If your FTP or FTPS server fails to establish a secure connection, we recommend that you uncheck “Require TLS session resumption on data connection when using PROT P” in the server configuration to perform ListFiles operations for data exchange.

Features

Setup guide

Follow our step-by-step FTP connector setup guide to start syncing files from an FTP or FTPS server to your destination.

Upsert with custom primary keys Beta

For upserting with primary keys, use the Primary Key used for file process and load field.

You can select the custom primary keys during the connector setup and use them to update or insert new rows to the destination. We process the files in order of their modified time.

If we detect that one of the selected primary keys has a null value in your files, we display a warning on the connector dashboard but insert the record with a null value in your destination.

If the destination does not support null values, we insert the row with the default value for the column.

You can choose the primary keys only before the initial sync. Once you perform the initial sync, you won't be able to modify the primary keys.

NOTE: You can modify the primary keys only if your initial sync fails. If your initial sync is successful, the option to modify the primary keys is not available.

Types of primary keys

The file connectors use the following types of primary keys:

• Primary key - a column that contains values that uniquely identify each row in your data.
• Composite primary key - a set of columns which, in combination, uniquely identifies a row in your data.
• Surrogate primary key - a column or columns that the system adds to provide a unique identifier for a row in your data.