Macola Data Retention & Purging Utility

Use the Attivo Data Retention Utility to:

• Allow your production environment to run lean and efficiently
  
• Dramatically improve system performance
  
• Shorten MRP regeneration
  
• Speed up report generation
  
• Reduce database size 40-60%
  
• Shorten tape backups

Here’s how it works:

1. The utility first creates a complete archive company in Macola prior to the start of the process. This is simply a copy of the company’s database which can be accessed for history purposes at any time. NO data is ever deleted.
   
2. The amount of data to be kept in the "production" company is based on the input from the Data Retention Worksheet on the next page. Different types of data can be kept for different periods of time.
   
3. Using SQL scripts, the data retention procedure is then executed to remove any data from the production company that is older than the desired retention period. A test of the procedure and data validation is performed prior to execution in the live environment. Elapsed run time is typically less than 1 hour.
   
4. SQL maintenance is then performed to physically reduce the database size. Typical size reduction is 40-60%.
   
5. Subsequent performance of the process (e.g. yearly) removes additional records and inserts them into the archive company, so that NO data is ever lost or deleted. The Data Retention process can also be run against the archive company as well, managing data stored there to different instructions (such as 7 years, for example).
   

Pricing: $795 for the utility plus consulting fees. Please contact us or your Exact Reseller for further information.

* These are recommended retention periods. These can be changed to fit your retention requirements.

CY+2 means retain Current Year data plus two years of history from the month the process is run.