Client: Digital Fleet is a GPS asset tracking and fleet telematics company offering real-time fleet tracking solutions with customizable workflows and integration with operational systems particularly made for the construction materials and ready-mix concrete industries.

Challenge: Since Digital Fleet works in Telematics domain, they have to deal with large amounts of data. Effective management of the rapid increase in data volume was being considered as a challenge to the client. The reporting module required more flexibility and efficiency. To make this upgrade possible, it was important to keep the data storage for reporting module separate from the production module. SSI pooled resources with Digital Fleet to build a product for the better management of the increasing data volume using SQL server. It was advised to use MongoDB in sync with SQL Server in real time because the reporting majorly consisted of near real-time tracking of construction vehicles on maps.

Solution: SSI implemented its own developed analytics framework that enables well-organized reporting, rich data visualization, and customizable dashboard layouts. It has three main features:

Query Builder: A rich UI to design complex drag and drop structures and creates text queries on run time.

Report Builder: Creates multi-section reports based on the queries designed in Query Builder.

A message broker service was introduced to transfer the data persisted in MongoDB to MS SQL Server for real time data synchronization between MongoDB and MS SQL Server. A wrapper module on top of RabbitMQ was also created to manage the speed of data transfer and to maintain the telematics data in a sequential order.

Result: The application helped improve the user experience for their end clients and improved operational efficiency for Digital Fleet as a more scalable platform.