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 File Connector

File Connector

=20
=20
=20
=20

Overview 

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.


Connector Configurations

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


=20
=20
=20
=20 =20
=20
------=_Part_86034_1787648405.1711650425871--