Home
Data Management
Classify, structure and archive your data.
SQL Panel
The SQL panel allows you to enter SQL statements to perform queries on current and archive data in the WinCC OA database.
Other functions

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics, you need to know, before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
Data Management
Classify, structure and archive your data.
- Archiving
  Overview of the archiving solutions currently available in WinCC OA
- Module PARA
  Graphical interface for editing datapoints and datapoint types.
- Common Name Service (CNS)
  The plantmodel editor can be used for building and modifying data structures such as views and trees based on CNS and use them within projects easily.
- Mass configuration
  Mass configuration in WinCC OA redefines the fundamental principles of setting up a project and subsequent configuration of the huge range of data points.
- SQL Panel
  The SQL panel allows you to enter SQL statements to perform queries on current and archive data in the WinCC OA database.
- ASCII Manager
  The ASCII Manager allows you to input and output and thus edit data points and data point types and to configure data points.
- Correction Values and Laboratory Values
  These panels can be used to change existing values (=correct), query values from and add new values too the HistoryDB and RDB.
- Data Point Groups
  The main purpose of grouping data points is to simplify selection of datapoints and datapoint elements.
- Delayed Alerts
  An alert delay can be configured with delayed alerts. This allows short range changes to be filtered out.
- Relational Databases with Control-ADO
  The DB interfaces in WinCC OA offer the possibility of an access to external databases.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
WinCC OA Documentation
Basic information about terms and functions within the documentation.
Disclaimer
A brief clarification of liability exclusions or legal notices.

Other functions

The SQL panel has additional buttons at the bottom:

Link to the online help for the current SQL statement.

A SQL statement is saved in <proj_path>/dplist. You can use any file name. The extension for this file must be .txt.

You can select a file containing a query command from the <proj_path>/dplist directory. You can open files containing saved queries from the SQL panel or in a plain text editor (e.g. Notepad); the query is displayed in the bottom line of the SQL panel and can be launched on the Data tab.

The statements specified on the various tabs are put together into a single query by clicking this button. After opening an existing query it is not necessary to press this button.

Clicking the "Create query" button does not query data from the database. Only pressing "Start query" on the Data tab actually generates the query and displays the results in the window on this tab.

Closes the SQL panel.