Operating Principle
The SQL Table Watcher monitors a specific database table and reads all entries of the table in an interval which can be configured over the Timer event. A workflow is started for every new table entry. When configuring the SQL table watcher several database information is required, which will be described in the following.
Configuration
To configure the SQL table watcher, you first need to set a Timer event as Start event. In the timer event configuration, you can now select the SQLTableWatcher under the Custom Check Routine.
After that, the input parameters need to be configured. To do that, you first can select a business entity and then click the button Routine parameter to open the dialog. If you would like to use variables for the credentials, you now have all fields of the previously selected business entity available. But the credentials can also be filled by directly writing data into the boxes. When using the SQL-Authentication you also have to specify the username and password which is authorized to access the database and table. When using Windows-Authentication, this won't be necessary. After you filled all credentials you can test the connection whether it works or not and the output data can also be configured when switching to the Output Data tab.
The table that you see needs a column of type 'datetime2'. Set this column as 'Timestamp column' in the dialog. The table watcher checks for all entries with a newer timestamp than the last table watcher has run (interval).
Confirm the configuration with clicking OK. Back in the Start event dialog, click OK once more and the SQL table watcher has been configured successfully.