Telematics | Cloud Migration
SaaS Company Rapidly Scales Transportation Platform with Google Cloud Spanner
This company provides a software-as-a-service platform that connects commercial vehicles to the cloud. The company was using a mission-critical system which used Microsoft SQL Server as its backend database technology. However, the IT team determined that they needed a simpler way to scale their data system so it would grow linearly with their data volume.
![telematics](https://www.pythian.com/hs-fs/hubfs/telematics.jpeg?width=5000&height=3334&name=telematics.jpeg)
Overview
This company provides a software-as-a-service platform that connects commercial vehicles to the cloud. Processing billions of data points a day, the company leverages data analytics and machine learning to help customers optimize fleets through the reduction of fuel consumption, enhance driver safety, and ensure compliance with regulatory changes. As a rapidly growing business, the company required a data system that could scale to keep pace with business growth.
The company was using a mission-critical system which used Microsoft SQL Server as its backend database technology. However, the IT team determined that they needed a simpler way to scale their data system so it would grow linearly with their data volume.
What we did
The team began evaluating a migration from SQL Server to Google Cloud Spanner—a distributed SQL database management and storage service with high performance and availability at virtually unlimited scale—and turned to Pythian for their expertise with Google Cloud Spanner.
Pythian worked with the IT team to assess Spanner, and identified that Spanner could unlock capabilities the business needed. Since there was a requirement for real-time replication between SQL Server and Spanner—and vice versa—Striim was chosen to accelerate the time to solution. Pythian also developed post-migration operational capabilities as part of the solution—a one-of-a-kind deployment for Spanner using Terraform for scheduled backups and monitoring.
Key Outcomes
After Pythian provided the company with a technical assessment and migration plan, Pythian seamlessly deployed Google Cloud Spanner—achieving the company’s quick timeline of eight weeks.
- By migrating to Spanner, the company now has access to a fully managed cloud solution with built-in high availability, disaster recovery, and horizontal auto scaling.
- The migration has eased management for the company’s IT team.
- Decreased dependency on SQL Server means faster development times, allowing the company to focus on customer experience.
Want to see similar results for your company?
Learn more about cloud infrastructure operations
Gain deeper insights into the advantages of the cloud. Check out our resources below.
![](https://www.pythian.com/hubfs/The%20First%20Cut%20is%20the%20Deepest-jpeg-1.jpeg)
The First Cut is the Deepest: Avoiding Costly Mistakes in Cloud Spend Optimization
![](https://www.pythian.com/hubfs/Unlocking%20Cost%20Savings%20How%20to%20Take%20Advantage%20of%20Google%20Cloud%20Committed%20Use%20Discounts-jpeg.jpeg)
Unlocking Cost Savings: How to Take Advantage of Google Cloud Committed Use Discounts
![](https://www.pythian.com/hubfs/Imported_Blog_Media/Defending-Against-Email-Threats-Demystifying-Common-Terms--scaled-e1692294027141.jpeg)