Settings of the Generation of the Temporary Files

When Virtual DataPort uses the proprietary interface of the database to load data in bulk, first, it writes the data to a delimited file that is deleted once is transferred to target database.

The following properties define several aspects of these temporary delimited files:

Settings of the generation of the temporary files for bulk data load
Meaning Property name

Encoding of the file.

Default encoding: UTF-8

com.denodo.vdb.util.tablemanagement. sql.insertion.DFInsertWorker.encodin g

Separator of values.

Default value: 0x1E (Information separator two - U+001E)

com.denodo.vdb.util.tablemanagement. sql.insertion.DFInsertWorker.fieldSe parator

Quote character.

Default value: 0x1F (Information separator one - U+001F)

com.denodo.vdb.util.tablemanagement. sql.insertion.DFInsertWorker.quoteCh aracter

Row separator

Default value: 0x1E followed by the end of line of the platform where the Virtual DataPort server is running.

com.denodo.vdb.util.tablemanagement. sql.insertion.DFInsertWorker.rowSepa rator

To change its value, use the administration tool to login with an administrator account and from the VQL Shell, execute this:

SET '<name of the property>' = '<new value>';

For example:

SET 'com.denodo.vdb.util.tablemanagement.sql.insertion.DFInsertWorker.encoding'
    = 'UTF-16';

Additionally, you can change these settings for a specific database adapter instead of for all of them. That is, you can change the encoding of the files that will be written in Oracle, but leave the default encoding for the rest.

To do this, add the name of adapter after DFInsertWorker., followed by a dot. For example,

SET 'com.denodo.vdb.util.tablemanagement.sql.insertion.DFInsertWorker.oracle.encoding'
    = 'UTF-16';

The name of the adapter is the value of the parameter DATABASENAME of the CREATE DATASOURCE JDBC statement that created the data source. You can check this name in the dialog “VQL” of the data source.