ballardchalmers - home

Contact us 01342 410223

Situation

In their position as the transport information hub for London, Transport for London (TfL) collect and disseminate information from many different transport sources in as many different formats, from departure boards to motorway cameras, to deliver an online service for commuters through their primary website www.tfl.gov.uk.

TfL's existing data transfer system, software and hardware, was prone to stalling and delays and had inadequate error handling, resulting in delayed and inaccurate information being presented to the web pages.

Ballard Chalmers was briefed to develop a new software system that would broadcast live travel data to clients and customers through the use of syndication, personalisation and localisation.

Solution

The brief was to develop a proof-of-concept software solution using Microsoft BizTalk that harnessed raw data from over 25 sources across the capital. These sources included the tube and rail network, station information, river, roads, buses and coaches. Data was captured, stored and processed as XML in a scalable BizTalk environment. The incoming feeds were used to create live html web pages every minute, which meant that our solution had to process every piece of information in just 30 seconds.

Continuous monitoring and status alerts of incoming and outgoing feeds were provided in a form suitable for display on TfL's internal monitoring dashboard. This allowed rapid diagnosis of any data and system problems. The new system generated real time performance reports on a monthly and quarterly basis, as well as on trading partner adherence to weekly data refresh requirements.

By sharing the data load across servers, the software ensured that one failed server would not hinder the reporting process. The scalability of the project meant that the system was future-proofed against large amounts of new data and sources, making its implementation more cost-effective in the longer term.

Outcome

This project successfully demonstrated that real-time live feeds into the TfL website is possible and what's more, it is a very stable system.

About

Ballard Chalmers is one of the UK’s leading enterprise software engineering companies, specialising in development for the Microsoft Enterprise Application Platform. We are principally dedicated to software development and integration for the Microsoft Cloud, as well as on-premises and hybrid systems. Our expertise is in Microsoft .NET, SQL Server, BizTalk Server and SharePoint Server.

Let's talk

  01342 410223

Find out more

Thank you for contacting us.

We will be in touch with you shortly.