FleetSQL by Asset Track is a managed service that copies data from a Wialon account into a PostgreSQL database owned by the customer and keeps it synchronized.
Trips, fuel and charging events, driver scores, vehicle properties, sensors, and report outputs are stored as relational tables. Use SQL to analyze fleet history and combine it with ERP and financial data in the same database.
Extraction runs on your chosen schedule and resumes per entity after an interruption. Schema migrations and adaptations to Wialon API changes are included in the service.
Key capabilities:
- 50+ data points: Access vehicle properties, events, trips, fuel and charging data, driver scores, and report outputs.
- One database per customer: Each customer has an isolated database, with access, backups, and data deletion managed separately.
- Scheduled sync: Set the frequency from every 15 minutes to once nightly, with per-entity resumption after an interruption.
- Historical backfill: The initial run loads historical data as far back as the account’s Wialon retention period allows.
- Full SQL access: Connect Power BI, Metabase, Grafana, Tableau, or pandas using standard PostgreSQL credentials.
.png?format=webp&width=1920&withoutEnlargement=true)
.png?format=webp&width=1920&withoutEnlargement=true)
.png?format=webp&width=1920&withoutEnlargement=true)
.png?format=webp&width=1920&withoutEnlargement=true)
