Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Overview 

The DBSyncs FTP (File Transfer Protocol) connector implements a file transport channel so that the DBSync iPaaS can exchange files with an external FTP server. The FTP connector can download the file from an FTP server and even upload files to an FTP server. This connector can also be used to read file/files and also for writing to existing file/files.


Prerequisites

To establish a connection to an external File Transfer Protocol server, user has to do 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.

Connector Configurations

This section gives out the properties that need to be set during FTP connector creation in DBSync. If a user wishes to connect to multiple FTP servers, create a separate connection for each and make the configurations accordingly. The below table represent parameters required for opening the connection to FTP server which is configured through FTP connector.

The table below gives out the various attributes/properties of FTP connector.

Property

Description

Required

Default Values

HostName

The HostName of the FTP server,  by default we provide file protocol as FTP and in case if the user wishes to change to
anything else the below is the format which need be used.

DBSync supports only below given protocols.

ftp://hostname \\

sftp://hostname
ftps://hostname

yes

FTP, SFTP, FTPS

Port

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

yes

FTP:21
SFTP:22
FTPS:990/21

UserName

The username of the FTP server

Yes


Password

The password of the FTP server

Yes


Folder

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 
it as a root folder of ftps protocol
Note : There shouldn't to be no slashes at the start or end of the folder path

Yes


Columns

The columns are the header in the file which should be comma separated

Optional



After a connector is created within a project, set up the connector within the project. DBSync can map to and from the systems which are supported by our standard connector list and use FTP connector to retrieve file/files from or send file/files to FTP server. Click on the following link to know which all connectors we support Connectors List.

This sections gives out Trigger properties of FTP connector that need to be set from Trigger section of  DBSync.

Property

Description

Required

Default Value

Store

This property enables the data to be stored in-memory during file Transfers. There are two possible values i.e. Session 
and InMemory

yes

session

Directory

DBSync FTP connector enables you to dynamically select the inbound file directory via Trigger property Section

optional



This section gives out Rule properties for FTP connector that need to be set during the Rule setup in DBSync. 

Property

Description

Required

Default Values

Mode

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 
PASV(passive) and PORT mode.

yes

passive

File Type

The property is the file type and there are two types i.e. First one is binary and the other one is ASCII

yes

ASCII

File Name

File name signifies the target file name which is set for two purposes 

  1.  If a new file to be created on the target FTP server then user need to fill in the text area as @ Filename @ and can specify the file name of his choice 
  2.  If data has to be appended to the existing file then leave this field blank

optional


Batch Size

The batch size is the speed with which files are inserted into target system. By default the DBSync will pass this as 200

optional


Directory

Directory to store the file on to the Target FTP server

optional


Data Transfer

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.

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.

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.


  • No labels