Private Water Company
The New Jersey arm of a national water company required data collection and reporting for business management, regulatory compliance and improved customer response.  A key challenge to this client is the diverse nature of their installed systems and databases with many installations dating back to the 1980’s.  In addition, many sites and systems are located at various facilities throughout the state. 

ACC has supported this company at various locations, implementing PLC-based control systems as replacements for aging RTUs.  When this customer needed to embark on a multi-site reporting and visibility initiative, they looked to ACC to provide a robust and flexible solution.  Rockwell VantagePoint was chosen as the ideal tool to integrate various data sources and deliver a range of flexible reports. 

Requirements included:

  • Collection of time-series data from a variety of existing data sources including:
  • GE Proficy Historian
  • Legacy Database - Oracle, SQL and Access
  • Bristol Babcock RTUs
  • Rockwell PLCs (SLC, Logix)
  • Normalization of tag naming using the VantagePoint “model”
  • Various tagnames from different data sources now follow normalized naming convention
  • Easy to locate data by equipment type or location
  • User Support for Data Review and Reporting
  • Workflow for Daily Data QA/QC activities with Data Editing and Approval
  • Support for manually entered data into VantagePoint tags
  • Calculations in VantagePoint using data from multiple sources to create reports
  • Dashboards with daily “tickers” on system delivery and flow
  • Daily “Newspaper” Reports auto generated and delivered via Email
  • Mobile support on company issued iPhone and iPad devices for current and historical data
  • Integration to corporate Microsoft SharePoint using VantagePoint plugins