5/29/2024 8:25 AM | |
Joined: 9/12/2013 Last visit: 7/4/2024 Posts: 32 Rating:
|
Hello Experts, Can I run the WiCC RT Advanced as a service rather than starting it in the foreground? Also, I am trying to transfer data from PLC to the SQL database using the VB script in the SIMATIC PC station. I implemented this successfully by running runtime and installing SQL on the same machine. However, now I am trying to do the same with a remote SQL server on a different IP domain. As we do not need any visualization (screens) in the project is it possible to start WinCC as a service on one machine and export data to the SQL on another machine with different IP addresses? Please see the attached script for reference Please let me know how I can achieve this or if there are any other alternatives. I really appreciate any help you can provide. ------------------------------------------------------------------------------------------ |
Last edited by: zopeparag at: 05/29/2024 08:32:56Last edited by: zopeparag at: 05/29/2024 08:46:26Last edited by: Jen_Moderator at: 05/29/2024 11:32:07New subject after splitting |
|
5/30/2024 7:12 AM | |
Joined: 7/5/2013 Last visit: 4/17/2025 Posts: 3147 Rating:
|
Hi zopeparag, might the following be an option? No need of WinCC RT. Connecting a S7-1200 PLC / S7-1500 PLC to a SQL Database Regards, Frink |
Pi is exactly three! |
|
5/30/2024 8:00 AM | |
Joined: 9/12/2013 Last visit: 7/4/2024 Posts: 32 Rating:
|
Hi Frink, Many thanks for your response. We are already using this solution to get the data from a small part of our factory as a trial. However, we need to integrate other areas of the plant, and if we go with this solution, a lot of programming will be needed. For example, we had to construct the big command string ('insert into PLCDATA_1 values (7,8, 9)') with real-time values from the field. Also, there is only one trigger to execute the command, and we need to update one table in the database every minute and the other two tables on value change. So, we had to develop queuing logic to prioritise the command triggers. With more data to integrate, it will become more complicated very quickly. Also, if this solution succeeds, our management is looking to roll out this to multiple factories all over the globe. So we are trying to make it as easy, standard and scalable as possible, and that is why I came up with the idea of WinCC runtime and VB script solution so that we can run the multiple scripts independently with scheduled tasks or separate triggers. As per my understanding, we can run WinCC RT Professional as a service but not WinCC RT Advanced. Kindly let me know your opinion. |
Last edited by: Jen_Moderator at: 05/31/2024 06:21:38Text formatting optimized. |
|
Follow us on