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.
To insert multiple rows from an IbDataTable, use the Import From DataTable activity.
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 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.
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
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.
Example: Insert an order
Select the Orders table and map CustomerName and Amount to values from Process Data. Omit a database-generated OrderId column. Include values for required columns that have no database default, and use values compatible with each column's type.
On success, Inserted Records Count is normally 1. For multiple source rows, use Import From DataTable.