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.
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.
Wait All Incoming
The Wait All Incoming property controls how the activity behaves when it has multiple incoming execution paths.
| Option | Description |
|---|---|
| False | The activity is executed whenever any incoming path completes. Each incoming completion can trigger a separate execution. |
| All Configured Incoming | The activity executes only after all design-time (configured) incoming paths have completed. If a path is skipped at runtime due to conditional logic, the activity may wait indefinitely. |
| All Active Incoming | The activity executes only after all runtime-active incoming paths have completed. Incoming paths that are not taken due to conditions are ignored, ensuring predictable execution. |
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
Error Handling
This activity supports the standard On Error handler to control how failures are handled, including Fault, Continue, Suspend, and Retry.
For details, see On Error Handler.