Views:

What

The Mercury Archiving Solution is designed to copy Activities from Dataverse (your live Mercury database) over to the Cosmos database (archive of your live database) in order to reduce Dataverse Storage costs.



Where


Home > Archived Activities:


A screenshot of a computer<br><br>Description automatically generated
 

 

How


Once Activities have been copied over to the Cosmos database, either by the normal BAU process or via a Bulk Egress, they will be visible as Archived Activities within Mercury.

At the point that Activities are copied over to Cosmos, they will exist in both Dataverse and Cosmos for the duration specified as the Customer Retention Period > ACTIVITY_RETENTION_PERIOD.

 

When this copy takes place, the Dataverse Activity record will be stamped with some important information:

  • recruit_copiedon - This will be the date the Activity was copied over to Cosmos.

  • recruit_deleteon - This will be the 'Copied On' date + the number of days specified by the Customer Retention Period > ACTIVITY_RETENTION_PERIOD.

 

When the scheduled Bulk Delete jobs run (that are set up as part of the Mercury Archiving Solution onboarding), any Activities where the deleteon date has passed, will be deleted from Dataverse, leaving the only copy of any affected Activity in Cosmos (thus saving on Dataverse Storage).



IMPORTANT NOTE

If an Activity is deleted prior to the recruit_deleteon date passing (i.e. not deleted by the Bulk Deletion job) the Archiving Solution will actually delete the activity from DATAVERSE and COSMOS!

This feature is designed to accommodate GDPR requirements as well as data integrity, but also poses a risk where the Activity can be deleted from both locations if done so unknowingly.

For any individual or bulk deletion of any archived (Cosmos) Activities, please consult your Mercury Customer Success Manager in the first instance.