Using CitectSCADA > Exchanging Data with Other Applications > Using External Databases > SQL databases

SQL databases

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