Query SQLite Database in WinCC Unified PC

Hi All,

I have a SCADA system that receives data from a power meter. One of the values is total accumulated power and I want to show monthly power consumption. To produce that value, I need the total accumulated power at the beginning of the month, so need to query the existing SQLite database. Is it possible to do it in WinCC unified?

Thank You

Hi Julham!

Yes, it is posible. You can check it in this FAQ:

WinCC Unified: Use of SQLite or Microsoft SQL databases

Thank You for the reference,

Is the query capability also available in SQLite database or just available in Microsoft SQL server?

You can query in SQL Lite as described in this tutorial:

https://www.sqlitetutorial.net/sqlite-select/

Thank you for the information Mr. Murof,

Compression might not suit my current needs. I want to subtract the current value with a setpoint based on user timeframe selection.

Thank You.