DBLogger, basics

The WinCC OA DBLoggerallows 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. The amount and content of the information is tailored to the recipient's needs.

Advantages:

With the DBLogger, 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
BLogger, basics Explanation of the DBLogger
Requirements for the DBLogger Requirements and installation of the DBLogger
Databases Databases used in the DBLogger
Tables Structure of the tables in the databases
Archive groups Explanation of the archive groups
Starting and stopping the DBLogger How to start the DBLogger in WinCC OA
Configuring the DBLogger Explanation and screenshots of the various configuration panels for the DBLogger
Database tab Make the DBLogger 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 DBLogger
Data point types and data points Data point types and data points used in the DBLogger