Overview - ScadaLogger, a data logger & report generator::
ScadaLogger is a utility program that augments the data logging and report capabilities of SCADA systems that support DDE, OPC, or OLE data interfaces. ScadaLogger can be configured to maintain an unlimited number of archived files which are in CSV format. There is no limitations on the number of analog or discrete tags stored in each file.
Starting with version 2.2, ScadaLogger has built in math & logic capabilites. To view these capabilities, click here.
Custom reports are generated using Microsoft Excel®. These reports may be triggered on a time or event basis, all automatically. The following diagram depicts how the ScadaLogger interacts with the SCADA system and Excel®
For report generation, this software will provide you with the a friendly Excel environment without the complications of SQL Our ScadaLogger software does the tasks that Excel does not do - that is, when it is time to generate an Excel report, ScadaLogger will then,
1. open Excel,
2. load a ScadaLogger generated CSV data file,
3. runs the Excel calculations,
4. save the resultant report as a new time stamped Excel file,
5. prints the Excel report, if configured to do so,
6. close Excel
While the report generation activity is going on, ScadaLogger continues its tasks of data logging and starts generating new CSV file.
The of advantages in using our logger & Excel over SQL for report generation are:
1. Excel files are portable - SQL files are not. This means you can copy a CSV or Excel file to another computer to work on the files. If you are using SQL, you must normally be on the same network to view the SQL files.
2. You can edit CSV & Excel files - you can not edit most SQL files. As an example, if you have an erroneous turbidity measurement, in SQL it stays permanent. With ScadaLogger, you can correct the data and produce a "clean" report.
3. ScadaLogger is simple, requiring less skill and technical know how to configure & use than SQL.
Using SQL does have its advantages. SQL will normally use a rational database where Excel is a flat file. Thus, SQL is more powerful, especially for large amounts of data with complex data interlinks.
A full featured, trial package is available from our Download directory.