FTP

Prerequisites

Before configuring the FTP Target Connector, ensure the following:

• A valid DBSync Cloud Replication license and login credentials.

• Access to a configured FTP server.

• FTP server details:

  • Hostname or IP address

  • Port number (default: 21 for FTP)

  • Valid username and password

• Target directory path on the FTP server with write permissions.

• Network access between DBSync and the FTP server (firewall rules configured if required).

• Passive mode is enabled on the FTP server if operating behind a firewall (recommended).

Steps to Configure FTP

Step 1: Click Add App and create a desired profile.

Step 2: Click the profile you created, then navigate to the Database tab and select FTP to begin configuration

Enter the required FTP server details:

Configure the FTP Connector

Enter the required configuration details:

• Host: Enter the FTP server's hostname or IP address.

• Port Number: Specify the port number (default is 21 for FTP).

• User Name: Provide the username for the FTP server.

• Password: Enter the password for the FTP server.

• Directory Path: Defines the folder where files will be read from or written to. Use . for the root or specify a subfolder (e.g., /inbound, /outbound).

Optional properties

• Mode: Choose between Passive or Active for the FTP connection. The data transfer mode. Passive is recommended as it works well with firewalls and NAT configurations. Use Active only if your FTP server requires it.

• Batch Size – Enter the number of records per batch (Default: 1000)

  • Maximum batch size limit: 10000

• Select Separator – Choose Comma (,) or preferred delimiter

• Add Header to CSV – Enable this option to include column headers in the output file

• Select Data type: Choose the desired format (CSV/Parquet) for saving your data in FTP Storage. This option determines the format of the data saved in FTP.

How to validate your FTP server credentials using an FTP client.

Follow these steps:

• Open your FTP connector.

• Enter the following details:

• Host – FTP server hostname or IP address

• Username – FTP login username

• Password – FTP login password

• Port – Default: 21

• Click Quickconnect.

• Verify that the connection is successful.