Report Open Access

Grafana for WinCC-OA based SCADA systems at CERN

Yash Kataria

WinCC-Open Architecture is a toolkit for creating Supervisory Control and Data Acquisition (SCADA) applications. There are about 650 instances of WinCC OA deployed across the accelerator control systems and experiments at CERN. By default WinCC OA is only aware of the current state of a system; WinCC OA Archiving is used to keep a historical record of changes that occur to the state of the system.

The WinCC OA archiving solutions deployed at CERN, the legacy 'RDB Archiver' and its replacement the 'Next Generation Archiver' (NGA), archive to Oracle databases, and for the most part the design and configuration of these databases is consistent between archivers and across CERN. Monitoring and visualising the data archived to these databases is a vital task.

Grafana is a multi-platform open source analytics and interactive visualization web application. The goal of this project is to develop a Grafana Datasource that abstracts away the CERN specific Oracle database schema design and hence allows a Grafana user to intuitively retrieve WinCC OA archived data. Any proposed datasource solution must also meet performance and scalability requirements, and meet CERN security standards.

This report details the extensions and modifications to a prototype Grafana datasource to achieve the goals described above. We detail the progression of the work and the technologies and technical solutions used. Additionally we detail several deployment scenarios that address performance and security requirements as they relate to CERN infrastructure, and give details of work completed to automate this deployment.

Files (784.7 kB)
Name Size
CERN_openlab_SUM_report_Yash_Kataria.pdf
md5:831200a743102c8b605f02ccc33f8fa7
784.7 kB Download
103
61
views
downloads
All versions This version
Views 103103
Downloads 6161
Data volume 47.9 MB47.9 MB
Unique views 9797
Unique downloads 6161

Share

Cite as