Is there a reporting/data extraction tool that I can use with/over PCS7, that can do the advanced reporting tasks? This includes daily/weekly reports, ondemand reports, Calculations involving complex mathematical algorithims and use of Archived Values, etc. I think this will be an SQL based applicaition but which one?

 

It depends on your budget really, but you might want to look at a historian system like OSI PI.

www.osisoft.com

This will report anything and everything you ever wanted to know.


Rob
www[.]lymac.co.nz

 

Look at www.iba-ag.com
There are a lot of tools for your purpose.
ibaAnalyzer with reporting and also S7Analyzer.
Or ask for detailed information there.


Werner
www.ipw-prozess.de

 

Hello,

We have a web based reporting solution based on PostgreSQL database + Apache web server. The online part does trending and bound checking. Periodic (weekly, daily, per shift, ...) reports are done with Openreports and either sent to the recipient by email or placed in the file system. You can create your report templates to fit particular needs. Besides, PostgreSQL has ODBC and JDBC interfaces, so you can access the data from Octave or Matlab to carry out really complex data processing.

The data is acquired with Plantstreamer via OPC DA.

Please contact me at andrey(at)ciengis(dot)com if you need further info.

Best Regards,
Andrey Romanenko
Ciengis - Advanced Process Control and Optimization