Data

On the Data tab, you can configure the following settings for SQL Server data source:

Option Description
Monitor changes to data in the database tables

Enable monitoring of changes to data stored in the database tables hosted on the SQL Server.

NOTE: If you plan to enable this option, make sure the account that runs the SQL Server service on the monitored instance has at least read permissions in the Active Directory domain (e.g., it does not run under a local user account). Otherwise, enabling this option may lead to issues when altering databases on the monitored SQL Server instances.

Data collection mode
Changes (per transaction) to collect and report:

Specify how many changes per a database transaction you want to be collected. For example, you can limit this number to 10 changes per transaction, or collect all changes.

NOTE: It is recommended to adjust this setting carefully, as collecting large number of changes from a highly-transactional server may affect its performance.

Monitoring rules

To specify what data changes must be monitored, create at least one inclusion rule.

NOTE: Exclusion rules are optional.

Click Add Rule and configure the following:

  • Type — Select rule type: include or exclude.
  • Server — Specify a name of the monitored SQL Server instance where the required database resides. Use the server_name\instance_name format, for example, SQLsrv11\SQLExpress2016.
  • Database — Specify the database whose data changes you want to monitor.
  • Table — Specify database table to monitor.
  • Column—Specify table column name.

    IMPORTANT! The following column types are currently not supported: text, ntext, image, binary, varbinary, timestamp, sql_variant.

These filters will be applied using AND logic. Wildcard (*) is supported and can be used to replace any number of characters.