Microsoft SQL Server is a relational database management system developed by Microsoft.

Changelog

7 versions
v2.1.0 Latest
  • Added test() (Flow Test Mode) to all triggers: NewRow, UpdatedRow, DeletedRow, WatchRows.
v2.0.2
  • Added output examples to component schemas.
v2.0.1
  • UpdatedRow: declare detectOnStop in properties.schema.properties so the inspector input reaches the trigger.
v2.0.0
  • Breaking change: Improve security by restricting all SQL queries to SELECT/WITH statements only.
  • Updated icon for the service.
v1.0.3
  • Bug Fix: Support for non SELECT Queries in `Query` component.
v1.0.2
  • Added a new port `info` for `Query` component.
v1.0.0
  • Initial version

Authentication

TypeDetails
API Key
Host (text)
Database Host
Database (text)
Name of your database
User (text)
Database User
Password (password)
Password

Triggers

4
Deleted Row icon

Deleted Row

Watch for deleted rows in your mssql database.
New Row icon

New Row

Watch for new rows in your mssql database.
Updated Row icon

Updated Row

Watch for updated rows in your mssql database.
Watch Rows icon

Watch Rows

Watch for new and updated rows in your mssql database for an arbitrary query.

Actions

1
Query icon

Query

Query your mssql database.