You can link Fernhill SCADA data tables into Microsoft Access. The Fernhill SCADA ODBC driver provides the link between the two software applications. Microsoft Access will forward queries on the linked tables to Fernhill SCADA.
Step 5 of this guide requires an ODBC Data Source Name to be configured for Fernhill SCADA. For more information see Setting up an ODBC DSN.
1. Start Microsoft Access.
2. Do one of the following:
3. On the External Data tab, in the Import & Link group, click ODBC Database. The Get External Data - ODBC Database dialog opens:
4. Select Link to the database source by creating a linked table. Then click OK. The Select Data Source dialog opens:
5. Select the Machine Data Source tab:
Note: The list of data sources on your computer may be different to the list shown above.
6. In the Data Source Name list, select My Fernhill SCADA. If you used a different name when setting up your ODBC User Data Source Name, use that name instead. Click OK. The Import Objects dialog opens:
Note: The list of tables depends on the tag types used in the project currently running.
7. Select CommonBase.TagDataPointAnalog. Click OK. The Fernhill SCADA database table will now be linked to your Microsoft Access database as CommonBase_TagDataPointAnalog:
You can create queries and reports on the CommonBase_TagDataPointAnalog table like any other Microsoft Access table.
To learn about configuring ODBC data Source Names.
Fernhill SCADA ODBC DriverTo learn how the Fernhill SCADA ODBC Driver can provide data to other applications.
For the meaning of terms used in Fernhill SCADA.