Requirements
When three companies merged in 2001 to form Mettis Aerospace, it relied on two main IT systems. Installed in 1992, EFACS was used for financials while Sanderson PICS covered production. The systems supported four main business units on one site – Precision Forge, Aerostructures Forge, Structural Forge and Machining & Surface Treatments.
“The problem we had were different processes for each of these areas,” says IT Manager Dave Green.
Having two databases wasn’t easy. Data from the Sanderson multi-value database was extracted to the EFACS database. It was impossible to drill down from financials into the production system. Reporting made use of comma delimited files, spreadsheets and a separate Microsoft SQL Server database.
“It was very fragmented and took a lot of handholding to ensure the data got to where it needed to be. We had to pay for support for EFACS and Sanderson even though we only used certain aspects of both,” says Dave Green. “From an IT perspective, we were unable to move the business forward.”
Mettis Aerospace decided to implement a single, comprehensive solution for easier support and to end complex interfacing.
“We wanted a common business system with a central data repository. We needed to streamline our processes, so we needed workflow. We also wanted to improve data availability.”