Update Rows
Infoveave Data Automation — Database
Recalculate in the workflow. Write back to the database. Automatically.
Many workflows don't just produce new data — they produce updated values that need to be written back into the source database. Recalculated employee bonuses, revised inventory levels, updated order statuses, re-scored customer segments. Update Rows is the write-back activity for these scenarios: it takes the workflow's tabular output, matches each row to the corresponding record in the database using one or more key columns, and updates the specified fields in place. No SQL scripts, no manual exports.
What Update Rows does
Update existing rows in a relational database table using workflow data and configurable key column matching. Automatically sync recalculated values, status changes, and enriched records back to your SQL database from any Infoveave workflow.
When to use Update Rows
- You need to write recalculated or enriched values from a workflow back into an existing database table
- Your workflow modifies existing records — such as updating salaries, statuses, inventory, or scores — rather than creating new rows
- You want to sync the output of transformation activities directly into a SQL-compatible database
- You need to update specific columns while leaving other columns in the table unchanged
When to avoid it
- You need to insert new rows that do not yet exist in the database — use Insert into Database
- You need to query or read from the database — use Execute Query
- Your destination is a file rather than a database — use Write to File in the Data Ingestion library
Where it fits in your Infoveave automation
Update Rows is one step inside a multi-step Infoveave workflow. Chain it with other activities — no code, no manual hand-offs.
Build this workflow visually in Infoveave Data Automation — drag, connect, and schedule with no infrastructure setup.
How teams use Update Rows
Real scenarios where this transformation saves hours of manual work.
Bonus Write-Back After Recalculation
A monthly payroll workflow pulls employee performance data, applies bonus-calculation transformation rules, and uses Update Rows with Employee ID as the key column to write the updated bonus amounts back into the HR database. The FullName and DeptName columns are also updated via column mapping to reflect any recent master data changes.
Inventory Level Synchronization
After each day's sales are processed, an inventory reconciliation workflow calculates new stock quantities for each SKU and uses Update Rows to update the warehouse management database. Key columns are SKU and WarehouseID to ensure each location's inventory level is updated independently.
Transaction Status Update
A reconciliation workflow matches incoming bank statement records against internal transaction records and flags matched entries. Update Rows writes the reconciliation status ('Matched', 'Unmatched', 'Pending') back to the transactions table using TransactionID as the key column.
See Update Rows in action
Input data (left) is transformed using the configuration below. The output table (right) is ready for dashboards or downstream steps.
employee-db-connectionEmployeesIDName → FullName, Salary → Salary, Department → DeptNameInput Data
| ID | Name | Salary | Department |
|---|---|---|---|
| 101 | John Doe | 55000 | HR |
| 102 | Jane Smith | 66000 | HR |
Output Data
| ID | Name | Salary | Department |
|---|---|---|---|
| 101 | John Doe | 55000 | HR |
| 102 | Jane Smith | 66000 | HR |
Configuration
Key fields to configure in the Infoveave workflow builder. Full reference available in the documentation.
Connection
The registered database connection for the destination. Supports PostgreSQL, MySQL, MSSQL, Azure SQL, and other SQL-compatible databases configured in the Infoveave Studio connections panel.
Table
The name of the database table in which rows should be updated. The table must already exist in the connected database.
Key Columns
One or more columns that uniquely identify each row — for example, EmployeeID, SKU, or TransactionID. Update Rows uses these columns to match each incoming data row with the corresponding record in the database before applying the update.
Column Map
Maps each input column to the corresponding database column to be updated. Allows renaming and specifying exactly which columns to update. Columns not included in the map are left unchanged in the database.
Frequently asked questions
Everything you need to know about Update Rows in Infoveave.
Also in Database — and what runs before & after
Transformations in the same family as Update Rows, often chained together in the same Infoveave workflow.
Part of Infoveave Data Automation
80+ transformations. Zero manual steps.
Update Rows is one of over 80 transformation activities available inside Infoveave workflows. Chain transformations together — no code, no exports, no waiting for IT.
Ready to see Infoveave in action?
