Wonderware Historian (InSQL) Project Reference List

Following are examples of recent ACE projects involving Wonderware’s InSQL application. Please contact your Applied Control Engineering, Inc. representative if you require additional information.

Akzo Nobel Chemical

ACE provided technical consulting and systems integration engineering services for this Wonderware InSQL application used in the collection of process data for catalyst manufacturing from a Bailey Infi 90 system. Using Microsoft Access, ACE designed custom reports including a batch report that listed over two hundred steps and a report detailing the daily nitrogen usage by the plant.

Bristol-Myers Squibb

ACE setup and configured two historians for the research and development facility in Hopewell, NJ. One historian collects GMP process data from the cell culture, purification, and CIP systems. The configuration of this historian was documented and the system was validated. In addition, ACE configured Wonderware Info Server to use the historian data for trend analysis and process visualization over the web. The second historian collected process data from non-GMP small-scale research labs throughout the building. Most of the underlying control systems were Allen-Bradley with Wonderware, however, data was also collected from a DeltaV system that was added later. Trend data from the non-GMP historian was also available through the site Wonderware Info Server portal.

Ciba-Geigy Corporation

ACE configured and implemented an InTouch/InSQL application that collected information from seven Modicon PLCs for the wastewater treatment, powerhouse and various process areas of the plant. Using Microsoft Access, ACE developed custom reports for each area that were made available to plant personnel over their network.

Domino Sugar

Wonderware’s InSQL package was used in this project to store LIMS data and collect process information from Allen-Bradley PLCs and Moore APACS systems. ACE configured InTouch nodes throughout the plant with real-time and historical trend displays to view the collected data.


ACE provided integration services to GlaxoSmithKline in Upper Merion Township, PA. This system involved over 60 fermenters and other process equipment. An InSQL application provided real-time collection of batch data from a Moore APACS control system, Allen-Bradley SLC & PLC, Siemens S7 PLC, and IOTech remote I/O. ACE configured trend displays to view the batch data historically or real-time from six InTouch stations in various areas of the plant. InBatch provided the batch engine to sequence the phases within the control system. ACE provided integration and on-site support as the fermenters were brought on-line.


Two Wonderware Historians were setup for MedImmune's production facility in Frederick, MD. One historian collects process data from GMP areas, including cell culture, purification, and CIP systems. The second historian collects from the plant utility systems. In addition, the GMP historian stores all alarm and event data from the site Wonderware InTouch system and maintains the CIP recipe and batch record database. A set of web-based tools and reports for reviewing historical process data, CIP reports, a monthly waste water report was developed using Wonderware ActiveFactory. ACE produced a full set of validation protocols for the servers and helped MedImmune qualify the systems and the data. ACE has continued our support of these systems through routine maintenance, additional report development, and database enhancements and additions.

Polycast Technology Division

In this project, ACE configured an InSQL application that collected over 10,000 data values from thirty PLCs used in the production of optical quality cast acrylic sheets. ACE configured InTouch stations with historical and real-time display trends for the InSQL data. In addition, the batch data from InSQL was written to an existing dBASE format used at that plant. Using Microsoft Access, ACE designed custom batch reports using the information in the dBASE database.


InSQL was configured to collect machine data from PLCs in two different plants producing golf balls. Using Crystal Reports, ACE implemented web-based reporting so that plant personnel could view production information and downtime reports on their local intranet.