United Biscuits - JDE ERP

United Biscuits – ARCTOOLS

ARCTOOLS® Data Archiving Delivers a Quicker and Easier Upgrade at United Biscuits

About United Biscuits

Founded in 1848, following the merger of two Scottish family businesses, United Biscuits (UB) has been producing some of the best known and loved sweet and savoury snacks for well over 100 years. UB’s brand portfolio includes favourites such as, McVitie’s, Jacob’s, Carr’s, McCoy’s, Hula Hoops, McVitie’s Jaffa Cakes, KP, Mini Cheddars, go ahead!, Verkade, Sultana, BN, and Delacre.

Employing over eight thousand people worldwide, UB holds leading or strong number two positions in its core markets of the United Kingdom, the Netherlands, France, Belgium and Ireland and is experiencing strong international growth from North America to the Middle East, Africa, and Australia.

Oracle JD Edwards at United Biscuits

IT has always had a strategic role at UB and the company continually invests in deploying the best and most efficient tools to ensure the company maintains its competitive advantage. With over 450
end-users, Oracle® JD Edwards is at the core of United Biscuits IT strategy in Northern Europe where UB uses the ERP to manage finance, manufacturing and distribution.  A client of Oracle JD Edwards for over fifteen years, UB started out on World 7.4, upgrading to Oracle EnterpriseOne 8.9 in 2005 and, in 2011, making the move to Oracle EnterpriseOne 9.0.

The Data Conversion Challenge

In preparation for the Oracle EnterpriseOne 9.0 upgrade project, the technical team assessed the quantity of Oracle® JD Edwards application data.  Since the previous upgrade, the business had grown substantially and estimates suggested that converting the five hundred and sixty gigabytes of data could take up to three days.

The upgrade team quickly realised  that converting all this data was inefficient, risky and an unnecessary expense so they began to search for a data purging and archiving tool which would both solve the immediate problem and also add value over the long-term.

The ARCTOOLS Solution

The IT team wanted a tool that would, deliver results quickly, not demand too much of an investment of time from the IT team and finally that would purge and archive the ERP data with integrity.

After evaluating various solutions, including using native JDE purging tools, the IT team decided to use ARCTOOLS.  ARCTOOLS was chosen, firstly, because it was a proven solution that had already been used by over three hundred Oracle JD Edwards clients worldwide, secondly, it was easy to use and less complex than other solutions on the market and finally, it was a tool which was recommended by Oracle JD Edwards experts and United Biscuits’ long-term consulting partner Cadran.

The Project

The project team had six people, one project manager, four business analysts and one external consultant.  Getting business buy-in from the start was essential to the project’s success. Time spent at the beginning of the project communicating the business benefits and how the tool worked really paid dividends.  Business users were reassured that they would not “lose” any of “their” important data and as a result, project delays due to resistance from end-users were avoided.

The project was rolled out in six stages. The stages included, a planning and analysis phase which involved determining which tables and data would be purged and how the archive would be accessed, a design phase which addressed in what order modules would be purged, a technical phase which involved installing the tool, a comprehensive testing stage which ensured a high-level of confidence before go-live and the final two stages involved archiving and purging the data.

Transfer of skills to the internal team happened very quickly and within a matter of fifteen working days the internal IT team was able to purge and archive autonomously.

Results – A Quicker and Safer Upgrade

ARCTOOLS reduced Oracle JD Edwards application data by over fifty per cent, from five hundred and sixty gigabytes to two hundred and thirty gigabytes. Tens of millions of records were purged and archived and considerable savings were made in terms of data conversion. Prior to the upgrade, it was estimated that data conversion would take up to three days, after the ARCTOOLS project, data conversion was successfully completed in just one day.


Choosing ARCTOOLS was the smart decision. Thanks to ARCTOOLS we were able to reduce our database by fifty percent and convert our data prior to upgrading in just one day. ARCTOOLS not only helped us deliver a safer and more efficient upgrade, it also helps us to keep our database at an optimal size ensuring that ERP performance is maintained and database tuning and backups are completed quickly and easily.”

“Preserving data integrity was obviously a major concern for us.  ARCTOOLS is a powerful and easy to use tool but perhaps, most importantly, it is a proven solution. Knowing that our data was safe and that so many other Oracle JD Edwards clients had already tested the tool made project sign-off and business user buy-in much easier.”
Paul Hoogenbosch, Business Analyst


  • A proven Solution
  • Quick ROI
  • Delivered results quickly
  • Easy to use


  • Reduced data volume by more than 50%
  • Data conversion prior to upgrade achieved in just one day
  • Tens of millions of records archived


ARCTOOLS is the leading purge and archive solution for Oracle JD Edwards EnterpriseOne & World. ARCTOOLS was developed by recognized JD Edwards experts DCSoftware and Redfaire in collaboration with JD Edwards.

About Cadran

Founded in 1998, Cadran offers an experienced team of ERP consultants who will supply you with a comprehensive ERP solution based on Oracle JD Edwards EnterpriseOne and World software. Our commitment to clients and our open and honest communication, combined with a culture of being true to our word, constitutes an excellent basis for success and long-term relationships. We work in partnership with our clients and are happy to share responsibility for the final results.

ARCTOOLS® is a registered trademark of DCSoftware, Inc © 2018. All rights reserved.

Cadran - Jan Stalman

Advice about our solutions?

Jan Stalman, Sales Manager at Cadran, would be happy to talk about the possibilities for your organization.