Skip to main content
Version: Current

Insert Records

Description​

The Insert Records activity inserts one or more new records into a specified database table. It enables automated, reliable data persistence during workflow execution.

Common Capabilities​

Process Data Support​

info

This activity supports dynamic configuration using variables from the Process Data drawer.

You can bind values from Model Data, Form Data, System Data, Enterprise Variables, and Activity Outputs.

Learn more → Using Process Data

Design-Time Configuration​

The following properties must be configured at design time to ensure that the activity connects to the correct database and inserts data accurately.

Connection Type​

Specifies the database type (for example, SQL Server, Oracle, or MySQL). Selecting the correct type ensures compatibility with the target database engine.

Connection Name​

Select the name of a preconfigured database connection. This connection defines the server, credentials, and security settings used to access the database.

Schema​

Specifies the database schema that contains the target table.

Table Name​

Specifies the name of the database table into which records will be inserted.

Column Mapping​

Defines how workflow data is mapped to database table columns using the   Schema Mapper.   Each mapped field represents a column value to be inserted into the target table.

Timeout​

Specifies the maximum time (in seconds) that the activity will wait for the insert operation to complete.   The default value is 600 seconds.

Outputs​

Affected Records Count​

Returns the number of records successfully inserted into the target table.

This value can be used for:

  • Validation
  • Reporting
  • Driving conditional workflow logic

Wait All Incoming​

Execution Control

Controls how this activity behaves when multiple incoming execution paths converge.

Determines whether the activity executes when:

  • any incoming path completes, or
  • all relevant paths have completed before execution

Learn more → Execution Control

On Error​

Error Handling Strategy

Defines how the workflow behaves if this activity encounters a runtime error.

Supported strategies include Fault, Continue, Suspend, and Retry.

Learn more → Error Handling