From SAP to ScyllaDB: Tracking the Fleet at GPS Insight

GPS Insight, a company that tracks over 140,000 vehicles, transitioned from using an SQL-based SAP Adaptive Server Enterprise (ASE) to a NoSQL solution for managing its real-time vehicle data due to scalability and performance challenges with their existing system. Initially considering Cassandra, they opted for ScyllaDB after a successful proof of concept demonstrated superior loading speed and scalability under increased loads. The implementation involved a hybrid deployment of on-premises and cloud-based nodes and necessitated adjustments to business logic and data management strategies, including the adoption of a diagnostic Data Definition Language (DDL) to facilitate communication between ScyllaDB and their SQL system. This transition not only improved data management efficiency and performance but also allowed the SQL team to upgrade their systems without the burden of massive data loads, showcasing ScyllaDB as an effective solution for handling large-scale IoT data in the fleet tracking industry.