Insert Records (Deprecated)
Use Insert Record for new workflows. Use Insert Record for one mapped row or Import From DataTable for multiple rows. Recreate column mappings and rebind the count output.
Keep the existing node when maintaining a legacy workflow until its mappings and downstream bindings have been migrated and tested. The current activity is a replacement, not a drop-in change to the old output schema.
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 settings
Use Process Data to bind supported inputs to workflow values or upstream outputs. See Common Activity Features for shared execution, error-handling, and output-persistence settings. Availability depends on the activity.
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
Execution settings
Configure Wait All Incoming when execution paths converge, and On Error for failure handling. Select Inherit where available to use the workflow-level error policy.