We need an OPC client that can subscribe to an OPC server and bring back the data and store it in a MySQL database.
This is a desktop program for windows that can be written in C# or VB.
The user will specify the data/tag that the user wants to subscribe to and then specify what database, table and field to put it in. The OPC server can be local or remote and the MySQL server can be local or remote. It should be able to browse the OPC server to select the tag as well as browse the MySQL database for database, fields and tables. It should do a verification that everything exists before running. This should run as a windows server and should be able to have multiple instances running. Should be able to be set up to log by Interval time, if the timestamp changes or if the data changes.
It needs to be written in such a way that more databases can be added later.
Once it is running a status screen must be in place to notify the user of any problems (ie. loss of connection). If connection is lost then it needs to try to reconnect. Also should send heartbeat to make sure it's still connected.
Here is an example of what we are looking to imitate. <[login to view URL]>