Skip to main content
Version: Current

Insert Record

Description​

The Insert Record activity inserts a single record into a specified database table.

It allows values from workflow data and activity outputs to be mapped to columns in the target table, making it suitable for inserting individual records during workflow execution.

tip

To insert multiple rows from an IbDataTable, use the Import From DataTable activity.

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 define how the activity connects to the database and inserts the record.

Connection Type​

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

Connection Name​

Select a preconfigured database connection that defines the server, credentials, and security settings.

Schema​

Specifies the database schema that contains the target table.

Table Name​

Specifies the database table into which the record will be inserted.

Column Mapping​

Defines how workflow data is mapped to columns in the target database table.

Use the Resource Mapper to map values from workflow data and activity outputs to the corresponding database columns.

Each mapped value represents the value to be inserted into the corresponding column of the new record.

note

Ensure that the mapped values are compatible with the data types of the corresponding database columns. Columns that are automatically generated by the database, or that have suitable default values, do not need to be mapped.

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​

Inserted Records Count​

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

For a successful Insert Record operation, this value is typically 1.

This value can be used for:

  • Validation
  • Reporting
  • 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