Home
Engineering
Powerful tools for easy or complex engineering tasks.
System Management
The System Management is the central administrative unit for WinCC OA Systems.
Reports
SQL in CONTROL
The database functions enable you to quickly carry out value queries on data points and elements.
Control functions for SQL

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.
- Project Administration
  The chapter contains a description of the process monitor as well as the project administration.
- Graphics Editor (GEDI)
  Used for creating and editing panels, provides tools for creating and configuring graphic objects.
- System Management
  The System Management is the central administrative unit for WinCC OA Systems.
  - System management
  - Diagnostics
  - Reports
    - Variable Trend
      A set of panels and scripts used for the simplified display of trend curves and trend groups (up to 16 trend curves).
    - 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.
    - Service protocol
    - WinCC OA Excel Report
      With the WinCC OA Excel Report reports can be created. Templates are used for reports. If a report should be created for a specific time, the system uses the templates and automatically fills the template with data from the process database. Reports can also be created, printed and saved time-controlled without user access. For more information, see chapter Excelreport/topics/excel_report_basics.html.
    - SQL in CONTROL
      The database functions enable you to quickly carry out value queries on data points and elements.
    - Data Point Element Monitor
  - Database
  - Driver
  - Driver IEC
  - Driver OPC
  - Driver S7
  - SmartSCADA
  - Permission
  - Communication
  - Settings
- Wizard Framework
  Used for easy creation of wizards in a uniform layout style. The key elements "Navigation Bar" and "Bottom Bar" can be customized to fit the needs of the custom wizard.
- XML Panel Format
  The XML (Extensible Markup Language) panel format allows creating WinCC OA panels.
- Simple Symbols, basics
  The "Simple Symbols" functionality is used to simply assign corresponding symbols to data point types and increase the working comfort when working with different symbols.
- ScriptWizard
  Simple wizard for creating graphical user interfaces for users without prior programming knowledge.
- Panel topology/Group alert facility
  Tree structure for process panels with integrated group alert system
- Object-Oriented Panel References
  Reusable objects built with the GEDI tools. Insert them within an existing panel to provide a graphical element.
- Multilingual Projects
  WinCC OA is designed to provide both Native Language Support and Multi Language Support.
- Translator
  The WinCC OA Translator functionality supports you in creating and maintaining multilingual projects. It offers a convenient interface for translation of reusable terms.
- Layout management
  Layouts change the size and position of objects according to parameters previously defined in the GEDI.
- Generic Dialog Framework
  The Generic Dialog Framework is an easy way to generate your own dialogs by adjusting a set of prefabricated panels.
- Simple Configuration
  Simple configuration windows and panels support you in combining events (such as a mouse click) with different actions such as setting data point values, showing panels or changing attributes.
Data Management
Classify, structure and archive your data.
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.

Control functions for SQL

The functions listed comply with the general SQL syntax. For more information about SQL, refer to the relevant literature.

Control functions:


dpQuery()	dpQueryConnectAll()
dpQueryConnectSingle()	dpQueryDisconnect()

In an SQL query, there should be no line change in the script within dpQuery. This is governed by the SQL syntax.

The abbreviations UI (User Interface), CTRL (Control) and DP (data point function or alerting action) indicate where the function concerned is available. Control functions with the character 6 block the execution of a script until a response is received from the Event Manager (see also Control/Availability manual).