The OPC Recipe.NET product provides data transfer from databases to OPC data. The data target can be from local or remote OPC Systems Services of Tag Parameter Values. The execution can be continuous up to 1 second speed, event driven from a Tag Parameter value, or at a specific time of day. The database providers can be SQL Server, SQL Server Desktop (MSDE), Access, Oracle, mySQL, or ODBC.
There are 3 basic table structures that can be used as a data source.
• Multiple Records allows you to define one column for the target OPC Systems.NET Tag names and one column containing the values to write.
• Single Record allows you associate Field Names with OPC Systems.NET Tags. During execution the values in first record returned are sent to the tags.
• Queued allows you associate Field Names with OPC Systems.NET Tags. During execution the values in first record returned are sent to the tags and then after all values are confirmed to be successfully sent the record is deleted.
Using remote OPC Systems Services helps simplify security connections as there will be no remote DCOM setup necessary as all OPC Servers can be connected as local.
Refer to the Quick Start Example-Configure Recipes section for a step by step simple example of using OPC Recipe.NET.
For description of all properties of the recipe configuration refer to the OPC Systems Configuration-Recipes section.
View the following video for a step by step tutorial on setting up recipe executions.