Microsoft SQL Server

Microsoft SQL Server — query, insert, update, delete, and execute stored procedures.

Overview

Property	Value
Type	`database`
Authentication	`basic`
Category	Generic

Configuration

Field	Type	Required	Description
`host`	string	Yes	Database server hostname
`port`	number	No	Port (default: 1433)
`database`	string	Yes	Database name
`username`	string	Yes	Username
`password`	string	Yes	Password
`encrypt`	boolean	No	Enable encryption
`connection_string`	string	No	Full connection string (overrides individual fields)

Available actions

Query Rows

Execute a SELECT query with optional WHERE filters.


Endpoint	`GET {table}`
Method	`GET`

Insert Row

Insert a new row into a table.


Endpoint	`POST {table}`
Method	`POST`

Update Rows

Update rows matching WHERE conditions.


Endpoint	`PUT {table}`
Method	`PUT`

Delete Rows

Delete rows matching WHERE conditions.


Endpoint	`DELETE {table}`
Method	`DELETE`

Raw Query

Execute a parameterized SQL query directly (use @p1, @p2, … for named params).


Endpoint	`POST raw`
Method	`POST`

Call Stored Procedure

Execute a SQL Server stored procedure with named parameters.


Endpoint	`POST proc:{procedureName}`
Method	`POST`

Example flow

flow: webhook-to-mssql-stored-proc
version: 1
description: Receive a webhook, call a stored procedure in MSSQL, and insert results to PostgreSQL

source:
  connector: generic-webhook
  trigger: webhook
  event: inventory.updated

steps:
  - name: run-inventory-calc
    target: mssql-erp
    action: call-stored-procedure
    mapping:
      procedureName: sp_CalculateReorderPoint
      params:
        "@WarehouseId": source.warehouse_id
        "@ProductSKU": source.sku
        "@CurrentStock": source.quantity_on_hand
    store_as: reorder_result

  - name: store-reorder-data
    target: postgresql-analytics
    action: insert
    when: reorder_result.needs_reorder == true
    mapping:
      table: reorder_alerts
      row:
        sku: source.sku
        warehouse_id: source.warehouse_id
        current_stock: source.quantity_on_hand
        reorder_point: reorder_result.reorder_point
        suggested_qty: reorder_result.suggested_order_qty
        created_at: "" | now

  - name: notify-procurement
    target: slack-internal
    action: send-message
    when: reorder_result.needs_reorder == true
    mapping:
      channel: "#procurement-alerts"
      text: "Reorder needed: {{ source.sku }} at warehouse {{ source.warehouse_id }} — stock {{ source.quantity_on_hand }}, reorder point {{ reorder_result.reorder_point }}"

on_error:
  retry: 3x exponential(30s)
  then: dead-letter