Enterprise Application Integration for a US Transportation Company
Summary
A US passenger transportation company ran three vital enterprise systems that worked in isolation, causing inefficiencies, data inconsistencies, and operational blind spots. INNERLUXES built cloud-based integration middleware that connects the dispatch, fleet management, and onboard video surveillance systems, normalizing and cleaning the data and synchronizing it reliably on a schedule. After a six-month engagement, the company has accurate, real-time data across all three systems and an architecture ready to grow into a SaaS product.
About the Client
The Client is a US passenger transportation company.
Three Disconnected Systems Were Slowing Down Transportation Management
Before turning to INNERLUXES, the Client ran three enterprise systems — each vital to daily operations — that functioned in isolation, leading to process inefficiencies, data inconsistencies, and operational blind spots:
- A dispatch system managing vehicle assignments, driver schedules, ride details, and trip statuses in real time.
- A fleet management system tracking vehicle specifications, maintenance schedules, fuel usage, and compliance requirements.
- An onboard video surveillance system capturing and storing in-vehicle footage for security and regulatory needs.
The Client needed a reliable way to connect these systems to improve data accuracy and streamline operations, and wanted the option to evolve the solution into a SaaS product later — which called for a scalable, flexible architecture from the start.
Cloud-Based Middleware to Integrate the Transportation Systems
A INNERLUXES team of two .NET developers and an Azure DevOps engineer began with a thorough analysis of the data held across the three previously disconnected systems. They found multiple data-quality issues — inconsistent field naming, varying formats (for example, mileage recorded as "80" in one system and "80.0 mi" in another), duplicate entries, and incomplete records — and addressed them by mapping data entities across the systems and designing custom transformation rules to normalize, clean, and enrich the incoming data.
Early on, the team also found that the available API documentation was outdated and incomplete, creating uncertainty around data formats and endpoints. They worked closely with the Client's in-house consultant to clarify undocumented behaviors, update the API specifications, and fill in the missing details, establishing a reliable foundation for integration.
On that foundation, INNERLUXES developed custom cloud-based integration middleware driven by scheduled cron jobs. By staggering job execution, the team spread processing load over time and reduced the risk of resource contention during peak hours, ensuring reliable data synchronization across all three systems. To prepare for future expansion — including a potential multi-tenant SaaS product — INNERLUXES's lead solution architect reviewed and refined the architecture throughout, evaluating the efficiency of data-processing flows and validating the separation of the configuration, transformation, and execution layers.
Synchronized Systems, Fewer Errors, and Faster Operations
After the six-month engagement, the Client received reliable middleware that now connects its three core enterprise applications. It enables seamless real-time data synchronization across all three, improves data accuracy and visibility across the enterprise, and minimizes the need for manual data transfer and error correction. The company now benefits from streamlined workflows, better fleet management, and a system ready to evolve into a SaaS product when needed.
Technologies and Tools
.NET, Azure Kubernetes Service (AKS).