# FTP

## Overview

DBSync's FTP (File Transfer Protocol) connector enables secure and automated integration. It allows users to exchange files with an **FTP/SFTP file server**. This connector can be utilized to perform various operations, including downloading files from an FTP server, uploading files to an FTP server, reading multiple files, and writing to one or more files.

## Key Benefits

**For Business Users:**

* **Automated File Transfers:** Eliminates manual FTP uploads/downloads.
* **Reliable Workflows:** Schedules file transfers and trigger downstream processes automatically.

**For Technical Teams:**

* **Secure Connectivity:** Supports standard FTP as well as encrypted SFTP (SSH File Transfer Protocol).
* **Flexible Operations:** Enables file uploads, downloads, and transfers from one directory to another within a file system.
* **Automated File Backups:** Reduces manual intervention by automating file backups from any CRM or accounting system to a remote FTP server.

## Prerequisites

Before configuring the FTP Connector, ensure the following requirements are met:

1. **DBSync Access**

* A valid license for this connector and access to the DBSync Cloud Workflow platform.

2. **FTP/SFTP Server**

* Have sufficient read/write permissions for the required directories on the FTP server.

**Data Transfer**

The DBSync FTP connector enables bidirectional data transfer with FTP servers.

To transfer data from an FTP server to another source, define an FTP Action that describes where the data resides.

To transfer to an FTP server, first define one or more FTP Actions that describe where to store the data.

**Notes:**

* When the FTP Connector is used to transfer a file, the data is transferred in-memory to the FTP server, and nothing is registered on Cloud Workflow.

## Connector Configuration

Each connector instance represents a connection to one FTP/SFTP server. To connect to multiple FTP/SFTP servers (for example, dev and production), create independent connection instances with unique names.

### Connection Parameters

| Property             | Description                                                                 | Required | Default Values    |
| -------------------- | --------------------------------------------------------------------------- | -------- | ----------------- |
| HostName             | The hostname or IP address of the FTP server.                               | Yes      | ftp\://hostname   |
| Port Number          | The port number for the connection (default is 21 for FTP, 22 for SFTP).    | Yes      | FTP: 21, SFTP: 22 |
| UserName             | The username for the FTP server account.                                    | Yes      |                   |
| Password             | The password for the FTP server account.                                    | Yes      |                   |
| Folder               | The folder path for reading/writing files (no leading or trailing slashes). | Yes      |                   |
| Mode                 | FTP connection mode: Passive or Active.                                     | No       |                   |
| File Type            | File transfer type: ASCII or Binary.                                        | No       |                   |
| Enable Remote Server | Enables the use of a remote server.                                         | No       |                   |
| Use SSH              | Enables the use of SSH for secure connections.                              | No       |                   |

Once connected, the server will be available for use in workflow tasks involving file operations.

## Quick Setup Guide

{% stepper %}
{% step %}

### Login to DBSync Cloud Workflow

* Access the platform with your DBSync credentials.
  {% endstep %}

{% step %}

### Add the FTP Connector

* Navigate to the connectors list in the Apps pane and select **FTP Connector** from the Apps list.
  {% endstep %}

{% step %}

### Configure the Connector

Provide the required configuration details:

* **HostName:** Enter the FTP server's hostname or IP address.
* **Port Number:** Specify the port number (default is 21 for FTP).
* **UserName:** Provide the username for the FTP server.
* **Password:** Enter the password for the FTP server.
* **Folder:** Define the folder where files will be read from or written to. Use “.” for the root or specify a subfolder (For example, */inbound*, */outbound*).

Additionally, provide one or more of the following optional properties:

* **Mode:** Choose between *Passive* or *Active* data transfer mode for the FTP connection. *Passive* is recommended as it works well with firewalls and NAT configurations. Use *Active* only if your FTP server requires it.
* **File Type:** Specify the file type (*Binary* or *ASCII*). Controls how file data is transferred.
  * *ASCII***:** For text-based files like .csv or .txt.
  * **Binary:** For non-text files like images, executables, or zipped data.
* **Use SSH Keys for Authentication**
  * Enable this option if your FTP server uses SSH key-based authentication (for SFTP).
  * It enhances security by using public/private key pairs instead of a password.
* **Enable Remote Server Public Key**
  * Enable this option to validate the remote server’s SSH key during connection.
  * It adds an extra layer of security by verifying the server identity, preventing attacks (for SFTP connections).

    <figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FLKn46zjHPb2ML0jkrCKX%2Fimage.png?alt=media&#x26;token=39c7cf4e-d2ea-41f4-b871-a7e16b7ee7f7" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}

### Test Connection

* Use the **Test Connection** button to verify connectivity and access rights.
  {% endstep %}

{% step %}

### Save Configuration

* Once validated, save the connector configuration.
  {% endstep %}
  {% endstepper %}

After setup, the FTP/SFTP server is available for file operations in workflows and automation tasks.

**PRO TIP**

When configuring the FTP Connector, always use secure FTP (SFTP) when handling sensitive data to ensure secure file transfers.

## Frequently Asked Questions (FAQ)

<details>

<summary>Can I connect to multiple FTP servers?</summary>

Yes, create separate connector entries for each FTP/SFTP server you need to integrate.

</details>

<details>

<summary>Does the FTP connector support bi-directional data flow?</summary>

Yes, the FTP connector can be configured for both bi-directional and uni-directional data transfers.

</details>

<details>

<summary>How frequently can data be synced with an FTP server?</summary>

Data can be synced every minute.

</details>

<details>

<summary>Is the FTP connector available for both on-demand and on-premise versions?</summary>

Yes, the FTP connector can be used with both on-demand and on-premise versions of DBSync Cloud Workflow.

</details>

<details>

<summary>Can the FTP connector handle large files?</summary>

Yes, the FTP connector is designed to handle large files. However, the performance may vary based on the size of the files and the available network bandwidth.

</details>

<details>

<summary>Is SFTP supported?</summary>

Yes, the connector supports SFTP (Secure FTP) in addition to standard FTP.

</details>

<details>

<summary>Are credentials stored securely?</summary>

Yes, DBSync securely stores and encrypts all FTP credentials.

</details>

<details>

<summary>Can workflows be triggered based on file changes?</summary>

Workflows can be configured to poll and check for file presence or arrival, which can then initiate processing tasks.

</details>

<details>

<summary>What if my FTP server uses SSH key authentication?</summary>

SSH key authentication is supported for SFTP - upload your private key in the connector setup.

</details>

## Related Content

* [Why You Should Automate with FTP/FTPS](https://www.mydbsync.com/workflow/ftp-ftps): Automating file transfers using FTP or FTPS in DBSync Cloud Workflow ensures secure and reliable data exchange between your systems.&#x20;

* [Salesforce and FTP/S Integration](https://www.mydbsync.com/workflow/ftp-and-salesforce-integration): Integrate Salesforce with FTP/S using DBSync to automate the exchange of data between your Salesforce environment and external file systems.

* [FTP Action](https://docs.mydbsync.com/cloud-workflow/create-your-workflow/actions/storage/ftp): use FTP connector in combination with FTP Action

## Summary

The **FTP Connector** in **DBSync Cloud Workflow** provides a powerful and secure way to integrate traditional FTP and secure SFTP servers into modern business workflows. With support for core file operations, flexible configuration, and automation capabilities, this connector helps organizations modernize file exchange processes and automate data movement across systems.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.mydbsync.com/cloud-workflow/2026_connectors_new/ftp.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.