Upsert Records (Deprecated)
Use Upsert Record for new workflows. Map one input record and specify Unique Columns to identify an existing row. Rebind the inserted and updated count outputs.
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 Upsert Records activity inserts new records or updates existing records in a specified database table based on matching key columns. This allows workflows to maintain data consistency by handling both create and update operations in a single step.
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 performs upsert operations.
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 name of the database table where records will be inserted or updated.
Key Columns
Specifies one or more columns that uniquely identify a record in the target table. These columns are used to determine whether a record already exists and should be updated, or whether a new record should be inserted.
Column Mapping
Defines how workflow values are mapped to database columns using the Schema Mapper.
All mapped columns are applied during both insert and update operations.
Timeout
Specifies the maximum time (in seconds) that the activity will wait for the upsert operation to complete. The default value is 600 seconds.
Outputs
Updated Records Count
Returns the number of existing records that were successfully updated.
Inserted Records Count
Returns the number of new records that were successfully inserted.
These outputs can be used for validation, reporting, or 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.