The DBSyncs FTP (File Transfer Protocol) connector implements a file transport channel that allows the DBSync to exchange files with an FTP server. This FTP connector can be used to:
- download the file from an FTP server
- upload files to an FTP server,
- read one or more files, and
- write to a file or more files.
What is FTP
File Transfer Protocol or FTP is a network protocol used to transfer computer files between a client and a server.
It has an extension, named FTPS, which allows for the encryption of the sessions. It uses a different port (see table below).
In order to establish a connection to an external File Transfer Protocol server, the user needs the following:
- Have a valid license to DBSync FTP connector, username and password to connect to DBSync iPaaS platform.
- An FTP user with sufficient permission to read/write to the required directories.
The DBSync FTP connector allows you to tranfer data from and to an FTP server.
In order to transfer data from an FTP server to another source, you need to define a Trigger that describes where the data resides.
In order to tranfer to an FTP server, you need to define one or more Rules that describe where to store the data
- When the FTP Connector is used to transfer a file, the data is transfered in-memory to the ftp server, and nothing is registered on Cloudworkflow.
- It is possible to connect to several FTP servers. However, each connection requires a separate conector.
The following table describes the parameters needed to define an FTP connector:
The HostName of the FTP server, by default we provide file protocol as FTP and in case if the user wishes to change to
DBSync supports only below given protocols.
FTP, SFTP, FTPS
The port number of the FTP server . By default for plain file protocol the port number should be 21 and for secured protocol it is 22
The username of the FTP server
The password of the FTP server
The folder path from where the files should be read or written. If slash is given at the start of the path then connector picks
The columns are the header in the file which should be comma separated
|Delimiter||Delimiter indicating separation of data. For example a comma.|
|Remote server||Enables the use of a remote server|
|Use SSH||Enables the use of SSH, also known as Secure Socket Shell, is a network protocol that provides administrators with a secure way to access a remote computer.|
The following table describes the Trigger properties of an FTP connector that need to be defined when sending data from the FTP server to another source..
This property enables the data to be stored in-memory during file Transfers. There are two possible values i.e. Session
InMemory means that the transferred values are held in the cache. Session means that the stored values are held in the session
DBSync FTP connector enables you to dynamically select the inbound file directory via Trigger property Section
|File Has Header||Indicates that the file has a header.||optional|
|Post Processing||Enables the execution of Shell commands after completing the data transfer process.||optional|
The following table describes the Rule properties that need to be defined when sending data to an FTP server.
FTP has a two different ways to establish a data connection between FTP server and it's client. The two modes are reffered to as
The property is the file type and there are two types i.e. First one is binary and the other one is ASCII
File name signifies the target file name which is set for two purposes
The batch size is the speed with which files are inserted into target system. By default the DBSync will pass this as 200
Directory to store the file on to the Target FTP server
Uses Of FTP Connector
- Automated file backups by decreasing the manual intervention from any CRM, Accounting system to a remote FTP server.
- Post processing of files from one directory to another directory within a file system.
- An example of usage of the FTP connector can be found in the following article:
Frequently Asked Questions
Q: Does FTP connector support Bi-directional data flow?
A: Yes, and you also have the control to make it uni-directional if you chose.
Q: How frequently one can sync the data if reading from or writing to any FTP server?
A: The sync can be performed every five-minute interval of time.
Q: Is this connector available with both on-demand and on-premise versions?
A: Yes, the FTP connector can be used both on-demand and on-premise versions of DBSync Cloud Workflow
Q: How can I try FTP connector before purchasing the license?
A: We have a free trial for 15 days after going through the sign-up process.