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 |