Flat Data Ingestion: FTP/SFTP Data Ingestion

Updated on

Oct 19, 2023


Your data provider or your own software must be able to send reports via FTP/SFTP automatically and regularly.

How to Set Up an FTP/SFTP Data Ingestion?

Step 1. Create a New Flat Data Ingestion request using Improvado Service Desk:

  • provide us with the required details about this integration by filling out all the request fields.
  • make sure you have attached an example of the data table you want to see.
  • specify the update logic you want for your table:
    - append (new data rows are added to the end of the table)
    - incremental (records get modified, but the old data is saved too)
    - snapshot (overwriting of all the data each time).
  • explain the FTP server’s folder structure.
  • specify the type of FTP connection needed: FTP / SFTP /FTPS.

Step 2. Get a confirmation from Improvado whether we can ingest your data or instructions on what needs to be changed in order to make it possible.

Step 3. Set up access:

  • In case you want to use the Improvado FTP-server, there are two possible options: SFTP or FTPS.
    - to set up SFTP, we need to get your public SSH-key
    - to set up FTPS, we will create a login and password for you.
  • In case you want us to load data from your FTP-server
    - for SFTP connections, we will provide our public SSH-key on your request
    - for FTP/FTPS, we will need to get a login/password from you.

Step 4. Send test data to a pre-determined destination.

Step 5. Get a confirmation from Improvado whether we have successfully loaded the data.

Step 6. Schedule reports delivery from your data platform.


Schema information

Setup guide


No items found.


Troubleshooting guides

Check out troubleshooting guides for
Flat Data Ingestion: FTP/SFTP Data Ingestion


Frequently asked questions

No items found.
☶ On this page


Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.