Database

Article summary

Did you find this summary helpful?

Thank you for your feedback

Description

The Database Export node exports data into an external database.

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.

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.

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`.

Was this article helpful?

Table of contents