Message-ID: <1399546983.86035.1711650425873.JavaMail.wiki@ip-172-26-1-188> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_86034_1787648405.1711650425871" ------=_Part_86034_1787648405.1711650425871 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The DBSync's File connector implements a fi= le transport channel so that file on the local file system, that is configu= red, 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 cond= itions provided through mappings.
Prerequisites
To establish a connection to one of the files within a local file s= ystem, user must:
This section lists properties that need to be set during File conne= ctor creation in DBSync. If a user wishes to connect to multiple files= , create a separate connection for each and configure accordingly. The foll= owing 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 connecto= r:
Property |
Description |
Required |
---|---|---|
Columns |
The columns are the header in the file that s= hould be comma separated. |
Yes |
This section lists Trigger properties that need to be set in the Tr= igger section of DBSync. Following table lists varied attributes/prope= rties 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 b= e 200. |
Yes |
Has header |
Specifies the header of CSV file from which t= hey are read/written to. |
Yes |
Format |
Specify the file type Eg: CSV |
Yes |
The following table lists the additional properties that are required wh= ile 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 b= e 200. |
Yes |
Format |
Specify the file type Eg: CSV |
Yes |
AutoCreate |
The default value has to be 'Yes'. It is usef= ul 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:
Useful hint