The DBSync's File connector implements a file transport channel so that file on the local file system which is configured can be read from and written to. This connector can be configured to filter the files it reads from. The filter can also be applied when writing to a file so that the output can be appended to the file basing on the conditions provided through mappings.
Prerequisites
To establish a connection to one of the files within local file system, user has to do the following
This section gives out the properties that need to be set during File connector creation in DBSync. If a user wishes to connect to multiple files, create a separate connection for each and make the configurations accordingly. The below table represent parameters required for opening the connection to file which is configured through File connector.
The table below gives out the various attributes/properties of File connector.
Property | Description | Required |
---|---|---|
Columns | The columns are the header in the file which should be comma separated. | yes |
This section gives out Trigger properties that need to be set in the Trigger section of DBSync. The table below gives out the varies attributes/properties of a File connector
Property | Description | Required |
---|---|---|
Filename | Name of the file from which you want to read or write to | yes |
Batchsize | The batch size is the speed with which files are read from the file or inserted in a file. The ideal batch size should be given as 200. | yes |
Hasheader | Specifies the header of CSV file which from which they are read/ written to | yes |
Format | Specify the file type Eg: CSV | yes |
The below table lists the additional properties that are required while updating the source.
Property | Description | Required |
---|---|---|
Filename | Name of the file from which you want to read or write to | yes |
Batchsize | The batch size is the speed with which files are read from the file or inserted in a file. The ideal batch size should be given as 200. | yes |
Format | Specify the file type Eg: CSV | yes |
AutoCreate | The default value has to be yes and is useful while writing to a file from source. The File connector will detect the header from the source and inserts it for you | yes |
Supported File Types
The File connector supports only following types of files to read or written to
Q: Does File 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 of the supported file types?
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 File connector can be used both on-demand and on-premise versions of DBSync Cloud Workflow
Q: How can I try File connector before purchasing the license?
A: We have a free trial for 15 days after going through the sign-up process.