Saturday 23 July 2016

OPC to SQL

OPC2SQL is a simple tool/application for polling data from OPC Server to SQL Database periodically.

The block diagram:

OPC Server         : WinCC, RSLinx, etc.
SQL Database : MySQL, MS SQL Server, etc


Follow the steps below:

1. Open the application.

2. Open Configuration tab, input all data, then Save

3. Make sure with OPC Server and OPC Items.
 

 4. Make sure with Database, Table and Columns.

5. Click Activate on Runtime tab. See the result. 



Please download the demo version HERE.
Contact hadiscada@gmail.com for full version, requests more features, some modifications, and source code.

Thank you.. :)

2 komentar:

  1. Dear Hadi,

    I am interesting to know more about the full version of the software OPC to SQL. Currently, I need to communicte a PLC Festo CPX, running on Codesys, with a MySQL DataBase. At the begining, I shall need 9 variables to communicate, this communication would be automatic every 500 ms.

    Could you help us?

    I would thank a reply about this.

    Yours faihtfully,

    ReplyDelete

 
Copyright © . HadiSCADA - Posts · Comments
Theme Template by BTDesigner · Powered by Blogger