Description
The Database Export node exports data into an external database.
Configuration Options
Basic Configuration Options
| Setting |
Description\Parameters |
Database Connection |
The database to query against. These connections are configured in the Databases dialog. |
Table Name |
Name of the table to create/update. |
Write Mode |
Table options are Recreate, Insert, Create, Truncate. |
Batch Commit |
Option 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. Any existing table index will be overwritten. |
Columns |
Output columns to build the index on. |
Actions
| Action |
Description |
Preview |
Once the node is configured, the source data can be previewed at any time. If not using a data type template, be sure to Infer Data Types. |