File Transfer Protocol (FTP)
Fivetran supports syncing files from an FTP or FTPS server to your destination.
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
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS Deployment model for the connector.
Setup guide
Follow our step-by-step FTP connector setup guide to start syncing files from an FTP or FTPS server to your destination.
Sync overview
Syncing spreadsheets
To sync only Excel files in Merge Mode, you must select xls/xlsx/xlsm as the file type in the connector setup form and specify the cell reference during connector configuration. We use the cell reference to sync contiguous data to the right of the cell and below it in the Excel worksheet.
Example:
Let's assume there are 4 excel worksheets in a workbook:
- Data1
- Data2
- Data3
- Data4
You want to sync your data from cell C3 of the "Data2" worksheet, then your cell reference will be "Data2”!C3. So, the connector syncs data from the "Data2" worksheet starting at cell C3.
NOTE: We do not support finding data ranges if the rows contain merged cells. We do not consider the rows with merged cells and skip them while finding data ranges.