FleetSQL by Asset Track is a managed service that mirrors a Wialon account into a PostgreSQL database the customer owns. Trips, fuel and charging events, driver scores, unit properties, sensors and report outputs land as relational tables, so fleet history answers SQL and joins against the ERP and finance data sitting next to it. Extraction runs on the schedule you set, resumes per entity after an interruption, and is paced against Wialon's request quotas so it does not compete with the live interface. Schema migrations and Wialon API changes are handled as part of the service.
Key capabilities:
- 50+ data points: unit properties, events, trips, fuel and charging, driver scores and report outputs
- One database per client: isolated rather than a shared schema, so access, backups and deletion stay per customer
- Scheduled sync: from every 15 minutes to nightly, resumable per entity after an interrupted run
- Historical backfill: the first run reaches as deep as the account's Wialon retention allows
- Full SQL access: standard PostgreSQL credentials for Power BI, Metabase, Grafana, Tableau or pandas
.png)
.png)
