In the process industry lots of data are measured and recorded with different systems, programs and at different locations. The sources differ from online process data in DCS or PLS from different vendors to relational Databases and commercial data in ERP-Systems.
At the Berliner Wasserbetriebe (BWB) all these data are needed at the operations level but only about 2% of this data are relevant for the higher reporting level. To extract this reporting data, BWB has decided to build up a Database (so called Data-Warehouse). One of the most importing steps is the consolidation of the different data-sources. This presentation shows how the level of consolidation is realized with PI-Systems.