This driver is a stand-alone driver. It provides additional functionality to enable ClearSCADA to interface with specific supported systems or devices. To interact successfully with such systems or devices, you need to:
- Install and run the driver
- Ensure that the driver is licensed
- Configure the required database items and settings on the driver
- Ensure that the database items (and any database items on which they depend) have valid, saved, configuration and are 'In Service'.
The SQL Export driver enables you to write SQL queries to interrogate the ClearSCADA database and export the results of those queries to file. The SQL Export driver can export the SQL query results in either Comma Separated Value (CSV) or Tab Separated Value (TSV) format. You define the SQL queries that ClearSCADA is to execute and the format and location to which the results of those queries are to be exported, using fields on the relevant configuration Form—one Form per SQL Query.
This guide explains how to Add and Configure an SQL Export item in ClearSCADA.
It also explains the driver-specific features that are of interest to operators:
and the SQL Export driver specific features may be of interest to system administrators and engineers when investigating unexpected system behavior (relating to the SQL Export Driver):