This section describes Structured Query Language (SQL), Open Database Connectivity (ODBC), and accessing Citadel data using both SQL and ODBC.

SQL

SQL is an industry-standard language used for retrieving, updating, and managing data. In LabVIEW with the Enterprise Connectivity toolkit and in Lookout, you can use SQL to build queries to extract data from a Citadel database. The Citadel ODBC driver also includes many built-in data transforms to simplify statistical analysis of retrieved data.

ODBC

ODBC is a standard developed by Microsoft. ODBC defines the mechanisms for accessing data residing in Database Management Systems (DBMSs). Nearly all Windows-based applications that can retrieve data from a database support ODBC.