The Orchestrator ODBC interface (Open Data Base Connectivity) Provides a means by which data from Orchestrator can be transferred directly to any ODBC compliant database.

All of the information within Orchestrator is stored as proprietary binary or text information.

As such, this information is only usable by certain applications and the user may not be able or permitted to access this information.

The Orchestrator ODBC Driver is designed to provide the user with a way of uniformly accessing this information without having to know what format is used or where the information is stored. 

Using the Orchestrator ODBC Driver, you can access the current channel configuration, current data values, header text, logged text, logged alarms and the information stored in the log files.

Structured Query Language (SQL) is used to allow users to query a variety of different data sources in the database management system.

All of the Orchestrator data files are non-SQL compliant so SQL can not be used to read this information. The ODBC Driver provides an SQL compliant interface between SQL Query Applications and Orchestrator.

In basic terms, an application like MS Access or MS Query, can process information from a database source, which is stored in a format it knows how to read.

The ODBC driver receives the SQL query from one of these applications, it then knows how to read the information held in the Orchestrator data files and builds up a result list for the query and returns the information to the calling application.

MS Access, MS Query, Excel or other ODBC compliant applications can be used to view the data returned.