Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
How to create the LinkedODBCTable from ClearSCADA Server Configuration to connect to MS SQL Server
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
📖 Home Back
Please create the Linked ODBC Table first from ClearSCADA Server Configuration.
If you are using ClearSCADA 2010 R2 or higher, you may want to look into using ClearSCADA ODBC Linked Table.
For example, below shows TestLinkedTable2 which is a table that I can directly use in ClearSCADA to insert new row into the MS SQL Server.
To configure:
#### Enter the Source Catalog, this is the Database Name, I have "VeteranAES"
#### Enter the Schema = dbo
#### Enter the table name as it appears in the Microsoft SQL Server
worddavd76f062d83cd41ead9522b8401937547.png
Using Linked ODBC Tables, the table from external database such as MS SQL can be directly use in the SQL Query from ClearSCADA.
For instance, below I have setup Linked ODBC Tables with table name TestLinkedTable2, and I can use SQL query "Select * from TestLinkedTable2" inside ClearSCADA which actually runs the query against the Microsoft SQL Server.
From the MS SQL Server, I have the database setup as:
worddav9e8c8e013ff5a0642f69d6a598fe122f.png
In ClearSCADA you can run the Query from ClearSCADA "Select * from TestLinkedTable2" and ClearSCADA would show the result from this table.
worddava2e420b6ebc3b2738962c471e7acb6de.png
Below shows the table in ClearSCADA, you may use similar technique in the script.
worddav45db91caa1df7f92a71c1fca0799b6d2.png
Go: Home Back
Please create the Linked ODBC Table first from ClearSCADA Server Configuration.
If you are using ClearSCADA 2010 R2 or higher, you may want to look into using ClearSCADA ODBC Linked Table.
For example, below shows TestLinkedTable2 which is a table that I can directly use in ClearSCADA to insert new row into the MS SQL Server.
To configure:
- Open ClearSCADA Server Configuration
- Open SQL Query Configuration Linked ODBC Tables
- Right mouse click and Add new Linked ODBC Table## In my case I have Microsoft SQL Server Express running on computer "CMI-3F0D24FA7CE"### Create Table Name that you want to use in ClearSCADA to reference the specific SQL Table#### Enter Connection String = Driver=SQL Server; Server=SQLServerComputerName\SQLEXPRESSinstance;#### Enter the user name and password for the MS SQL Server (for example use "sa")
#### Enter the Source Catalog, this is the Database Name, I have "VeteranAES"
#### Enter the Schema = dbo
#### Enter the table name as it appears in the Microsoft SQL Server
worddavd76f062d83cd41ead9522b8401937547.pngUsing Linked ODBC Tables, the table from external database such as MS SQL can be directly use in the SQL Query from ClearSCADA.
For instance, below I have setup Linked ODBC Tables with table name TestLinkedTable2, and I can use SQL query "Select * from TestLinkedTable2" inside ClearSCADA which actually runs the query against the Microsoft SQL Server.
From the MS SQL Server, I have the database setup as:
worddav9e8c8e013ff5a0642f69d6a598fe122f.pngIn ClearSCADA you can run the Query from ClearSCADA "Select * from TestLinkedTable2" and ClearSCADA would show the result from this table.
worddava2e420b6ebc3b2738962c471e7acb6de.pngBelow shows the table in ClearSCADA, you may use similar technique in the script.
worddav45db91caa1df7f92a71c1fca0799b6d2.png
Go: Home Back
Author
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.