2022
The DBSyncs DBSync's FTP (File Transfer Protocol) connector implements a file transport channel so that the DBSync iPaaS can . It allows DBSync to exchange files with an external FTP server. The FTP connector can download be used to:
Prerequisites
ToFile Transfer Protocol (FTP) is a network protocol used to transfer computer files between a client and a server.
It has an extension named FTP that allows for encryption of sessions and uses a different port (explained below).
Prerequisites
In order to establish a connection to an external File Transfer Protocol server, user has to do the followingthe user must:
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.The DBSync FTP connector allows you to transfer 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 transfer to an FTP server, you need to define one or more Rules that describe where to store the data.
Notes:
The following table describes the parameters needed to define an FTP connector:
Property | Description | Required | Default Values |
---|---|---|---|
HostName | The HostName of the FTP server, by default By default, we provide file protocol as FTP and in case if the a user wishes to change to DBSync supports only below given protocols. | yesYes | FTP, SFTP, FTPS |
Port The port number of the FTP server . Number | By default, for plain file protocol, the port number should be 21; and, for secured protocol, it is should be 22. | yesYes | FTP: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 there is a slash is given at the start of the path then, connector picks | Yes | |
Columns | The columns are the header in the file which . The file should be comma separated (CSV). | 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 DBSyncDelimiter | Delimiter indicates separation of data. For example a comma is one of the delimiters. | ||
Enable | |||
Remote server | Enables the use of a remote server. | ||
Use SSH | Enables the use of SSH - also known as Secure Socket Shell. It 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 needs to be defined when sending data from the FTP server to another source.
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 | yes | session | - (1) Session; InMemory means that the transferred values are held in cache. Session means that the stored values are held in the session. | Yes | Session |
Directory | DBSync FTP connector enables you to dynamically select the inbound file directory via Trigger property Section. | optional |
Optional | |||
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 | |
Regular Expression | Enables to select all similar files on the server location for processing. Example: ^([a-zA-Z]:\\)?[^\x00-\x1F"<>\|:\*\?/]+\.[a-zA-Z]{3,4}$ matches a valid Windows file name. | Optional |
The Query Builder is a tool that allows you to define a specific SQL query. As a result, you can create queries that are tailored to your needs.
The following table describes the Rule properties that need to be defined when sending data to an FTP server.
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 | yesYes | passivePassive |
File Type | The property is the file type and there are two types i.e. First one is binary and the other one is ASCIIyes- namely, Binary and ASCII. | Yes | ASCII |
File Name | File name signifies the target file name which is set for two purposes purposes:
| optionalOptional | |
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. | optionalOptional | |
Directory | Directory to store the file on to the Target FTP server. | optionalOptional |
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.
Write Header | Boolean value indicating if the header should be written or not. | Optional | False |
Uses of the FTP Connector
Q: Does FTP connector support Bi-directional data flow?
A: Yes, and you also have the control to Furthermore, if you so choose, you can also 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 at every five-minute interval of time.
Q: Is this connector available with both on, On-demand and onOn-premise, versions?
A: Yes, the FTP connector can be used with both on, On-demand and onOn-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.
Info | ||
---|---|---|
| ||