Open Automation Software
Moving Data From Anywhere to Anywhere
1-303-679-0898

Recipe Database Properties

Recipe Database Properties

Recipe Provider

Database provider to use:

  • SQLServerDesktop_MSDE: Use SQL Server 2014 Desktop or MSDE database engine.
  • SQLServer: Use SQL Server or SQL Server Express.
  • MSAccess: Use Microsoft Access Jet Database engine.
  • Oracle: Use Oracle OLE-DB Provider. Does not automatically create database. You must create the database schema first to use this provider. Download OLE-DB Provider from http://www.oracle.com/technetwork/database/windows/
  • ODBC: Use ODBC data source. Does not automatically create database, table, or field names. You must create database, table, and all fields with the proper names and data types first to use this provider.

Recipe Server

The name of the Server to use when the Provider is set to SQL Server Desktop or SQL Server.

Recipe Set Server Name with Tag

When enabled the Server name can be dynamically set with a Tag Parameter value when the Provider (see above) is set to SQL Server Desktop or SQL Server.

Recipe Database

The name of the Database to connect to. When using Microsoft Access specify the full path of the database. Example: C:DatabaseName.mdb.

Recipe Set Database Name with Tag

When enabled the Database name can be dynamically set with a Tag Parameter value.

Recipe Table

The name of the database Table to read the data from.

Recipe Set Table Name with Tag

When enabled the Table name can be dynamically set with a Tag Parameter value.

Use WinNT Authentication

Use Windows Logon Security Authentication when the Provider (see above) is set to SQL Server Desktop or SQL Server.

Recipe User Name

User Name for database security.

Recipe Password

Password for database security.

Recipe Query String

This text is appended to end of the database query to retrieve the data.  It can also be dynamically be set from an OPC Systeme.NET Tag of a String data type. An example: WHERE [BATCH_NUMBER] = 5 ORDER BY [LOT_NUMBER].

Recipe Set Query String with Tag

When enabled the Query String parameter is automatically set from the defined Open Automation Software Tag. This allows dynamic assignment of the additional Query String to apply addition query and sorting arguments based on real-time data. Typically a Tag with a data type of String is used that has the data source defined as Calculation. This way real-time data automatically determines the additional Query String.