The Sagent Solution met our requirements almost exactly. Most of all, we were impressed by the functional coverage of their data flow technology and the resulting options for error analysis. Moreover, we liked the fact that it was simple and intuitive to operate, very user friendly.
— René Mannel
Project Engineer
Berliner Wasserbetriebe
Group 1 Provides Data Integration Solution to German Water Supply Company Berliner Wasserbetriebe
Download the full case study PDF or read the summary below:
Berliner Wasserbetriebe is one of the largest water supply and wastewater disposal companies in Germany, as well as also one of Berlin’s largest employers. Additionally, a large number of suppliers and service providers from the Berlin-Brandenburg region profit from the utility company.
The Challenge
Off-Site Data Assessment
While Berliner Wasserbetriebe conducted their own analysis of the water works, lab data from the water and wastewater and physical-technical data was being assessed off-site and made available to users by viewing local database tables.
Inefficient, Manual Reporting System
Success of this reporting system relied heavily on programmer know-how, and the system itself could not be upgraded. Further, maintenance of the system was extremely inefficient.
The Solution
Scalable, Stable & Upgradeable ETL
Berliner Wasserbetriebe selected Group 1 Software’s Data Integration Solution, which features innovative and open data flow technology and offers solution components for the ETL and OLAP domain.
Error Analysis
The Data Integration Solution also features a graphical user interface to allow quick setup of automated processes, such as error search routines and error notifications.
The Benefit
Simple & Intuitive
Group 1’s Data Integration solution is simple and intuitive:
- Documentation runs quickly and easily
- Data flow is simple to map and visible at any point
- Data maintenance is efficient
Integrated Wastewater Information System
The water supply company seamlessly integrated existing databases and source systems from the works. Now, Berliner Wasserbetriebe has a centralized, efficient reporting system — wastewater information system — for the water treatment works and the pumping stations.
Quick Access to Current & Correct Data
Berliner Wasserbetriebe has greatly improved the quality of its data, which is now always current and correct. Their data also can be viewed at the touch of a button using the graphical user interface.
Significant Time Savings
The fast and efficient error notifications have saved the water supply company a great deal of time, as well as improved their responsiveness.
Effective Cost Planning
Now, with a scalable, stable and upgradeable ETL solution, Berliner Wasserbetriebe can expand their reporting system at any time. This flexibility allows the company to plan their IT infrastructure costs effectively.
Now that you've read the summary, Download the full case study PDF.