How to Link Microsoft SQL Server to Fernhill SCADA
Help Contents
- Fernhill SCADA
- Help
- Data Access
- Open Database Connectivity (ODBC)
- Link to Microsoft SQL Server
Introduction
You can link Fernhill SCADA data tables to
Microsoft SQL Server using the ODBC driver.
Microsoft SQL Server will forward queries on the linked tables to Fernhill SCADA.
Linking Data Tables into Microsoft SQL Server
-
If you have not done so, follow the steps in:
Setting up an ODBC System DSN.
-
Start Microsoft SQL Server Management Studio
-
In the Object Explorer, expand Server Objects:
-
Right-click Linked Servers and select New Linked Server:
-
Enter this information:
| Field | Value | Notes |
|---|
| Linked server | FERNHILLSCADA | The name of the data source to clients of SQL Server |
| Server type | Other data source | |
| Provider | Microsoft OLE DB Provider for ODBC Drivers | |
| Product Name | Fernhill SCADA | The name of the Fernhill SCADA ODBC driver |
| Data source | My Fernhill SCADA | The ODBC System DSN pointing to the local instance of Fernhill SCADA |
| Provider string | |
You could set ODBC Connection Options here.
|
| Location | | Not used, leave blank. |
| Catalog | TagDB | The default catalog in Fernhill SCADA |
Note: This step assumes an ODBC System DSN called My Fernhill SCADA has been set up.
For more information see Setting up an ODBC System Data Source Name (DSN).
-
Press OK to close the New Linked Server dialog.
The FERNHILLSCADA linked server should now appear in the
Linked Servers list:
-
Expand Providers:
-
Right-click MSDASQL and select Properties. Check the option Non-transacted updates:
Note: The Fernhill SCADA ODBC Driver does not support transacted updates.
-
Click OK to close the window.
Accessing Data Tables in SQL Server
When working in SQL Server, you can select a Fernhill SCADA table by using a four-part name in this format:
ServerName.Catalog.Schema.Table
Where:
| Field | |
|---|
| ServerName | The name of the Linked Server. |
| Catalog | The name of the catalog in the Fernhill SCADA database. |
| Schema | The name of the schema in the Fernhill SCADA database. |
| Table | The name of the table in the Fernhill SCADA database. |
For example:
FERNHILLSCADA.TagDB.CommonBase.TagDataPointAnalog
Example SQL Server Query on Fernhill SCADA
1. In Microsoft SQL Server Management Studio, click New Query.
2. Enter the following SQL:
SELECT FullName,Timestamp,Value,Units
FROM FERNHILLSCADA.TagDB.CommonBase.TagDataPointAnalog
3. Click Execute. The query results should be visible in the Results window:
Further Information
Setting up an ODBC Data Source Name (DSN)
To learn about configuring ODBC data Source Names.
Fernhill SCADA ODBC Driver
To learn how the Fernhill SCADA ODBC Driver can provide data to other applications.
Glossary
For the meaning of terms used in Fernhill SCADA.