Devart MySql Destination

Devart MySql Destination component loads data into MySQL tables. It has the following custom properties:

Property

Description

BufferSize

The maximal size of a data packet sent to the server. Default value is 262144.

BulkInsertDelayed

Determines whether to use INSERT DELAYED statement syntax. Default value is False.

BulkInsertLock

Determines whether to execute the LOCK TABLE statement before loading the data. Default value is False.

Operation

A DML operation to apply to the target object. Default value is BulkInsert. The following values are supported:

•	Insert - This is the most common operation.

•

Update - Devart MySql Destination component in the Update mode enables updating data in a data source. Peculiarity of this action consists in the fact, that performing it requires using primary key values of the target table (the Id value for cloud sources). Thus, when performing an update, you must know and specify the primary key values of the target table to update a record.

•	Delete - Devart MySql Destination component in the Delete mode enables deleting data from a data source. As well as for the update operation, you must know and specify the primary key values of the target table to delete a record.

•	BulkInsert - Devart MySql Destination component uses INSERT statements that insert data by several rows at the same time.

RetryCount

The number of times to retry loading the data in case if it fails. Default value is 5.

RetryInterval

The number of seconds before repeating an attempt to load data. Default value is 1.

TableName

The name of a MySQL database object to load data into.