Monitor Database Changes
Monitor a specified database table for changes (insertions, updates, deletions) and place changed data in variables.
-
Define the connection string for the data source; and
-
(Optional) Click the Builder link to assist in defining the connection string.
-
-
Indicate whether you would like to retrieve database login credentials from theNintex Credentials Vault.
-
Select the table to monitor; and
Indicate the types of changes to monitor (insert/update/delete).
-
Identify the following columns:
-
UID – Unique ID column
-
Update Date – The DATETIME column containing update time of each record
-
Is Deleted – Numeric (BOOL) column representing a deleted state for each record
-
-
(Optional) Enter any applicable WHERE clauses to further refine the changes to monitor.
-
Set the duration of polling cycle in seconds; and
Indicate if you would like the wizard to stop monitoring (i.e., timeout) after a certain number of minutes.
-
Enter the columns to be returned into the variables, separated by commas; and
Indicate the number of rows to fetch, or select to fetch the first changed row only.
-
Enter the names of the variables into which you'd like to place the results; and
Enter the delimiters to use to separate each row and column in the returned data.
-
Instruct the wizard how to handle any errors encountered. Read more about error handling.