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.encoding
Separator of values. Default value: 0x1E (Information separator two - U+001E)	com.denodo.vdb.util.tablemanagement.sql.insertion.DFInsertWorker.fieldSeparator
Quote character. Default value: 0x1F (Information separator one - U+001F)	com.denodo.vdb.util.tablemanagement.sql.insertion.DFInsertWorker.quoteCharacter
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.rowSeparator

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.