Save Calculation Flow Output to database

Saves the result of a Calculation Flow to the target table.

Example
This flow is triggered by an HTTP request and performs a complete calculation process for project data. It begins by loading project dimensions and defining lookup tables, distribution keys, and auto transactions required for the calculation. The flow then defines the output structure and iterates through each project, setting the project context and performing time and material estimations. Before saving the new results, it removes any existing records from the target table. Finally, the calculated output is saved to the database, making the data available for reporting and analysis in InVision or Power BI.

Properties

Name	Type	Description
Title	Optional	Custom title for the action.
Batch size	Optional	Number of rows to write per batch.
Timeout (seconds)	Optional	Number of seconds for the operation to complete.
Disabled	Optional	Disables the action when checked.
Description	Optional	Additional information or notes about the action.

Note

The output should be written to the database only after all input records have been processed and all calculations are complete. To achieve this, the Db Output action must be configured correctly and connected in the proper sequence.

Example

In the example above, the Estimate Time and Material function writes calculation results to the output object defined in the Define Calculation Flow output step. Each record is added to the Output variable using this.Output.Add(...), ensuring that all computed values are collected and later saved to the target database table.