The business requirement
Morgan Sindall Infrastructure needed fleet information from the Northgate telematics API available in SQL Server for its own reporting and operational use.
Development and integration
Impact built a configurable .NET server application to collect and validate vehicle, location, trip and driving-event data. Scheduled processing and support for concurrent instances connected the external fleet service to a structured internal reporting database.
Planning a related project? Explore our API development and integration services, browse more customer projects or discuss your requirements with Impact.
Original project detail
We have recently completed a Northgate Telematics API integration for Morgan Sindall Infrastructure (MSI). MSI have approx. 2,500 fleet vehicles for which they needed vehicle tracking to include routes taken, distances travelled, and speed, plus to record risk management factors eg driver behaviour.
Our Northgate Telematics API software development tracks:
- Telemetry - location (long/lat, speed, altitude, heading, accuracy), sensor output
- Events - harsh braking, speeding etc
- Trips - tachograph analysis, start location, end location, drive time, idle time,
- Fleet management - assets, vehicle reg, owner
Our approach to this API development was to create a server app, written in .Net using visual studio 2019, to sit on a windows server, to be run as a task scheduler event i.e. a console type app.
The app is able to be configured via a txt config file to allow various parameters such as SQL connection strings, API Keys, end point, etc. to be configured if these items change in the future.
At the required scheduled time the app will connect to Northgate, using the API and request all available data. The data will be written back to a MS SQL database, and from this point Morgan Sindall use enterprise reporting tools to manage the fleet.
100's of 1000's of events are being captured every week. The timing, validation, and processing of this data is critical, to prevent data stacking up.
The app can support multiple instances running concurrently.
