Documentation

Start typing to search.

SFTP (external server) Data source

Written by Ilya Sudakov

Updated on Oct 20, 2026

Note: This article covers the SFTP (external server) data source, which connects to an SFTP server that you host and manage. If you'd rather upload files to an SFTP server that Improvado creates for you, see the SFTP data source guide. To load data into SFTP, see the SFTP destination guide.

Improvado stores only the credentials to your server. On every scheduled run, it looks for files in the folder you specify, picks the ones that match your file pattern, and extracts them into a data table.

How to connect SFTP (external server) integration

Prepare your SFTP server:

  1. Create a user (or pick an existing one) with permission to list and read the folder that contains your files. Improvado only reads files; it doesn't write, move or delete them.
  2. Make sure the server is reachable from the internet. Hosts that resolve to a private IP address are rejected.
  3. If your server only accepts connections from approved IP addresses, contact your Improvado account manager to get the addresses to allow.

On the SFTP (external server) authorization page, choose an authentication method:

  • SFTP with password (default) — a username and password.
  • SFTP with SSH key — a private SSH key, with an optional passphrase.

Fill in the fields and click Authorize:

Field Description
Host Hostname or IP address of the SFTP server.
Port The SFTP port. The default SFTP port is 22.
User The user from Step 2.
Password The user's password. Only for SFTP with password.
Private key Only for SFTP with SSH key. Upload the private key file (.pem, .key, .ppk or .openssh). Supported key types: RSA, Ed25519 and ECDSA. The key must match a public key configured for this user on the server.
Private key passphrase Optional, only for SFTP with SSH key. Fill it in only if the private key is protected by a passphrase.

Improvado tests the connection when you click Authorize, so the credentials and the network access must already work at this point.

How to extract data from SFTP (external server)

Step 1. Import

  1. Upload a sample file from your computer: click to select it, or drag and drop it into the upload area. Use a file with the same structure as the files on your server. Improvado uses it to detect the columns; the data itself is extracted from your server.

Note

  • Supported file formats: csv, tsv, txt, xls, xlsx, avro, parquet, zip, gzip
  • Maximum size: 10 GB
  • A file must begin with column headers starting in column A. If there are extra rows before the headers, use the Header rows to skip field.

  1. After the file is uploaded and checked for security, set Header rows to skip — the number of rows before the column headers. Check the header row preview to confirm the headers are identified correctly.
  2. If the file ends with rows that aren't data (totals, notes), set Footer rows to skip.
  3. For an Excel file with several sheets, select the sheet to extract.
  4. Click Continue.

Step 2. Setup Scheduling

  1. Configure your Extraction scheduling — how often Improvado checks the folder on your server for files to extract. By default, extraction runs once a day.
  2. Click Continue.

Step 3. Match

  1. In General settings, enter the Folder path (optional) — the folder on the server where Improvado looks for files, for example reports/daily/. The path must end with /. Improvado also searches subfolders; folders and files whose names start with a dot are skipped.
  2. Enter the File pattern (optional) — a regular expression for the file paths to extract inside the folder, for example .*\.csv$. Don't use the ^ symbol. Leave the field empty to extract every file in the folder and its subfolders.
  3. Select the fields you need to import. By default, all fields are selected.
  4. Check the field type. Each field can be assigned a Text, Number, or Date type. The date field is a unique date key and should be singular; choose from a range of date formats for it. If a field has numeric values you don't want to include in calculations, change its type from Number to Text.
  5. The Skip rule lets you exclude empty rows or rows with specific values in a selected field.
  6. Choose the Write strategy used when uploading data into Improvado Storage. Learn more.
  7. Set the Data table name which will be used for loading data to your destination.
  8. Click the Import N fields button to continue.

Note

Learn more about working with dates in Flat Data here.

Step 4. Preview

  1. Check the structure of the data that will be extracted.
  2. Click Continue to confirm the settings and start data extraction.

Order Details page

You can find your SFTP (external server) connection on the Connections page. The extraction has these tabs:

  • Uploaded files — the files Improvado picked up from your server.
  • Settings — review and change the Folder path, File pattern, Header rows to skip, Footer rows to skip and Table meta for your data extraction.

Troubleshooting

Having trouble with your setup? Find solutions to common issues →

Was this article helpful?

Questions? The Improvado team is always happy to help. Send us an email, contact your Customer Success Manager, or raise a request in the Improvado Service Desk.