Hi everyone, I would like for a recommendation to log data in a new project..... we are considering a plc s7-1200 to acquire data for a sensor, and a HMI comfort to show something similar to charts or trend views with this data...

but I'm not sure if it would be enough... regardless we would have a sample of the tag every 8 seconds... and the client wants to store a total year of this values..... so we need to store like 45 millions of values in a DB....

If we use the "Historical Data"in the HMI comfort we can log only 500k values in a log.... that is much less than we want....... so I'm not sure if we can log like in 10 different logs instead of just one
(I'm not sure if it is possible to ones a log is full change to another log) or we need to add a IPC to have a DB like mySQL and then connect it to the hmi, and visualize it in the hmi...

also I'm not sure if a comfort hmi can connect to a SQL in an IPC......

I hope you can give me some recommendations and clear my dubs about this project, i don't want to an error in the selection of  the equipment...

Hello,

you can use diferent solutions.

e.g.

• use OPC-UA with a external PC (OPC_Client) and Simatic Net
  then can you write the data in a SQL-database
• use a external datalogger e.g. IBApda from the IBA AG
• use a connection between a HMI-panel and a database

regards
CaOd

Hello,

You can use "DotNetDatenbankProtokollerV2".

https://github.com/dotnetprojects/DotNetSiemensPLCToolBoxLibrary/