The Washington State Department of Transportation (DOT) manages 7,048 miles of road, 3,367 bridges, and a 29-ferry system that moves more than 26 million people a year. To better manage them, the DOT needed a more efficient way to access and leverage data from legacy systems, some of them more than 30 years old.

Challenges

  • Leverage long-term investment in legacy systems
  • Eliminate customized, ad hoc data access mechanisms
  • Make maintenance simpler and more cost-effective
Informatica PowerCenter has brought consistency to our data environment and helped us modernize our data transfer methods. Its native access to our mainframe Adabas data sources has enabled us to roll out eight data marts in just four years to our analysts, and cut the time our developers used to spend on custom coding by as much as one-half.
— Chris Kemp
Manager, Data Management Services
Washington State Department of Transportation

Results

25% to 50% Reduced

development time

50% Decreased

load processing times

Additionally:

  • Increased flexibility and lifespan of IT infrastructure
  • Moved six IT staffers to other critical tasks

Technologies Used

  • Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hand coding.