FleetSQL pulls Wialon data into a database you own, so trips, fuel, driver scores and geofence events stop living behind a report builder and start answering SQL. It runs as a managed service on a schedule you set, and it ships white-label for partners who resell it under their own brand.
The default history period on Wialon Hosting is 400 days, and older messages are removed automatically. The period can be extended on request to a Partner Success Manager. Either way there is a horizon, so a year-over-year comparison built later can find nothing to compare against.
An online report gets five minutes of server time, and a detalized report caps at 400,000 rows. When a limit is reached the execution is skipped and no rows come back, which a downstream system can read as a quiet period rather than a truncated one.
The API is the integration surface, and the general-purpose ETL tools do not carry a Wialon connector: Fivetran, Stitch, Airbyte and Hevo have none, and flespi's published downstream-integrations list has no warehouse destination. A database copy is something you build or buy rather than switch on.
Fleet buyers increasingly expect to point Power BI, Tableau or Excel straight at their telematics data; Geotab, for one, bundles a Data Connector for exactly that. FleetSQL is that path for a Wialon account.
Telematics integrators and Wialon partners who need a data layer to sell alongside the platform, under their own brand and without building extraction and sync themselves.
Fleet owners large enough that reporting has become a data problem, where the questions have outgrown the report builder and the answers need to sit in a warehouse next to ERP and finance data.
Unit properties, events, trips and report outputs extracted from Wialon and written into relational tables you can join against anything else you hold.
Isolation by default rather than a shared schema with a tenant column, so access control, backups and deletion are per customer.
Runs on a schedule you configure. Sync state is tracked per entity so an interrupted run resumes instead of starting over or duplicating rows.
A normal PostgreSQL database with normal credentials, and no query layer of ours in between. Metabase, Grafana, Power BI, Tableau, Superset and Looker connect to it, as do Python, pandas, Jupyter and R, and automation tools like n8n, Zapier and your own webhooks.
Initial extraction pulls history as deep as the account's Wialon retention period allows, so standing the mirror up early is worth more than it looks.
Schema migrations, API changes on the Wialon side and failed-run recovery are ours to handle. You get a database to query rather than a pipeline to operate.
Eco-driving scores, harsh braking and acceleration events and idle time, per driver and per trip, queryable rather than locked in a scorecard.
Fill-ups, drains and suspicious losses, each with volume and location, so a fuel investigation is a query instead of a week of manual report comparison.
Enter and exit timestamps, dwell time and zone names: the raw material for site-time analysis, customer SLA reporting and detention billing.
A read-only token is enough. We scope it to online tracking and view access rather than asking for account-wide control.
Choose the entities, parameters and units in scope. The schema is generated from that selection rather than from a fixed template.
Pick a sync cadence and how far back the initial extraction should reach, bounded by your account's Wialon retention period.
Credentials arrive and the database is live. Point a BI tool, a notebook or an application at it the same day.
FleetSQL ships white-label. Partners resell it as part of their own offering, and the end customer sees the partner's brand rather than ours.
Our Wialon API reference covers what this product handles for you. Useful whether you buy it or build it yourself.
As far as your Wialon account retains data, since the platform is the only source. Wialon Hosting defaults to a 400-day history period and removes older messages automatically, and the period can be extended on request to a Partner Success Manager. It is worth standing the mirror up before you need the history rather than after: once messages age out, they are not recoverable from anywhere.
We handle it. Extraction, schema migrations and adaptation to upstream changes are part of the managed service rather than work that lands on your team.
Sync state is tracked per entity, so an interrupted run resumes from where it stopped rather than restarting or duplicating rows. Gaps caused by a longer outage are backfilled on the next successful run.
You do. It is a normal PostgreSQL database with normal credentials, and the data in it is yours. If the service ends, the database and its contents go with you rather than being switched off.
Yes, that is what the white-label configuration is for. Your brand and domain, your commercial relationship and your billing, with delivery and maintenance handled on our side.
Wialon meters message loading per user and caps heavy requests at three at a time per session, so an unpaced extractor competes with the live interface. Ours is paced against the published quotas and, where licensing allows, runs under its own account so it competes with nothing.
Ecodriving is live on the Wialon Marketplace: 0–100 vehicle and driver scores from your own Wialon criteria, violations on a map, export to Excel, CSV, PDF.
Read moreHow FleetSQL began: a passion for telematics reports, years of customer feedback, and the path from one Python script to a full backend service.
Read moreFleet Configuration Tools is live on the Wialon Marketplace: rename or delete a sensor across every unit, and set each odometer from its mileage sensor.
Read moreA fleet organization moved from static report exports to SQL analytics with governed metrics and daily data quality checks.
Read moreHow a last-mile operator deployed a unified KPI dashboard to cut dispatch response time by 34% and improve route adherence by 18%.
Read moreHow a regional distributor stabilized Wialon to ERP sync and eliminated manual reconciliation for delivery operations.
Read moreHelping businesses to make their fleets safer, teams more productive and processes more efficient.