Connectors

/

SFTP Bulk

Data replication

Sync SFTP Bulk data anywhere.

SFTP is basically based on the SSH2 protocol, which uses a binary encoding of messages over a secure channel. SFTP Bulk contains the setup guide and reference information for the FTP source connector. SFTP Bulk fetches files from an FTP server matching a folder path and defines an optional file pattern to bulk ingest files into a single stream. It incrementally loads files into your destination from an FTP server based on when files were last added or modified.

  • Standard
  • Alpha
Sync SFTP Bulk dataRead the docs
SFTP Bulk

One connector

Everything SFTP Bulk can do in Airbyte

  • Sync to your warehouse

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

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • File transfer

    Move files through the pipeline as-is, without parsing them into records first.

  • One authorization

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

Specifications

What to know before you sync SFTP Bulk

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version1.9.2
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • File transferSupported
  • Destinations50+ Airbyte connectors

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 Connection" button and select the "SFTP Bulk" source connector.
  3. Enter a name for the connection and click on the "Next" button.
  4. In the "Connection Configuration" section, enter the following information: - Host: the hostname or IP address of the SFTP server - Port: the port number used for SFTP (usually
  5. Username: the username used to access the SFTP server - Password: the password associated with the username - Private Key: (optional) the private key used for authentication - Passphrase: (optional) the passphrase associated with the private key - Path: the path to the directory containing the files to be synced
  6. Click on the "Test" button to ensure that the connection is successful.
  7. If the test is successful, click on the "Create Connection" button to save the connection.
  8. Once the connection is created, you can configure the sync settings by selecting the desired sync mode (full refresh or incremental) and setting the sync schedule.
  9. Finally, click on the "Create" button to start the sync process.

Authentication

Authenticate SFTP Bulk once

  • Authenticate via Password

  • Authenticate via Private Key

Explore

Related connectors

SavvyCalOthersStandard Sources cloudself-managed-enterprise
ScryfallOthersStandard Sources cloudself-managed-enterprise
SecodaOthersStandard Sources cloudself-managed-enterprise
SenseforceOthersStandard Sources cloudself-managed-enterprise
SpaceX APIOthersStandard Sources cloudself-managed-enterprise
SparkPostOthersStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

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.

SFTP Bulk's API provides access to a wide range of data related to file transfer and management. The following are the categories of data that can be accessed through the API:

1. File Transfer Data: This includes information related to the transfer of files such as file name, size, transfer status, and transfer time.
2. User Data: This includes user-related information such as user ID, username, and password.
3. Server Data: This includes server-related information such as server name, IP address, and port number.
4. Security Data: This includes security-related information such as encryption algorithms used, authentication methods, and access control policies.
5. Error Data: This includes information related to errors that occur during file transfer such as error codes, error messages, and error descriptions.
6. Audit Data: This includes information related to auditing and compliance such as user activity logs, file transfer logs, and security logs.

Overall, SFTP Bulk's API provides access to a comprehensive set of data that can be used to monitor, manage, and secure file transfers.

1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Create Connection" button and select the "SFTP Bulk" source connector.
3. Enter a name for the connection and click on the "Next" button.
4. In the "Connection Configuration" section, enter the following information:
- Host: the hostname or IP address of the SFTP server
- Port: the port number used for SFTP (usually 22)
- Username: the username used to access the SFTP server
- Password: the password associated with the username
- Private Key: (optional) the private key used for authentication
- Passphrase: (optional) the passphrase associated with the private key
- Path: the path to the directory containing the files to be synced
5. Click on the "Test" button to ensure that the connection is successful.
6. If the test is successful, click on the "Create Connection" button to save the connection.
7. Once the connection is created, you can configure the sync settings by selecting the desired sync mode (full refresh or incremental) and setting the sync schedule.
8. Finally, click on the "Create" button to start the sync process.

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.

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.

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.

Start moving SFTP Bulk data today

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

Try it freeTalk to sales