达拉斯水务公司（Dallas Water Utilities）的东区水处理厂（East Side Water Processing Plant）正在经历一系列重大事故 扩展和改进，包括实施新的和扩展的 监控和数据采集（SCADA）系统，使用Intelluition®软件 提高了员工监控工厂流程的能力。认识到 SCADA系统提供了管理和监管所需的大部分信息 报告，一个开发报告模块（RM）的项目将实现自动化，或 半自动化，使用SCADA系统收集的数据生成大量报告。 虽然存在许多商业SCADA报告工具，但很快就发现 几乎没有（如果有的话）目标报告可以仅使用报告中包含的数据生成 SCADA系统。报告总是涉及SCADA数据和非监控数据的组合- SCADA数据（即手动收集的数据）。RM考虑了三种备选方案:将SCADA数据提取到Microsoft Excel®并手动输入 非SCADA数据； 在SCADA系统内开发数据输入屏幕，以输入 非SCADA数据，然后使用商业SCADA报告工具 生成报告；或 结合使用Microsoft SQL Server®和Microsoft Access®开发用于数据输入、存储和存储的定制解决方案 报道。备选方案1被确定为缺乏灵活性和安全性。存储在多个Excel®中的数据 电子表格不容易查询或分析，可能会被意外覆盖或删除 放错地方了。备选方案2涉及使用SCADA系统来完成并不真正适合的工作 例如，手动输入数据。由于东区工厂使用了Intelluition®SCADA系统 不在关系数据库中存储历史数据，这被认为有点不灵活。 选择备选方案3是因为它提供了灵活性和安全性的良好结合。 Microsoft SQL Server®是一个强大的关系数据库，被选中用于数据存储，提供 比前两种选择更安全、更灵活。Microsoft Access®被选为 集成平台。其固有的表单和报表构建工具，集成数据的能力 来自外部源和嵌入式Visual Basic for Applications®（VBA）编程 环境，使它非常适合这个项目。包括数字。

Dallas Water Utilities' East Side Water Treatment Plant has been undergoing a series of major expansions and improvements, including the implementation of a new and expanded supervisory control and data acquisition (SCADA) system, using Intellution® software, which has improved the staff's ability to monitor and control plant processes. Recognizing that the SCADA system provided much of the information required for management and regulatory reports, a project was undertaken to develop a reports module (RM) that would automate, or semi-automate, a number of reports using data collected by the SCADA system. While a number of commercial SCADA reporting tools exist, it soon became apparent that very few, if any, of the targeted reports could be generated solely with the data contained in the SCADA system. Invariably, the reports involved a combination of SCADA data and non- SCADA data (i.e., data that is collected manually). Three alternatives were considered for the RM: extract SCADA data into Microsoft Excel® and manually enter non-SCADA data; develop data entry screens within the SCADA system to input non-SCADA data, then use a commercial SCADA reporting tool to generate reports; or, use a combination of Microsoft SQL Server® and Microsoft Access® to develop a custom solution for data entry, storage, and reporting. Alternative 1 was determined to be inflexible and insecure. Data stored in multiple Excel® spreadsheets are not easy to query or analyze, and can be accidentally overwritten or misplaced. Alternative 2 involved using a SCADA system to do what it is not really best suited for, manual data entry. And since the Intellution® SCADA system in use at the East Side plant does not store historical data in a relational database, it was deemed somewhat inflexible. Alternative 3 was selected because it offered a good combination of flexibility and security. Microsoft SQL Server®, a robust relational database, was selected for data storage, offering more security and flexibility than the first two alternatives. Microsoft Access® was selected as the integration platform. Its intrinsic form and report-building tools, ability to integrate data from external sources, and embedded Visual Basic for Applications® (VBA) programming environment, made it well suited for this project. Includes figures.