ServiceNow contains an optional Data Archiving plug-in which allows moving data that is no longer necessary for immediate day-to-day access from primary tables into a set of archive tables. SnowMirror supported these archiving processes only by using a differential delete strategy or a differential synchronization. However, these features are not designed for huge tables that are usually being archived. The latest SnowMirror 3.2.3 introduces a new archiving support in the Audit delete strategy.
If a table in ServiceNow is configured to regularly archive its content then all archived records are stored in a special archive table prefixed with ar_ (e.g. ar_incident). In addition, a journal record is created into the sys_archive_log table. This table is very similar to sys_audit_delete which is being used for deleted records.
SnowMirror 3.2.3 supports removing archived records from a mirror table by using the Audit Delete strategy which is reading the archive log. And it supports replication of the archive tables as well. These tables contain a special timestamp sys_archived which replaces sys_updated_on as the main timestamp for incremental loads.
This new feature has a beta status in the SnowMirror 3.2 series. If you are interested in evaluating the feature, please let us know at info@www.snow-mirror.com.
