As part of the partnership between cloudThing and Avery Weigh-Tronix, we were asked to resolve a host of technical debt issues and stabilise the codebase of an existing solution for future investment.
Who Are Avery Weigh-Tronix?
Avery Weigh-Tronix is one of the world’s leading suppliers of weighing solutions, with over 200 years of experience in their field. They design, manufacture, market and service a broad range of high-quality industrial products and weighing systems.
By drawing on the very latest research and cutting edge technology from around the globe, Avery Weigh-Tronix offers a product portfolio that’s second to none: providing business focused products and solutions under several of the industry’s most established brand names, including Avery Weigh-Tronix, Brecknell and Dillon.
Avery Weigh-Tronix were looking for a Technology Partner for their Exactrak product; to review for technical debt and stabilise their entire codebase for future development projects as well as onboard their application into our DevSecOps service for a more reliable and secure operation.
Exactrak offers real-time vehicle tracking for UK Local Authorities, primarily focused on gritting vehicles. The data collected from each vehicle tracker is streamed live back to their platform to allow users to track vehicles, create new route navigations and perform route management tasks.
This allows the customer to accurately forecast route journey time and salt deployment along those routes to generate costs savings through salt and fuel optimisation.
What Would Success Look Like?
When Avery Weigh-Tronix contracted cloudThing, they were running a legacy IoT application built over many years. The codebase for the application supporting Exactrak needed to be secure, stable, resilient and ready for future investment.
cloudThing first migrated away from Avery Weigh-Tronix’s legacy hosting in Rackspace to Azure where we could use the full data analysis and data engineering capabilities of Azure to create a more supportable, resilient solution. We rebuilt large elements of the platform with Microsoft Well-Architected Framework principles, removing technical debt and updating legacy code libraries.
We then created a new React portal and implemented Irish OSM functionality and several, new geospatial features to enhance the product. Once that was done, we merged several disparate customer codebases to create a unified data model for Avery Weigh-Tronix and migrated over 100m records from three databases into two to create a unified-view of Local Authority data for Highways England. Again this work ensured a stable foundation for future investment.
Finally, we optimised the performance of the databases by a factor of 10; improving data ingress from hours to merely seconds, giving near real-time capabilities; that allow users of the product to offer significant SLA improvements for any operational issues experienced by their fleet.
- SQL Azure,
- Azure App Service,
- Azure Functions,