2022
Overview
The DBSync's File connector implements a file transport channel so that file on the local file system, 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 bases on the conditions provided through mappings.
Prerequisites
To establish a connection to one of the files within a local file system, user must:
- Have a valid license to DBSync File connector, username and password to connect to DBSync iPaaS platform.
- The file, that is read from and or written to, should have permissions for the File connector to access the file.
Connector Configurations
This 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 configure accordingly. The following table lists parameters, required for opening the connection to a file, that is configured through a File connector.
Following table gives out various attributes/properties of File connector:
Property | Description | Required |
|---|---|---|
Columns | The columns are the header in the file that should be comma separated. | Yes |
This section lists Trigger properties that need to be set in the Trigger section of DBSync. 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 | 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 200. | Yes |
Has header | Specifies the header of CSV file from which they are read/written to. | Yes |
Format | Specify the file type Eg: CSV | Yes |
The 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 | 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 200. | Yes |
Format | Specify the file type Eg: CSV | Yes |
AutoCreate | The default value has to be '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 |
Supported File Types
File connector supports the following types:
- CSV format
- XLS format
Useful hint
Overview
Content Tools