Description
The Database Export node is used to export data into an external database.
Configuration Options
Basic Configuration Options
| Setting |
Description\Parameters |
Database Connection |
The database to query against. These connections can be configured in the Databases dialog. |
Table Name |
Name of the table to create/update. |
Write Mode |
Mode in which to update the above table. Options include Recreate,Insert,Create,Truncate. |
Batch Commit |
Whether or not to commit to the database in batches. |
Batch Commit Size |
Size of the batches to commit. |
Advanced Configuration Options
Create an index on the output table on selected column(s)
| Setting |
Description |
Index |
Name of the index to create. If this index already exists in the table, it is overwritten. |
Columns |
Output columns to build the index on. |
Actions
| Action |
Description |
Preview |
After configuring the node, the source data can be previewed by clicking the Preview button. If not using a data type template, be sure to Infer Data Types. |