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
Customer
    

Customer

Industry

Telematics

Location

Canada

Solution

Cloud Migration

Technology

Google Cloud Spanner

    

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.

css-saas-transportation
    

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.

    

Technologies used

  • Microsoft SQL Server
  • Google Cloud Spanner
  • Striim
        

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?

Get in touch with a Pythian Google Workspace expert to see how our team can help.
Related resources

Learn more about cloud infrastructure operations

Gain deeper insights into the advantages of the cloud. Check out our resources below.

Unlocking Cost Savings: How to Take Advantage of Google Cloud Committed Use Discounts
Google Cloud

Unlocking Cost Savings: How to Take Advantage of Google Cloud Committed Use Discounts

Feb 5, 2024 12:00:35 PM 3 min read
Defending Against Email Threats: Demystifying Common Terms
Google Cloud Platform

Defending Against Email Threats: Demystifying Common Terms

Aug 18, 2023 12:00:00 AM 4 min read
How Google BigQuery can help marketing teams do more with their data
Google Cloud Platform

How Google BigQuery can help marketing teams do more with their data

Aug 15, 2023 12:00:00 AM 3 min read
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.