Connectors

/

SFTP

SFTP

Files

Sync SFTP data anywhere.

SFTP (Secure File Transfer Protocol) is a secure way to transfer files between two computers over the internet. It uses encryption to protect the data being transferred, making it more secure than traditional FTP (File Transfer Protocol). SFTP is commonly used by businesses and organizations to transfer sensitive data such as financial information, medical records, and personal data. It requires authentication using a username and password or public key authentication, ensuring that only authorized users can access the files. SFTP is also platform-independent, meaning it can be used on any operating system, making it a versatile and reliable option for secure file transfers.

  • Standard
  • Alpha
Sync SFTP dataRead the docs
  • 50+Destinations
One connector

Everything SFTP can do in Airbyte

  • Sync to your warehouse

    Land SFTP data in 50+ destinations on a schedule you control.

  • One authorization

    Authenticate SFTP once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the SFTP connector on Cloud, Self-Managed Enterprise.

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncNot supported
  • NamespacesNot supported
  • Available onCloud, Self-Managed Enterprise
  • Destinations50+ Airbyte connectors
  • Connector version0.2.4

Set up in 9 steps

  1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
  2. Click on the "Create a new connection" button and select "SFTP" as the source connector.
  3. Enter a name for the connection and click "Next".
  4. In the "Connection Configuration" section, enter the hostname or IP address of the SFTP server, as well as the port number (usually 22).
  5. Enter the username and password for the SFTP server in the "Authentication" section.
  6. If your SFTP server requires a private key for authentication, select the "Private Key" option and enter the path to the key file.
  7. In the "Advanced" section, you can specify additional options such as the path to the remote directory and the file pattern to use for selecting files.
  8. Click "Test" to verify that the connection is working correctly.
  9. If the test is successful, click "Create" to save the connection and start syncing data from the SFTP server.
Authentication

Authenticate SFTP once

  • Password Authentication

  • SSH Key Authentication

FAQ

Common questions

What is ETL?

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

What data can you extract from SFTP?

SFTP provides access to various types of data that can be used for different purposes. Some of the categories of data that SFTP's API gives access to are:

1. File data: SFTP's API allows users to access and transfer files securely over the internet. This includes uploading, downloading, and managing files.
2. User data: SFTP's API provides access to user data such as usernames, passwords, and permissions. This allows users to manage and control access to their files and folders.
3. Server data: SFTP's API gives access to server data such as server logs, server configurations, and server status. This allows users to monitor and manage their server resources.
4. Security data: SFTP's API provides access to security data such as encryption keys, certificates, and security policies. This allows users to ensure that their data is secure and protected from unauthorized access.
5. Network data: SFTP's API gives access to network data such as IP addresses, network configurations, and network traffic. This allows users to monitor and manage their network resources.

How do I transfer data from SFTP?

1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Create a new connection" button and select "SFTP" as the source connector.
3. Enter a name for the connection and click "Next".
4. In the "Connection Configuration" section, enter the hostname or IP address of the SFTP server, as well as the port number (usually 22).
5. Enter the username and password for the SFTP server in the "Authentication" section.
6. If your SFTP server requires a private key for authentication, select the "Private Key" option and enter the path to the key file.
7. In the "Advanced" section, you can specify additional options such as the path to the remote directory and the file pattern to use for selecting files.
8. Click "Test" to verify that the connection is working correctly.
9. If the test is successful, click "Create" to save the connection and start syncing data from the SFTP server.

What are top ETL tools to transfer data from SFTP?

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

What is ELT?

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

Difference between ETL and ELT?

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Explore
All connectors

Start moving SFTP data today

Free for 14 days on Airbyte Cloud. Set up the SFTP connector once and let Airbyte keep it in sync.

Try it freeTalk to sales