Fleet Stack™ loading

Can Fleet Stack integrate with our existing MySQL server and data format?

Telematics
R
By Rede de Ideias
12 Feb 2025
3 Comments

We already store device data in a MySQL database, converting various tracker protocols into a standard format. We don’t want to duplicate or rebuild this system.

Can your software directly read or merge data from our current database architecture?

Share:

3 Comments

F

Fleet Stack

INVALID DATE

We can certainly push data to your MySQL database for reporting or backup purposes if needed, but it’s not possible to fully migrate or merge the entire Fleet Stack application into your existing MySQL environment. Our software relies on MS-SQL with its own structure, so combining everything into a single MySQL database wouldn’t work seamlessly.

However, if you only need certain data points (like location updates or timestamps) stored in your MySQL tables, we can explore a partial integration. Feel free to share which specific fields you want us to sync, and we’ll figure out a workable solution.

R

Rede de Ideias

INVALID DATE

Thanks for clarifying. That makes sense, and I understand the limitations. We’re mostly interested in syncing certain fields—like location updates and timestamps—into our existing MySQL tables for analytics and reporting. Is that something we could achieve through an API or direct database calls?

We’d be happy to provide more details on our schema if needed. Let me know how we can move forward with a partial integration!

F

Fleet Stack

INVALID DATE

Absolutely. A partial integration is definitely possible. Our platform offers API endpoints you can use to pull location updates, timestamps, and other relevant data into your MySQL tables. Alternatively, we can discuss a workflow that periodically writes key records from MS-SQL to your MySQL database.

Here are some steps to get started:

  • Identify Required Fields: Let us know exactly which data points you need (e.g., latitude, longitude, timestamp).
  • Review Our API Documentation: We can provide detailed Swagger docs so you can see how each endpoint is structured.
  • Plan a Sync Mechanism: You can script a job that queries our MS-SQL database and inserts or updates corresponding rows in MySQL. If you prefer a more real-time approach, our REST endpoints can push data to your environment.

Once we have your data requirements, we’ll walk you through setting up the integration. Let us know when you’re ready to begin or if you have more questions about the technical details!

Please to post a comment