The United States Geological Survey (USGS) runs the National Water Quality Assessment Program, which collects and interprets data about the quality of the nation's major groundwater and surface water systems. To give water managers and scientists the timely, accurate information they need to make decisions about protecting water quality, the government agency wanted to consolidate four major legacy data sources into a single data warehouse.

Challenges

  • Build the largest water quality dataset collected
  • Streamline process of compiling data for analysis
  • Improve performance of overloaded data infrastructure
We chose Informatica as our data integration solution because of its maturity, wide range of features, ease of use, and industrial strength, integrated architecture.
— Harry House
Data Warehouse Practice Leader
USGS

Results

$70 million consolidated

in data collected from 50 locations over 10 years

30% Improved

system performance

Additionally:

  • Saved at least 30 days of development time and resources annually
  • Launched data integration solution within a week of purchase

Technologies Used

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