Information Server, basics

The WinCC OA Information Server (IS) allows the export of user-definable data from WinCC OA into an external database (DB). A range of analysis tools can be used to access this database:

Intranet applications,

modern reporting tools,

OLAP (Online Analytical Processing) software

and all other ADO/ODBC-compatible software.

The possibilities range from reports in Microsoft Excel right up to web trends and web reports. The appropriate information can be supplied for each department in the company, whether as batch reports, measurement curves or the latest production statistics.

A relational database forms the heart of the system, supplying the information to all recipients. Batch data, measurements and count values are stored here, as is the current room temperature. It is not necessary to have a separate SCADA system for visualizing this data; all you need are office tools such as Excel, Access or a web browser. The amount and content of the information is tailored to the recipient's needs.

Advantages:

With the Information Server, WinCC OA guarantees separation of the control center from the information platform of the business. All external accesses are made to the relational database system, which normally runs on a standalone computer.

WinCC OA generates and controls the information flow to this database. Since one can configure the data flow, and thus know and plan its behavior, the required reliability can be achieved here.

Any overloading or failure of the external database system does not impair the master computer on which WinCC OA is running. In the same way, any new installation of systems such as web servers, or reporting or OLAP software, will have no adverse effects.

The same data can be accessed simultaneously by company management, the accountancy department, project management or technical staff.

Chapter	Description
Information Server, basics	Explanation of the Information Server
Requirements for the IS	Requirements and installation of the IS
Databases	Databases used in the IS
Tables	Structure of the tables in the databases
Archive groups	Explanation of the archive groups
Starting and stopping the IS	How to start the IS in WinCC OA
Configuring the IS	Explanation and screenshots of the various configuration panels for the IS
Database tab	Make the IS known of a database
Table type tab	Defining a table type in the database
Table tab	Creating a table of the defined table type
Archive group tab	Creating an archive group
Advanced functions	How to configure advanced functions available in the IS
Data point types and data points	Data point types and data points used in the IS
Working with the IS	Example of working with the IS
Glossary	Key abbreviations and terms
Summary and relevant links	Collection of links to other relevant chapters in the Online Help

V 3.11 SP1