S7-1200/1500 Data Logging in MS SQL using Python

What is the maximum useful logging rate (in Hz)?  100?

naveen_paliwal

Dear All,

you can use code given in below link to log S7-1200/1500 data in MS SQL using Python script which is very fast and compact in size and the best thing you don't need WinCC or any other SCADA for data logging. 

https://s7-1200-data-in-sql.blogspot.com/2022/12/import-pyodbc-import-snap7-from-snap7.html

Steps:-

1. Download & Install python https://www.python.org/downloads/

2. Install Snap7 library using "pip install python-snap7" command in CMD prompt.

3. Make a DB & Table in MS SQL.

4. Done.

We have logged data at 5000 Hz using UDP to a PC application accepting the data (could be written in python since it's just a data blob).  Only thing is that there's no flexibility of requesting different data points at any time.  It's always the same predefined data all the time.

The limit for s7-1200 is ~100 Hz which is faster than the s7-1200 analog I/O (typically) updates, so  not matter.  In a slightly larger application, ~50 Hz is optimal as it provides no errors: no missed, stacked or poorly timed data.

Something to consider should you need high speed logging for future applications.  FYI, UDP only works (reliably) when the PN cable goes directly from the PLC to the PC and has no other computer traffic to deal with.  We use a 2nd LAN adapter on PCs strictly for the control network and only for a single PLC.  That isolates all the business traffic and keeps the PLC from having to ignore lots of useless requests.

naveen_paliwal

 1 Hz is tested for 50 tags (any specific data is not available) which is generally not required in most of the cases. Normally we use 1 minute logging cycle maximum.

0_Einstein

What is the maximum useful logging rate (in Hz)?  100?

naveen_paliwal

Dear All,

you can use code given in below link to log S7-1200/1500 data in MS SQL using Python script which is very fast and compact in size and the best thing you don't need WinCC or any other SCADA for data logging. 

https://s7-1200-data-in-sql.blogspot.com/2022/12/import-pyodbc-import-snap7-from-snap7.html

Steps:-

1. Download & Install python https://www.python.org/downloads/

2. Install Snap7 library using "pip install python-snap7" command in CMD prompt.

3. Make a DB & Table in MS SQL.

4. Done.