How to export from Skyvia to an SFTP endpoint for an automated workflow

Jayden Bartram
May 19, 2021 · 4 min read

Skyvia enables you to automatically export data on a regular basis to an SFTP endpoint. When using the likes of Couchdrop SFTP, this could be utilised as part of an ETL process, primarily if you are looking to expose this data to a vendor or transfer this data to a cloud storage platform or share.

A standard example process could be similar to the below where data is transformed into a CSV and then be directly uploaded via SFTP where a webhook event is sent to a partners platform to then pull down the data for their use.

skyvia export sftp
Using Skyvia and Couchdrop you can create an automated ETL data pipeline

As Couchdrop SFTP enables you to connect any cloud storage endpoint in the backend (SharePoint, Dropbox, S3, Azure Blob, etc.) it is fully agnostic and enables you to get your data to a platform that can be utilised by yourself or an automation workflow in a simpler manner for processing. Additionally, you could combine Skyvia with another no-code platform (Zapier, Boomi or Xplenty) so that on the CSV being upload a webhook is sent and the other platform automatically pulls down the data and performs additional transformation or includes the CSV into another workflow.

How to export content from Skyvia into another workflow

  • Step 2. Configure Couchdrop SFTP as a Skyvia connection
  • Step 3. Create an export workflow
  • Step 4. Utilise Couchdrop SFTP webhooks to initiate next step in workflow

Step 1. Create Couchdrop SFTP account

cloud sftp skyvia workflow
cloud sftp skyvia workflow
Couchdrop SFTP web interface

Step 2. Configure Couchdrop SFTP as Skyvia connection

configuring sftp skyvia
configuring sftp skyvia

Step 3. Create an export workflow

export sftp workflow skyvia
export sftp workflow skyvia

Create a task and choose the objects you would like to export as a CSV file.

couchdrop sftp skyvia
couchdrop sftp skyvia

When you are ready, run the task manually to test it is working.

skyvia sftp automated workflow elt
skyvia sftp automated workflow elt

Within Couchdrop’s SFTP audit log, you will see the transaction was successful (note the upload of orders.csv)

couchdrop sftp etl workflow
couchdrop sftp etl workflow

Step 4. Utilise Couchdrop SFTP webhooks to initiate next step in workflow

skyvia integromat sftp workflow
skyvia integromat sftp workflow
The complete export in Skyvia
integromat etl workflow
integromat etl workflow
orders.csv uploaded via SFTP and then automatically processed via Integromat workflow
couchdrop cloud sftp extract transform load workflow
couchdrop cloud sftp extract transform load workflow
Couchdrop audit logs showing the behaviour

To get up and running with Couchdrop’s cloud SFTP server and integrate it into your automated workflow, navigate to Couchdrop’s website to sign up or learn more.

Couchdrop

Couchdrop is your cloud SFTP / MFT platform

Couchdrop

Couchdrop is the secure file gateway and cloud SFTP / MFT platform. Couchdrop acts as your secure access method between systems or for clients to send you files to your cloud storage backend, that can be completely automated.

Jayden Bartram

Written by

CEO of Couchdrop and Movebot

Couchdrop

Couchdrop is the secure file gateway and cloud SFTP / MFT platform. Couchdrop acts as your secure access method between systems or for clients to send you files to your cloud storage backend, that can be completely automated.