What's the measure of a successful integration project? For Jamey Harvey, the deputy chief technology officer for the District of Columbia, it was the ability to get a map of all the abandoned cars that needed to be towed in the city.
"A burnt-out car isn't just an eyesore; it's a place where people deal drugs and get murdered," says Harvey.
Until recently, those cars might have stayed on the streets for months. That's because the city's data on abandoned vehicles wasn't all located in the same database, so some of it never showed up on towing lists.
"DC has a very feudal system of government, and the 66 agencies that report to the mayor all had their own IT stovepipes, which were not designed to have any kind of interaction between them," says Harvey.
The city's IT department realized it could overcome some of that lack of integration by using Web services. With Sonic Software's enterprise service bus product, the IT department created an application called DCstat that merges information from data silos around the city.
Begun as a pilot project in 2004, DCstat enables city employees to see everything from housing-code inspections to crime incidents around the city. It uses information from more than 150 data sources, including the police department, the mayor's call center, the department of transportation and the water and sewer authority. The city also has a much more coherent integration strategy and architecture.
"We now have a well-defined stack and a well-defined product set for each kind of business integration challenge," says Harvey.
For the District of Columbia and other large organizations that have spent years on ad hoc efforts to integrate piles of legacy systems, there's a critical need for a consistent and standardized approach to integration. Multiple middleware products and hand-coded connections drain IT resources with a constant need for maintenance, troubleshooting and configuration updates. Disparate middleware technologies also tend to aggravate the integration problems they were intended to solve, because they create departmental silos of applications that are integrated with one another but not with the rest of the company.
Achieving a more consistent -- and manageable -- integration architecture is a challenge, particularly for organizations with independent business units and multiple IT shops. It requires constant interdepartmental collaboration and attention to business processes, as well as a thorough inventory of technical requirements.