This driver is a stand-alone driver. It provides additional functionality to enable Geo SCADA Expert 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'.
Intended Audience
This guide is designed for use by all levels of user:
- Engineers who are responsible for adding and configuring SQL Export items in Geo SCADA Expert
- Operators who use the actions that are specific to the SQL Export driver
- System administrators who are responsible for investigating any unexpected behavior relating to the SQL Export driver.
Document Scope
The SQL Export driver enables you to write SQL queries to interrogate the Geo SCADA Expert 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 Geo SCADA Expert 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 Geo SCADA Expert.
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):
- SQL Export Specific Status Attributes
- SQL Export Specific Colors
- SQL Export Specific Driver Log File Options.
Prerequisite Reading
This guide contains technical information that is intended for users that are sufficiently familiar with Geo SCADA Expert configuration and operation. Before reading this driver guide, ensure that you are familiar with:
- Geo SCADA Expert configuration practices, procedures, and the configuration of properties that are common to many database items. For more information, see the Geo SCADA Expert Guide to Core Configuration, and the Geo SCADA Expert Guide to Core Point Configuration.
- Driver structure, components, and configuration properties, pick actions, and status attributes that are common to many drivers. For more information, see the Geo SCADA Expert Guide to Drivers.
Some sections of this guide are intended for operator-level users. These sections are intended for users that are familiar with the navigational and operational aspects of Geo SCADA Expert. Before reading the operational sections in this guide, ensure that you are familiar with:
- The Geo SCADA Expert user interfaces (ViewX and Virtual ViewX), the various types of display, their navigation and operation. For more information, see the Geo SCADA Expert Guide to ViewX and Virtual ViewX Clients.