To get set up with the SFTP connector, you have to enter the username and Host IP used to access the server. You must also include any of the other authentication fields required to access the files within the server. These are:
- Private key file
- Public key file
The Private key file and Public key files if populated must be of the type
If you want to test connecting to your SFTP server we recommend using FileZilla. A connection to the SFTP server can be made from FileZilla using File -> Site Manager -> New Site. The credentials used to successfully connect using FileZilla can be used to set up the connector.
|Backfill||🟢||All data in any file can be ingested|
|Incremental||🟢||Supported on both files and directory using the field |
Must start and end with a
|⬇️ Report||📄 Notes|
|File||Returns all the data in a single file|
|Directory||Returns all data within a single directory|
File Header Source
Choosing the option
Fileassumes that the entries within the first row of data are the column headers. If this is not the case then please choose the option
User specifiedand enter the headers in a comma separated list without spaces.
Ignore Last Line
If the final row of the file(s) contains a summary of column information then you should tick the textbox to exclude this row from the data.
Changing Filename or File Path
If a file is renamed or moved to a different folder the extract must be updated to match the filename and file path, otherwise the extract will fail.
Updated 5 months ago