Output
ODBC Output
Writes the rows that reach it into an existing table through ODBC, in one transaction, and passes them on unchanged.
When to use it
Use it to load data into a database reached by ODBC.
In a pipeline
File InputType ConversionODBC Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Append daily orders
- Target Table=dbo.orders
- Write Mode=Append rows
| order_id | total |
|---|---|
| 79 | 250 |
| 80 | 64 |
| order_id | total |
|---|---|
| 79 | 250 |
| 80 | 64 |
Worth knowing
- Auto-commit is off: every statement of the node commits together, or none does.
- Upsert deletes the incoming keys first, then inserts, in the same transaction.
- Previews never write.