MySQL Writer Activity¶
MySQL Writer Activity writes specified view contents to MySQL table.
Parameters¶
Name |
Description |
Type |
Default |
---|---|---|---|
Title |
Title of the activity to display on the designer. |
text |
|
Host Name |
Name or address of the server where MySQL database is hosted. |
text |
|
Port |
Port number which MySQL database is configured with. |
int |
3306 |
Database Name |
Name of the database. |
text |
|
User Name |
Valid MySQL user name.
Consider using vault feature with templating (e.g. |
text |
|
Password |
Password associated with above user. Consider
using vault feature with templating (e.g. |
text |
|
Source View |
Name of the DataRow view which is going to be written into MySQL table. |
text |
|
Bulk Insert |
Use bulk insert feature of target database (experimental feature). |
boolean |
false |
Batch Size |
Write batch size. |
int |
1000 |
Mode |
Write mode. Please see blow for list modes and their meanings. |
enum |
error |
Pre Script |
SQL script to execute before the data write. |
text |
|
Post Script |
SQL script to execute after the data write. |
text |
|
As |
Target MySQL table name. |
text |
|
Options |
Additional options. |
key-value |
Supported Write Modes¶
Name |
Description |
---|---|
error |
Fail if table already exists. |
append |
Append to existing table or create new. |
overwrite |
Overwrite existing table or create new. |
ignore |
Ignore if table already exists or create new. |