As one of the leading providers of bath and kitchen accessories, this Fortune 500 manufacturing company relies on a 24/7 operation to serve its customers. Having implemented order-to-cash, procure-to-pay and financials for JD Edwards® OneWorld®, the company implemented the OneWorld® manufacturing module for its facilities. The manufacturing "go-live" more than doubled the database growth rate. System performance was suffering and disk space costs were rising. Monthly reports took an extremely long time to execute. The company was looking for a comprehensive solution to tackle this growing problem.Why Purge & Archive
Building a solution in-house was not a viable option as internal resources were consumed with manufacturing implementation, daily support and other strategic initiatives. Additionally, the time and resources required to understand system complexities and build a solution were cost prohibitive. The company wanted to have an archival solution in place to control their database growth and associated problems. After having considered other vendors, the company chartered Essentio with the implementation of an archival solution from beginning to end.
By implementing their flagship enterprise database archival software, Archivist™, Essentio provided the company with a strong data mamnagement solution. Essentio worked closely with the company’s resources to carefully gather requirements. As part of the initial implementation phase, the company was able to reduce their production database size by 45%. Essentio’s solution also maintained data integrity so there was no adverse impact to day to day activities. More than 13 archival processes were created using Archivist™, which provided flexibility in archiving data from different modules on a standardized platform. In addition to standard JD Edwards® tables, several custom tables were integrated into the archival process. Archivist™ made execution of archival processes such an extremely easy proposition – in fact, only a single resource was required to maintain and execute all of the archival processes. Ultimately, the company was extremely satisfied in having achieved its goal to manage its data as well as address related performance issues.