Microsoft SQL Watcher

Provides a Flowgear Trigger that enables monitoring of a change in an MS SQL database.

Revision History

1.0.0.0 Initial Release
3.0.0.6 Minor Updates and bugfixes
3.0.0.14 Added support for custom connection string fragments

Properties

Connection

Type: Connection Input

Server
Type: String
The name or IP address of the MS SQL instance (including the instance name). When using a DropPoint, the Server is relative to the DropPoint. For example, if the DropPoint is installed on the SQL server, the Server property may be simply (local) or 127.0.0.1 .

Database
Type: String
Provides the name of the MS SQL Database.

UserId
Type: String
Provides the name of the user account against which the SQL query will be executed. When using a DropPoint, consider used Windows Authentication (UseWinAuth property) and running the DropPoint under an appropriate Windows account.

Password
Type: Password
Provides a password for the specified user account.

UseWinAuth
Type: Boolean
When the Node executes at a DropPoint, allows the user context to be derived from the Windows service account under which the DropPoint is running.

FireOn
Type: List
Indicates whether the Node should return when rows are returned in the result set or only when the result-set changes.

RowsChanged - Specifies that the Node should fire whenever a change occurs in the result set.
RowsReturned - Specifies that the Node should fire whenever execution of WatchQuery results in rows being returned.

PollInterval
Type: Int32
Provides the interval, in seconds, at which the database should be polled.

ConnectionStringFragments
Type: String

Provide a list of extra connection string fragments that are not part of the standard connection properties. The fragments must be in the format key=value and different fragments should be listed underneath each other.

WatchQuery

Type: Multiline Text Input
Provides the query that will be evaluated based on the configuration specified in Connection.

Remarks

SQL Watcher provides a lightweight mechanism for responding to changes in a database by polling it at the interval specified in the Connection.

When FireOn is set to RowsChanged, the Node will fire its output each time a row with a changed value is returned by the query specified in WatchQuery. When FireOn is set to RowsReturned, the Node will fire its output when at least 1 row is returned by the query specified in WatchQuery.