Scalable, stable and upgradeable extraction, transformation, load (ETL) solution - Make current and correct data available for viewing at the touch of a button at any time

CASE STUDY Berliner Wasserbetriebe “WE ALWAYS HAVE CURRENT AND CORRECT DATA ON HAND SAGENT DATA FLOW DATA INTEGRATION SOFTWARE THAT WE CAN VIEW AT THE TOUCH OF A BUTTON.” SUPPORTS THIS GERMAN WATER René Mannel, Project Engineer, Berliner Wasserbetriebe SUPPLY COMPANY’S CENTRALIZED REPORTING SYSTEM. Challenge SUMMARY CHALLENCE Berliner Wasserbetriebe Berliner Wasserbetriebe ranks among the The company’s own accredited labs analyze the needed a scalable, stable largest water supply and wastewater disposal purification efficiency of the water treatment and upgradeable extraction, companies in Germany. As an “Anstalt des works and the drinking water quality of the transformation, load (ETL) öffentlichen Rechts” (i.e., a public service water works. Lab data from the water and solution for its wastewater company), 50.1 percent of the shares are held wastewater, physical-technical data such as information system for by the district of Berlin. The international water volume flows, run times, concentrations, water treatment works and supplier Veolia (formerly Vivendi) holds 24.95 temperatures, pressures and other indicators pumping stations. percent, as does the German energy supplier were assessed off-site and made available to RWE. With about 5,000 employees, Berliner users by viewing the local database tables. Wasserbetriebe is also one of the capital city’s “There were elements of a central reporting Solution largest employers. The company invests about approach based on the collection of scripts 250 million Euros in the city’s infrastructure and text files. However, its success relied The organization implemented annually, which means that a very high number heavily on the programmer’s know-how. Sagent Data Flow software TM of suppliers and service providers from the In addition, the system could not be upgraded to make current and correct Berlin-Brandenburg region profit from it. and maintenance was inefficient. That’s why data available for viewing This organization supplies drinking water to we got the go-ahead to set up a centralized at the touch of a button at 3.5 million people in the city and surrounding reporting system (wastewater information any time. areas and it disposes of the wastewater system) for the water treatment works and the produced by about 3.9 million inhabitants. pumping stations," explained René Mannel, Nine water works always guarantee sufficient project engineer at Berliner Wasserbetriebe. amounts of the highest quality drinking water. “Using a catalog of criteria, the requirements Some 147 pumping stations transport the for the software that we wanted were defined. wastewater via a mains network to six wastewater What we really needed was a scalable, stable and treatment works. There, the wastewater is upgradeable ETL (Extraction, Transformation, treated using state-of-the-art technology and Load) solution that would also give us the know-how in an environmentally friendly way option of error analysis. We were looking for before being drained into the surface water. a solution into which we would be able to Berliner Wasserbetriebe needed a scalable, sta- seamlessly integrate existing databases and ble and upgradeable extraction, transforma- source systems from the works. Additionally, tion, load (ETL) solution for its wastewater the solution had to be designed to allow information system for water treatment works efficient and simple data maintenance as and pumping stations. The organization imple- well as be easy to use," said Mannel of the mented Sagent Data Flow software to make cur- requirements for the solution that was needed. rent and correct data available for viewing at the touch of a button at any time. “…WE LIKED THE FACT THAT IT WAS SIMPLE AND INTUITIVE TO OPERATE, VERY USER FRIENDLY.” RENÉ MANNEL, PROJECT ENGINEER, BERLINER WASSERBETRIEBE R E S U LT “We are happy with our decision and very Through fast and efficient error notification, we satisfied with the Pitney Bowes Business have saved a great deal of time,“ said Mannel. Insight solution. Working with Pitney Bowes Even the quality of the data has greatly Business Insight was a pleasure. Thanks to this improved. “The time of scripts and texts is solution, we were able to set up our planned gone. Thanks to the Sagent Data Flow solution, centralized reporting system in accordance we always have current and correct data on UNITED STATES with our requirements. The solution is simple hand that we can view at the touch of a button and intuitive to operate, the documentation One Global View at any time using the graphical user interface. Troy, NY 12180 runs quickly and easily, the data flow is simple Moreover, we have a powerful wastewater 1.800.327.8627 to map and visible to us at any point. What information system that is based on a scalable, pbbi.sales@pb.com more could you want?“ asked Mannel with stable and upgradeable ETL solution that will www.pbinsight.com a smile. enable us to expand the reporting system at Also, when it comes to the economic benefits, any time.” Mannel concluded, “Thanks to CANADA the use of the ETL solution at Berliner this system, we are now able to plan our IT 26 Wellington Street East Wasserbetriebe has proven its worth. infrastructure cost effectively.” Suite 500 Toronto, ON M5E 1S2 1.800.268.3282 pbbi.canada.sales@pb.com www.pbinsight.ca EUROPE/UNITED KINGDOM Minton Place Victoria Street Windsor, Berkshire SL4 1EG +44.1753.848200 pbbi.europe@pb.com www.pbinsight.co.