Monitor Database Changes

Monitor a specified database table for changes (insertions, updates, deletions) and place changed data in variables.

  1. Define the connection string for the data source; and

    • (Optional) Click the Builder link to assist in defining the connection string.

  2. Indicate whether you would like to retrieve database login credentials from theNintex Credentials Vault.

  3. Select the table to monitor; and

    Indicate the types of changes to monitor (insert/update/delete).

  4. 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

  5. (Optional) Enter any applicable WHERE clauses to further refine the changes to monitor.

  6. 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.

  7. 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.

  8. 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.

  9. Instruct the wizard how to handle any errors encountered. Read more about error handling.