NOAA Ensures Data Consistency Across Sybase Databases to Fuel a Self-Service eCommerce Site

About NOAA

Dating back to 1807, NOAA is an agency that enriches life through science. The organization is a division of the Department of Commerce and reaches from the surface of the sun to the depths of the ocean floor to keep citizens informed of the changing environment around them. Without the NOAA, boats don’t won’t know what to expect in water changes, weather forecasts and storm warnings. NOAA’s products and services support economic vitality and affect more than one-third of America’s gross domestic product. NOAA’s dedicated scientists use cutting-edge research and high-tech instrumentation to provide citizens, planners, emergency managers and other decision makers with reliable information they need when they need it.

About Project Performance Corporation

As the North American arm of AEA, the international energy and environment consultancy, PPC bring to bear a wide range of expertise in business management, technology solutions, and the business drivers that our clients deal with every day. The staff includes more than 300 dedicated and knowledgeable professionals, united by a tightly-knit team attitude. The consultancy creates solutions to the most complicated challenges, allowing its clients to keep their focus where it should be: on accomplishing their core missions.

Challenges

The NOAA gathers data from its scientists and satellites that provide detailed information on water levels, weather to inform its constituents such as consumers, the Department of Commerce, fisheries and other related parties. With two existing Sybase databases with some overlapping functionality and duplication of data across the two systems, the NOAA had difficulty in providing accurate data to its audiences. Data feeds from its satellites and scientists are automatically fed into the two databases that weren’t integrated. Water level measurements and water currents were fed into the two overlapping databases, producing duplicate data that scientists didn’t have confidence in. While the data size wasn’t massive, data feeds from satellites is unusually complex due to different data models that are difficult to transform and load. The company needed to integrate the two databases to ensure accuracy.

Solution

PPC was brought in to help the NOAA find its data integration solution. The company evaluated several vendors before selecting Talend as the solution, knowing that the new solution would be replacing an existing vendor. PPC deployed Talend 3.1.4 and after a small learning curve, the system was in production. Currently there are 3 people at the NOAA using Talend to ensure data consistency across the two Sybase databases.

Benefits

With Talend, the NOAA has dramatically reduced maintenance costs and now has an automated data consistency across the two Sybase systems. According to PPC, Talend has saved the NOAA approximately 1.5 personnel resources by easing the loading of extremely complex data feeds and integrating the data.