The problem
Vehicle tracking usually lives in its own portal: another login, another screen, no connection to the jobs the vehicles are actually driving to. The operations team needed tracking inside their job management system — positions, trips and events linked to real work.
What CodeSense built
A GPS integration layer connecting tracking hardware to the business database:
- Teltonika devices — FMC920 and FMC003 units provisioned and configured per vehicle.
- Traccar server deployment receiving device data, secured behind WireGuard forwarding.
- Webhook push pipeline — Traccar events forward to an ASP.NET Core REST API, which validates and writes positions and events into MS SQL.
- Business linkage — GPS events tied to bookings and job cards, so a vehicle’s day maps to the work it performed.
- Blazor map integration — live vehicle positions rendered inside the operational dashboard.
Engineering notes
The integration is push-based: Traccar forwards events as they happen rather than the business
system polling for them. Versioned stored procedures write gps_positions, gps_events and
job-card linkages, keeping the tracking data first-class in the operational schema — queryable,
reportable, auditable.
The result
One screen. Dispatchers assign jobs and watch the fleet on the same system, trip history is attached to jobs, and tracking data feeds operational reports instead of sitting in a silo.