A system only needs to run the Geo SCADA Expert ODBC driver in order for Geo SCADA Expert to transfer data to and from another database, using ODBC.
It is also possible for other applications to use ODBC to access the Geo SCADA Expert database. This section summarizes the requirements that enable other applications to access the Geo SCADA Expert database in this way.
In order for other applications to access the Geo SCADA Expert database using ODBC, you need only install the appropriate Data Access components of Geo SCADA Expert on the client computer (the computer that is running the application that is to access Geo SCADA Expert using ODBC). (If the client computer is to run as a full Geo SCADA Expert client, as well as run the other applications that are to access Geo SCADA Expert using ODBC, you also need to install the appropriate Geo SCADA Expert Client components.)
Where applications do not have a separate user account, access is via Geo SCADA Expert’s Guest User account (see Configuring the Guest and Web User Accounts in the Geo SCADA Expert Guide to Security).
The ODBC data access interface can be used to access Historic Pseudo tables within Geo SCADA Expert. For information on the fields that these tables contain, see the database Schema. For information on the database Schema, see Working with the Database Schema in the Geo SCADA Expert Guide to the Database. You can also use ODBC to access the data in 'custom' tables, such as Data Grids. For information on using Data Grids, see Configuring Data Grids in the Geo SCADA Expert Guide to Core Configuration.
You can enable logging to monitor any unexpected system behavior when ODBC is used to access to the Geo SCADA Expert database. For more information, see ODBC Logging in the Geo SCADA Expert Guide to Client Administration.
For information on the SQL Queries that have been used to request data from Geo SCADA Expert, view the various Queries categories in the Geo SCADA Expert Server Status Tool’s Query Processor folder (see Server Status Categories in the Geo SCADA Expert Guide to the Server Status Tool).