Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview 

The DBSync's File connector implements a file transport channel so that file on the local file system which , that 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 bases on the conditions provided through mappings.


Prerequisites

To establish a connection to one of the files within a local file system, user has to do the followingmust:

  • Have a valid license to DBSync File connector, username and password to connect to DBSync iPaaS platform.
  • The file which , that is read from and or written to, should have permissions for the File connector to access the file.

Connector Configurations

This section gives out the section lists 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 configure accordingly. The below following table represent lists parameters, required for opening the connection to a file which , that is configured through a File connector.

The Following table below gives out the various attributes/properties of File connector.:

Property

Description

Required

Columns

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

yesYes

This section gives out section lists Trigger properties that need to be set in the Trigger section of DBSync. The table below gives out the varies  Following table lists varied attributes/properties of a File connector:

Property

Description

Required

Filename

Name of the file from which you want to read or write to

yesYes

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.

yesYes

HasheaderHas header

Specifies the header of CSV file which from which they are read/written to.

yesYes

Format

Specify the file type

Eg: CSV

yesYes

The below following 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    

yesYes

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.

yesYes

Format

Specify the file type

Eg: CSV

yesYes

AutoCreate

The default value has to be yes and 'Yes'. It 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

Yes


Supported File Types

The File connector supports only following types of files to read or written to to: 

  • CSV format
  • XLS format
  • XLSX format

Frequently Asked Questions

Q: Does File connector support Bi-directional data flow?

A: Yes. Furthermore, and if you also have the control to 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 of the supported file types?

A: The sync can be performed at every five-minute minutes interval of time.

Q: Is this connector available with both on, On-demand and onOn-premise, versions?

A: Yes, the . The File connector can be used both on, On-demand and onOn-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.