This page is currently only accessible to registered members of our website. Please register here to view this content. Thank you.
It’s good practice to check that your database health is at an appropriate level on a periodic basis. Over time, it’s possible to build up orphaned records, detail records that contain values that do not total to summary records, and other things that can cause performance and data integrity issues.
As long as you are current on maintenance, Epicor supply a tool that lets you check that your database is in tip-top condition, and will provide programs to resolve any issues that are uncovered. This is recommended not only before an upgrade to ensure things go smoothly but on a periodic basis for optimal database health.
The data scrubber utility is a collection of commonly applied data fixes, which the support technical team has gathered together into a package to do a “health check” of a customer’s system. They are continuously adding to it as they find additional opportunities.
This collection of assessment algorithms is new in the last few months, but the ‘fix it’ programs have been available individually for some time now.
An assessment should be considered as a maintenance routine and should be run for database health for all customers periodically, anyone going through a Business Process Review and anyone considering an Upgrade.
We will consider using this utility to get ahead of any E10 upgrades for database health and troubleshooting. We want to ensure that our customers upgrade with ‘good’ data. For larger databases, it may take a good couple of days, but it is really worth it!
The utility was discussed in several sessions at Epicor’s Insights 2015, so many of our customers will have heard about it and maybe asking themselves questions.
Encompass Solutions is a business and software consulting firm that specializes in ERP systems, EDI, and Managed Services support for Manufacturers and Distributors. Serving small and medium-sized businesses since 2001, Encompass modernizes operations and automates processes for hundreds of customers across the globe. Whether undertaking full-scale implementation, integration, and renovation of existing systems, Encompass provides a specialized approach to every client’s needs. By identifying customer requirements and addressing them with the right solutions, we ensure our clients are equipped to match the pace of Industry.