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, optional Timeout | Select the shared SQL Server connection profile and configure T-SQL statements, stored procedures, and timeouts. |
| Settings | Retry on Fail, On Error, Notes, Display Note In Pipeline | Control pipeline behavior with retry policies, error routing, and canvas notes. |

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 |