SQL Data Manipulation

Description

Performs data manipulation in databases with INSERT, UPDATE and DELETE commands.

This function is used similarly to the JDBC Output but the Flow can continue afterwards. 

Using the DELETE and UPDATE commands permanently change the data at the source.

Use

  • Select an argument. (Any)
    • Additional arguments can be added.
  • Enter an output field name.
  • Select a JDBC Connection from the drop-down list.
  • Enter an SQL statement beginning with INSERT, UPDATE, or DELETE.
  • Click OK.

Type

Formulas