The Server Configuration Tool includes an SQL Query Configuration branch.
The branch includes settings that you can use to:
- Create, modify and remove Historic Views. Historic Views allow applications to access historic data logged at uniform intervals.
- Create, modify and remove Linked ODBC Tables. These are external tables that can be searched within SQL queries in Geo SCADA Expert.
- Edit various SQL Query Parameters. This includes defining the limits for a single SQL Query result set. You can also specify whether SQL Queries can be edited using the clients on this server, and whether the Guest user can execute SQL on the server,