SQL (Structured Query Language) also has become an industry standard. SQL is a command language that allows you to define, manipulate, and control data in SQL databases - and in other relational databases. Most database servers support SQL. SQL gives you direct access to database servers on other platforms, such as computers, mini-computers, and mainframe computers.
You can use the CitectSCADA Device functions to set up the format and locations of each of your SQL databases. Alternatively, use the SQL functions for direct control over SQL transactions.
You need to define a CitectSCADA Device to specify the format and location of the database, for example:
Name |
Recipe |
In the Format field, specify the field names in the SQL database, for example:
Format |
{Name,16}{Water,8}{Sugar,8}{Flour,8} {Salt,8}{Yeast,8}{Milk,8} |
The Header is the database connection string for ODBC connection, for example:
Header |
DSN = ORACLEDATABASE |
Enter the database table name in the File Name field:
File Name |
RECIPE |
Type |
SQL_DEV |
Comment |
Recipe Device (SQL) |
See Also