• State Not Answered
  • Replies 2 replies
  • Subscribers 583 subscribers
  • Views 144 views
  • Users 0 members are here
Options
Related

Plant SCADA Trend Data Logging in SQL

Sanjay Dharia

Hello Experts, We are looking solution of Plant SCADA Trend & alarm data logging to SQL Database located at different PC in same network without using Historian server.
How can we Log Trend data to SQL Database without interruption, If communication fails for some time between Plant SCADA & SQL Database after comm restore, automatically Trend data should backfill in SQL.
If we use ODBC connection then it only stores real time Data. We required continuous data logging even if communication fails & restore. Thanks in advance

Parents
  • 0

    For your requirements, the best solution is a historian. If you don't want this, then the only thing left is building a custom solution, either in cicode or in an external application using ctApi.

    You will need to implement solutions for communication failures, backfilling, etc. by yourself, possibly for redundant architectures as well.
    Details on how to implement this, are beyond this forum I believe. If you want to pursue this option I recommend hiring a Certified Plant SCADA partner / engineer.

Reply
  • 0

    For your requirements, the best solution is a historian. If you don't want this, then the only thing left is building a custom solution, either in cicode or in an external application using ctApi.

    You will need to implement solutions for communication failures, backfilling, etc. by yourself, possibly for redundant architectures as well.
    Details on how to implement this, are beyond this forum I believe. If you want to pursue this option I recommend hiring a Certified Plant SCADA partner / engineer.

Children
© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.