MySQLDataWriter is a high-speed MySQL table loader. It uses MySQL native client.
|Component||Data output||Input ports||Output ports||Transformation||Transf. required||Java||CTL||Auto-propagated metadata|
MySQLDataWriter does not propagate metadata.
Error Metadata cannot use Autofilling Functions.
Table 56.5. Error Metadata for MySQLDataWriter
|Field number||Field name||Data type||Description|
|0||<any_name1>||integer||The number of incorrect record (records are numbered starting from 1).|
|1||<any_name2>||integer||The number of incorrect column.|
|The path to MySQL utility||yes||The name of MySQL utility, including the path. Must be installed and configured on the same machine where CloverETL runs. The MySQL command line tool must be available.|
|Host||Host where the database server is located.||localhost (default) | other host|
|Database||yes||The name of the database into which the records should be loaded.|
|Database table||yes||The name of the database table into which the records should be loaded.|
|User name||yes||Database user.|
|Password||yes||The password for a database user.|
|Path to control script||The name of a command file containing the |
|Lock database table||
By default, a database is not locked and multiuser access is allowed.
If set to ||false (default) | true|
|Ignore rows||The number of rows of a data file that should be skipped. By default, no records are skipped. Valid only for input file with data.||0 (default) | 1-N|
|Column delimiter||The delimiter used for each column in the data. Field values must not include this delimiter as their part. By default, a tabulator is used.||\t (default) | other character|
|Loader input file||||The name of an input file to be loaded, including path. For more information, see Loader input file.|
|Parameters||All parameters that can be used as parameters by the
MySQLDataWriter loads data into a database table using native MySQL database client.
It reads data either from the input port or from an input file.
You can attach the optional output port and read records which have been reported as rejected.
Reading from input port (input port connected)
dumps the data into a temporary file which is then used by
utility. You can set the temporary file explicitly by setting the
Loader input file attribute or leave it blank to use default.
Reading from a file (no input connected)
uses the Loader input file attribute as a path to
your data file. The attribute is mandatory in this case.
The file needs to be in a format recognized by the
utility (see MySQL LOAD DATA).
This component executes the MySQL native command-line client
The client must be installed on the same machine as the graph is running on.
MySQLDataWriter is a bulk loader suitable for
uploading many records to database.
To insert several records, you can also use DBOutputTable,
which does not require
The name of a command file containing the
INFILE statement (See MySQL LOAD DATA),
If it is not set, the command file is created in CloverETL temporary directory and it is deleted after the load finishes.
If it is set, but the specified command file does not exist, a temporary command file is created with the specified name and path and it is not deleted after the load finishes.
If it is set and the specified command file exists, this file is used instead of command file created by CloverETL.
The name of an input file to be loaded, including the path.
If it is not set, a loader file is created in CloverETL or OS temporary directory (on Windows) or stdin is used instead of temporary file (on Unix). The file is deleted after the load finishes.
If it is set, a specified file is created. It is not deleted after data is loaded and it is overwritten on each graph run.
If the input port is not connected, this file must be specified, must exist and must contain data that should be loaded into the database. The file is not deleted nor overwritten.
You should not write maps and lists.