Update Record
Description
The Update Record activity modifies existing records in a specified database table.
It provides a UI-based way to select the values to update and define filter conditions that determine which records are modified, without requiring users to write SQL statements.
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 updates records.
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 containing the records to be updated.
Column Mapping
Defines how workflow values are 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.
Only the mapped columns are updated for records that match the configured filter conditions.
Ensure that the mapped values are compatible with the data types of the corresponding database columns.
Filter
Defines which records are updated. Use Record Filters to build the condition.
Despite the singular activity name, every matching row can be updated. An empty filter produces no WHERE restriction and can update the entire table. Supply an explicit unique-key condition when changing one record.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the update operation to complete.
The default value is 600 seconds.
Outputs
Updated Records Count
Returns the number of records successfully updated in the target database table.
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: Update one order
Select the Orders table. Map Status to Processed and filter by the unique OrderId. Only mapped columns change. Inspect Updated Records Count: 1 for the expected single update, 0 for no matching row, or a larger count if the filter matched multiple rows.