Archive Data (found under DataSync) allows you to leverage the Perspectium DataSync solution to archive data from your ServiceNow instance to an external database. Whereas ServiceNow's built-in data archiving feature limits you to running archiving each table record only once, the Archive Data feature allows you to archive a record multiple times and to an external database of your choice using the Bulk Share fuction.
Explore the various contexts and instructions for using this feature.
NOTES
Archive Data is a separate update set installed on top of the Perspectium Core application. Contact Perspectium Support to obtain this update set and for more information.
- This feature requires Krypton 8.2.0+ of the Perspectium Core application for ServiceNow and Krypton 8.
Minimum Requirements and Support
| Perspectium Core (ServiceNow app) | Krypton 8.2.0 and newer |
| DataSync Agent | Krypton 8.0.2 and newer |
| Supported Databases | Oracle Microsoft SQL Server |
Once you navigate to DataSync > Archive Data, you will have the following options:
Archive
Archive allows you to use the Bulk Share feature to back up tables to a queue that the DataSync Agent can then save into an external database. The Archive option provides a simplified view of the Bulk Share feature so as to allow you to specify which table to archive. Records are sent out in the standard Perspectium message format (as found in the Messages > Outbound table)
The Archive option offers the following choices after navigating Archive Data > Archive:
- Create New Archive - Create a new archive (bulk share) configuration to specify which table you want to archive and to what target queue the records will be shared out to.
- View Archive Configurations - View previously created archive configurations. This view will only list archive configurations and not standard bulk shares.
Restore
Restore allows you to restore previously executed archives. Restore works by sending a command message to the DataSync Agent which will then query the external database where the records were previously saved to and send those records back into ServiceNow. The records are sent to the subscribed queue the ServiceNow instance consumes from, with records sent in the Perspectium message format (as found in the Messages > Inbound table) so they can be read in using the Perspectium Core application.
The Restore option offers the following choices after navigating Archive Data > Restore:
- Create New Restore - Create a new restore (bulk share) configuration to specify which archive you want to restore from.
- View Restore Configurations - View previously created restore configurations. This view will only list restore configurations and not standard bulk shares.
NOTES
- Only archives that have a Completed status can be restored. When selecting an archive to restore from, the Restore configuration will populate with the encryption method, target queue, table name, queue and condition from the archive configuration in order to use those configurations for sending out the restore command message to the DataSync Agent.
- Archive configurations that are Completed with have a Restore this archive related link so you can easily create a restore off of it that you can then execute This restore configuration will be named Restore + Unix Timestamp i.e. Restore 1688533795479 to ensure uniquely named restore configurations.
Dashboard
The Dashboard provides a view of the data you've archived using the Archive Data feature.
After navigation to Archive Data > Dashboard, you will see the Dashboard user interface that shows the following:
Recent Archives
Record Breakdown
Total Daily/Monthly Records
Total Daily Records: Displays the total records archived for the current day.
Total Monthly Records: Displays the total records archived for the current month.
Changing the date/month on the calendar does not affect this count.
Records Sent / Hour and Records Sent / Day
When looking at the results, numbers (such as the Records Reshared to Target to indicate discrepancies between ServiceNow and the database that had to be reshared) will have a background color to indicate as follows:
Number Background Color Description Green No (0) discrepancy between ServiceNow and the database Yellow 10% or less discrepancy between ServiceNow and the database Red More than 10% discrepancy between ServiceNow and the database A Status of Reshared and a Target Discrepancy Type of Not Found indicates the record was not found in the target database and has been reshared. Once the Agent has processed both the reshared message and the compare message to validate the record is in the database, this will update in here to Synced in Database. Note, for each time a record is not found and reshared (even if the same record has to be reshared multiple times because it can't process successfully), a new row will be created in the results with a Status of Reshared and a Target Discrepancy Type of Not Found.
If using Conditional Shares, the Total Records Compared will be the total of records shared to all conditional shares. For example, if your bulk share has 2 conditional shares and one conditional share shares out 173 records and the other shares out 27 records, the Total Records Compared will show 200 records compared.