Posts Tagged ‘Connector’

How the zenon Analyzer connectors work and how they are used in practice.

Tuesday, June 4th, 2013

The zenon Analyzer reports are based on process data from HMI/SCADA systems. In order to avoid redundant data these data are not stored directly in the zenon Analyzer. When creating a report the data are loaded into the zenon Analyzer using our so called ‘connectors’. Depending on the location of the data, we provide two different connectors.

The SCADA Runtime Connector is used to load data directly from the SCADA runtime, whereas the SCADA SQL Connector is used to load the data directly from SQL databases.

For increased availability the SCADA Runtime Connector is capable of working in a redundancy environment and connects automatically to the standby server if required.

Connector types

Each connector works in a different way:

SCADA Runtime Connector:

zenon Analyzer_Runtime Connector

This connector consists of two components. An extension of the Microsoft SQL-Server directly on the Analyzer Server (the so called ‘ZRS Provider’) and the connector container incl. the connector plug-in  installed on the SCADA runtime computer. When requesting a report, the ZRS Provider connects via the network to the connector container. Its plug-in contacts the runtime using the COM interface and the runtime delivers the requested data which are sent back to the ZRS Provider. Now the Analyzer Server can access the data for further processing.

The big advantage of this connector is the possibility of using actual data from the runtime.

The connector can access:

  • Actual values from variables
  • Historical values from variables
  • Lots
  • Alarms
  • Chronological Event List

 

SCADA SQL Connector:

zenonAnalyzer_SQLConnector

This connector directly accesses process data evacuated in databases. The database server used for storing these data just needs to be added once in the ‘zenon Analyzer Management Studio’ as a linked server and can be of any type of SQL-Server, Oracle server or ODBC-Server.

The data are accessed directly with Table Valued Functions in order to ensure optimal performance.

The big advantage of this connector is the speed of the data connection and the independence from the HMI/SCADA runtime.

The connector can access:

  • Historical values from variables
  • Shifts
  • Lots
  • Alarms
  • Chronological Event List

 

Open data interface

All connector functions can be accessed directly and manually in the SQL Server of the Analyzer Server using Table Valued Functions. So you are free to develop your own reports.

Furthermore, you can develop customized connectors according to your data and your needs.

SCADA SQL Connector:

If you need a personal, network-based connector, it is possible to develop an own connector plug-in as a dll file.

SCADA SQL Connector:

For individual connection to databases the SQL Connector has an open SQL interface. By using Table Valued Functions you can program your own connector accesses to any data format.

Conclusion

The connectors are a very easy and comfortable way of retrieving the data you need for reports, regardless of whether you use our predefined reports or if you wish to develop your own reports. The interfaces allow them to be customized and modified to suit the customers` needs.