Microsoft SQL Server Nodes

MaestroHub delivers full support for Microsoft SQL Server with native T-SQL syntax, parameter binding, and connection tuning so you can integrate enterprise workloads seamlessly.

Configuration Quick Reference

Field	What you choose	Details
Parameters	Connection, Function, Function Parameters, Timeout Override	Select the connection profile, function, configure function parameters with expression support, and optionally override timeout.
Settings	Description, Timeout (seconds), Retry on Timeout, Retry on Fail, On Error	Node description, maximum execution time, retry behavior on timeout or failure, and error handling strategy. All execution settings default to pipeline-level values.

MSSQL Query Node

MSSQL Query Node

Execute SQL Server queries and stored procedures with parameter binding.

Supported Function Types:

Function Name	Purpose	Common Use Cases
Execute Query	Run T-SQL statements or stored procedure calls	Production reporting, MES integrations, transactional updates