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. |
Node Types
Microsoft SQL Server connector provides three specialized node types for different operation patterns:
| Node | Purpose | Common Use Cases |
|---|---|---|
| Query | Execute SELECT queries and return structured rows | Reporting dashboards, data lookups, KPI calculations |
| Execute | Execute DML/DDL statements, return rows affected | INSERT/UPDATE/DELETE statements, schema changes, stored procedures |
| Write | Load pipeline data into a table with auto schema detection | Bulk sensor ingestion, auto-create tables, data loading from upstream nodes |
MSSQL Query Node
MSSQL Query Node
Execute SQL SELECT queries and return rows as structured data. Supports parameterized queries with @p1 style placeholders.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Query | Run parameterized SELECT queries against SQL Server | Reporting dashboards, data lookups, aggregated KPI calculations |
MSSQL Execute Node
MSSQL Execute Node
Execute DML/DDL statements (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP) and return rowsAffected. Use for data modifications and schema changes.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Execute | Run any T-SQL statement or stored procedure call | Data modifications, schema migrations, maintenance tasks |
MSSQL Write Node
MSSQL Write Node
Load pipeline data into an MSSQL table with automatic schema detection. Auto mode detects the table schema and maps incoming data fields to columns; Manual mode lets you specify exact columns. Supports batching, auto table creation with INT IDENTITY(1,1), and schema evolution.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Write | Load structured data into an MSSQL table | Bulk sensor ingestion, auto-create tables from pipeline data, data loading |