zenOn installations use SQL Server for archiving

Many zenOn installations use SQL Server for archiving data, providing standardised storage for third party software such as ERP and higher level MES systems

Many zenOn installations use SQL Server for archiving data, providing standardised storage for third party software such as ERP and higher level MES systems.

Whilst zenOn automatically generates an FDA 21 CFR Part 11 compliant audit log, connecting to an SQL Server for archiving is particularly beneficial in food and pharmaceutical applications where specialised third partly traceability reporting is common.

Thomas Punzenberger, Managing Director COPA DATA commented, "zenOn is an open system and will always be compatible with the technology our customers use, having supported SQL Server 2000 we were first in line to support the new version, taking advantage of the new features and ensuring backwards compatibility for our customers".

COPA DATA has developed zenOn under a close relationship with Microsoft during the past 18 years, supporting VBA in the runtime, SQL Server.

Indeed, all zenOn versions have been developed for Windows platforms, including the first Windows CE HMI SCADA software.

Christian Beyrl, Manager Server and Tools Platform at Microsoft Austria commented, "Our experts worked closely with COPA DATA to develop an interface that fully utilises the new security features and improved performance of SQL Server 2005 that benefit manufacturers directly in their operations".

When archived to an SQL server, the data is easily retrieved using the zenOn software with a few mouse clicks.

Designed for longevity, zenOn is backwards compatible with the popular SQL Server 2000.

Backwards compatibility is ensured making sure data recorded to an SQL 2000 database is fully accessible from the archive section of zenOn following customer migration to a new SQL server 2005.

Security is a hot topic in the process industry, specifically SCADA systems.

An SQL Server is typically used as part of a zenOn-based system specifically to allow multiple users or systems on disparate systems to access a shared database.

In a complex system with many connections, the new enhanced security model and encryption options built into SQL Server 2005 promise improved process safety and security.

Back to top