Realtime Group

Using transaction groups to update specific rows in a database is an easy way to expose OPC data to systems that cannot access OPC server but can query a SQL database.

To update the first row in a database

  1. Create a new Standard group and drag your OPC tags into the Basic OPC/Group Items area.

  2. On the Action tab, select the appropriate Timer, Data source, Table name, and other various settings.

  3. In the Table action area of the Action tab, select update/select, and first which will continue to update the first row of the database according to the timer.
    To update a specific row rather than the first row in the database, select the custom or the key/value pairs options.

  4. Select the group, click Enabled and do a File > Save to start it.
     The transaction group will only write the values that have changed to the database thus reducing the overhead.