To transfer data to or from another database using ODBC, you need to configure an ODBC Query. The Query is used to extract the required block of data from the other database and store the data in a results table (see Configuring an ODBC Query). You then need to configure ODBC points of the appropriate type to extract individual data values from, or replace or insert individual data values into, the results table that is produced following the execution of the ODBC Query.
You configure the properties of each point using the fields on the appropriate ODBC Point Form. The ODBC driver supports the point types that are listed below. You need to configure those point types that present the extracted data in a suitable format within the ClearSCADA database.
- Analog Point—see Configuring Analog Points
- Digital Point—see Configuring Digital Points
- String Point—see Configuring String Points.
For general information on creating a point and displaying a Point Form, see Configuring a Point in the ClearSCADA Guide to Core Point Configuration.
For information on the minimal amount of configuration that you can undertake to produce a functional ODBC point, see Minimum Configuration.
The rest of this section explains how to: