The OAS Recipe product provides data transfer from databases to OPC data. The data target can be from local or remote OAS 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 three (3) basic table structures that can be used as a data source:
- Multiple Records allows you to define one column for the target Open Automation Software Tag names and one column containing the values to write.
- Single Record allows you associate Field Names with Open Automation Software Tags. During execution the values in first record returned are sent to the tags.
- Queued allows you associate Field Names with Open Automation Software 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 OAS 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 Getting Started Configure Recipes section for a step by step simple example of using OAS Recipe.
For description of all properties of the recipe configuration refer to the OAS Configuration – Recipes section.
You can read values from SQL Server, Oracle, Access, and MySQL based on event, continuously, or time of day with a dynamic query to filter what data is returned.
The values are then written to Open Automation Software Tags and on to OPC Items if desired with full confirmation that the values in the database are successfully transferred to the device or software application that is the destination.
By using the product OAS Recipe this is easy to setup.
Other resources for recipe applications: Programmatically Access Recipe Groups
Note: If you just want to read the data values or alarms from a database to your .NET application you can use the OPC Trend and OPC Alarm controls with the GetTrendDataTable and GetAlarmDataTable methods along with the HistorySelect methods.