Export to SQL Server (Stored Proc)

Category: Databases

Version: 1.0

Last updated: May 12, 2025

Author: Any2Info

---

Description

The Export to SQL Server (Stored procedure) node exports workflow data to a Microsoft SQL Server database by executing a stored procedure.

This node can be used to:

• Insert or update data

• Execute SQL business logic

• Synchronize workflow data with external databases

---

Properties

Property	Description
Connection	Select the SQL Server connection to use.
Advanced	Opens the connection configuration window.
Time-out	Maximum execution time in seconds before the node stops execution.
Log Info Messages	Enables SQL informational logging.
Output Parameters	Defines how output parameters are returned. Options: None, Mapped Columns, New Columns.

---

Connection Configuration

The connection configuration contains the following settings:

Setting	Description
Name	Name of the connection.
Connection type	Database type being used.
Connection string	SQL Server connection string.
Connection timeout	Connection timeout duration in seconds.

Example connection string:

Server=myServerAddress;
Database=myDataBase;
User Id=myUsername;
Password=myPassword;
Encrypt=True;
TrustServerCertificate=True;

Use the Validate button to test the connection before saving.

---

Changelog

Version	Date	Change
1.0	May 12, 2026	Initial documentation version added.