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


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
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.
Indicates whether the Node should return when rows are returned in the result set or only when the result-set changes.

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

Provides a connection to the MS SQL database and associated configuration.

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.

Did this answer your question?