Sutton Tools replaces legacy systems to improve operations and customer service

For their day-to-day operations Sutton Tools’ marketing & sales department relied on a combination of tools including reports from their ERP system and Excel spreadsheets, to manage catalogue data and specific customer enquiries. Essentially, the same type of information is now also available on Sutton Tools’ website and the built-in Expert Tool Selector (ETS) which enables users to easily select the right cutting tools based on their intended use, type of material, level of performance and other cutting parameters.

To maintain their competitive advantage and quality of service for its customers, Sutton Tools realized that a new solution was needed in order to replace the existing combination of reports and Excel spreadsheets. The new software had to consider additional variables such as the user’s geographical location - as different products are being sold in different regions, product images, catalog language and new information such as each product’s features and benefits.

Given the application’s growing complexity, another factor taken into account in the decision making process was the ease through which the new system could be maintained by the company’s small IT department. Therefore, the development team was tasked with finding a flexible and easy-to-use RAD tool which the company could rely on to develop its internal systems moving forward.

Moving to the evaluation phase, a couple of Java-based frameworks (such as Grails and Vaadin) were taken into consideration, but due to time and resource constraints, they were quickly discarded.

Next, Oracle Application Express (APEX) was evaluated as a potential solution. The team noticed that while Oracle APEX was satisfying their requirements in terms of presenting the data, it still had some limitations they had to overcome when setting up the Master–Detail–Detail views they needed. In the search of a tool that would complement APEX’s standard functionality, Sutton Tools learned about the FOEX Plugin Framework while attending Oracle OpenWorld.

After a quick online research about the company and its solution, the team signed up for a free trial to test the framework’s capabilities. Using the FOEX Desktop Demo as a starting point they were able to quickly build a sample product management application with information-dense pages which include the relevant details that their marketing team needed, all in one screen.

Furthermore, the development team noticed that FOEX enabled them to build complex pages which presented compacted amounts of data in a table format and facilitated an easy setup for creating the Master-Detail-Detail views they needed. With a successful proof of concept, Sutton Tools decided to use the combination of APEX and FOEX and moved to the development phase.