Home
Northbound Interfaces
Your portal to the cloud or supervising systems.
OLE DB Provider
OLE DB is a Microsoft specification for accessing data on different computers. It is based on Microsoft's COM technology and is the successor to the older and limited ODBC technology.

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.
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.
- MQTT Publisher
  The MQTT publisher provides a northbound data interface for MQTT clients to data point values within the WinCC OA project.
- Node-RED
  Node-RED is a flow-based programming tool that allows the creation of applications in a graphic environment.
- OPC UA Server
  The WinCC OA OPC UA Server provides an OPC UA interface to access WinCC OA data point values, alarms and historical data.
- OPC Server
  The OPC Server enables the communication with OPC clients.
- OPC HDA
- OPC Alarms & Events
  OPC Alarms & Events (brief OPC A&E) is in addition to the Data Access another standard in order to implement a central alert management manufacturer spanning. OPC A&E is used to guarantee the coupling with other control systems as well as to display alerts and events in a hierarchical system
- Modbus/TCP Server
  The Modbus/TCP server provides the possibility for Modbus/TCP clients to query data from a WinCC OA system and arrange the data within a Modbus data model.
- SNMP
  SNMP (Simple Network Management Protocol) is a protocol for monitoring network devices (servers, workstations, routers, switches and hubs etc.) and their functions. It allows you to administer your network.
- OLE DB Provider
  OLE DB is a Microsoft specification for accessing data on different computers. It is based on Microsoft's COM technology and is the successor to the older and limited ODBC technology.
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.

OLE DB Provider

OLE DB is a Microsoft specification for accessing data on different computers. It is based on Microsoft's COM technology and is the successor to the older and limited ODBC technology.

While ODBC uses static APIs for data access and is limited to SQL, OLE DB uses ADO to provide a quick and easy facility for programming applications. You can find an example of the ADO access to the OLE DB provider in the source directory, WinCC_OA_Path/source/SampleHistDB.xls.

The WinCC OA OLE DB provider tool enables access to the historical data of WinCC OA from external programs such as Crystal Reports, MS Excel, MS Access and many others in such a way that sophisticated reports can be created using these external tools.

The OLE DB provider includes the following functions:

Querying historical data
Prioritizing queries in the archive
Querying alarms.
Access by external reporting tools (for example, Crystal Reports)
SQL support (with certain limitations)
Conversion of WinCC OA data types into OLE DB data types

Figure 1. Access through the OLE DB Provider


Chapter	Description
OLE DB provider, basics	Introduction to the OLE DB provider and its functions
Requirements for the OLE DB provider	Installation, system requirements and limitations
Integrating OLE DB provider in WinCC OA	Data transfer diagram and possible configuration
Example queries	A list of some examples using SQL expressions to query historical values and alarms in WinCC OA
Example: how to query data using MS Excel	This example shows how to query data using MS Excel.
The SQL query language	Supported commands, operators and functions, plus SQL tips and tricks
Fields in the HISTVAL table	Columns in the HISTVAL table whose entries can be queried using SQL
Fields in the ALERTS table	Columns in the ALERTS table whose entries can be queried using SQL
Prioritization of queries in the archive	Description of Query prioritization. Query prioritization loads the archives less with OLE DB provider queries than with DM.
Data types for OLE DB provider	Permitted data types and their conversion
Entries in the configuration file	Possible entries in the Config file for working with OLE DB provider
Summary and relevant links	Other relevant chapters of the Online Help