The Attivo Group will get your system implemented - on time and within budget. Realize increased efficiencies, lower costs and improve profits. As trusted advisors for distributors, manufacturers and service providers, we will help you improve and automate your business processes.
Subscribe By Email
05-09-2013 / The Who, What, Why and When of Standard Costing
05-06-2013 / Effects of Barcoding Felt Well Beyond the Warehouse
04-29-2013 / Macola in the Cloud: A Match Made in Heaven
04-15-2013 / Understanding the Hidden Savings of Cloud ERP is Key
04-09-2013 / Behind the Numbers: Why Smart Money is on ERP
03-28-2013 / EDI - Taking Your ERP to the Next Level
03-11-2013 / Moving to the Cloud in 4 Easy Steps
03-06-2013 / Looking Past the Shop Floor to Improve Lead Times
02-26-2013 / In the World of Cloud Computing, Speed Can Kill
02-13-2013 / What Exactly is a "Dedicated Cloud"
02-07-2013 / 3 Revenue Pitfalls To Avoid When Moving to the Cloud
01-30-2013 / Where is ERP Heading for 2013?
01-24-2013 / Why Cloud Hosted ERP is Set to Take Off in 2013
BirdDog software Exact Technical Support Quickbooks Food Manufacturers Business alerts consulting All-New Stamping Attivo Group Cloud MiSYS SBM Recall Management SQL Server Utilities document management Down Economy Intuit Payments smartphones Fishbowl Software ERP software multi-step events Dynamics Great Plains Macola Progression SQL event management programming AvaTax ISO 9001 Certification SQL Tips database backups Ron Ploof CRM Implementation MAS 90 and MAS 200 Enhancements Landed Cost ISO 9001 SQL Utilities Full Value Support Plan Software ERP Support university management system QuickBooks ProAdvisor Accounting System Support Analytics Average Cost ISO consulant QuickBooks ShipGear Business Consulting Microsoft Dynamics GP job shop Event Management Systems Exact Macola Intuit Summit 2011 Continuous improvement Macola back up IT security
Follow Len's Tweets...
Run Macola Lean and MeanMacola Progression SQL users that have been using Macola for a long time and have not regularly purged the database experience significantly slower processing and much longer times for report execution, invoice posting, GL subsidiary ledger posting, etc. The Attivo Group has developed a data retention utility for Progression SQL that allows the user to first archive all historical data into a separate database, and then purge their system using data retention guidelines. In this way, NO data is lost. Using SQL tools, the program removes all data that falls outside of the date retention period. In this way, historical reporting and analysis can still be performed as required against the archived data, leaving the production database "lean and mean". The data retention process is rules-driven to allow a company to define which files (tables) need to be archived and how much historical data is retained in the production environment. For example, 2 years of accounts receivables invoices and payments may be sufficient for most queries. However, your company may need to keep 5 years worth of receivables information to support some contractual or legal requirements. Using the Attivo data retention utility, the company can have both.
Designed for ongoing useThe system is designed for ongoing use, as well. Once you define the data retention schedule, the utility will add any data records in the production company that do not already exist in the archive company, and then purge the production company of any transactions beyond the data retention period. This provides the ability for the company to perform historical trends and analysis without taking up the resources in the production environment. Daily processing will go faster since the database that is being accessed is smaller, and there are fewer records that the system will need to look through when determining what information is to be used for a given process. Users have reported reductions of 40-60% in database size. Data intensive processes such as MRP regeneration, invoice posting, subsidiary ledger posting to General Ledger, etc. post a dramatic improvement in processing time. The associated database size reduction also reduces daily backup time, as well.
Save an incredible amount of timeCan this be accomplished using the purge processes already in Macola? Absolutely. However, the time required to purge each and every file using the native system tools will take hours and hours, spread over several days or weeks, since you can't purge the system while people are using it. The data retention utility will accomplish the entire job within an hour or so. That's a huge gain in productivity for a system administrator, and encourages and facilitates regular maintenance to keep your Macola system operating at peak performance.