...
Note: This step actually does not work within a Windows system due to the use of mkfifo for named pipes. If you like, check out to use the GNU Core Utilities for Windows (but this is not official officially supported).
Options
Option | Description |
|---|---|
Step name | Name of the step. |
Connection | Name of the database connection on which the target table resides. |
Target schema | The name of the Schema for the table to write data to. This is important for data sources that allow for table names with dots '.' in it. |
Target table | Name of the target table. |
Fifo file | This is the fifo file used as a named pipe. When it does not exist it will be created with the command mkfifo and chmod 666 (this is the reason why it is not working in Windows). |
Delimiter | Delimiter for the fields. (If not given, the tabulator is default.) |
Enclosure | The enclosure used for strings. |
Escape character | If the enclosure is in the field, it is escaped by the escape character. |
Character set | The used character set (optional). |
Bulk size (rows) | To split the data loads in chunks of data after which the data load will be restarted. |
Use replace clause? | If checked, "REPLACE" is added to the command. If you specify, input rows replace existing rows. In other words, rows that have the same value for a primary key or unique index as an existing row. More details can be found in the MySQL reference. |
Use ignore clause? | If checked, "IGNORE" is added to the command. If you specify, input rows that duplicate an existing row on a unique key value are skipped. More details can be found in the MySQL reference. |
...