Use the DataInsert node to make DataInsert
mappings, which create and populate new database records. You cannot use this
node to delete or update information that is currently held in an existing
database field; to do this, use either a DataDelete node
or a DataUpdate node respectively.
In a default generated DataInsert mapping, each value of a repeatable element
instance is inserted into the selected column in a row. The number of inserts
depends on the number of instances.
- For a many-to-one mapping, a row is
inserted into the selected column. The value in the column is the result of
the scalar operation performed on the selected message elements.
- For a one-to-many mapping a row is inserted
into the selected columns. The value in the columns is that of the selected
message element.
- For a many-to-many mapping, a single
row is inserted into the selected columns. The value in each column is the
result of the scalar operation that is performed on the selected message elements.
The scalar operation can be different for each column.
One-to-one mappings are also allowed;
in this case, the value that the target column takes is the value of the mapped
input element. These insert statements can also be combined to produce a single
operation that inserts several columns into the same row, as each insert statement
creates a new row.
There are two ways to carry out this operation:
- Highlight the selected elements in the Outline perspective
and click .
- Right-click the selected items in the Outline perspective
and click Combine to same row,
then click either Keep selected mappings to
merge the selected items, or Remove
selected mappings to delete the selected items.