Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
📖HomeBack 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.pngworddavd76f062d83cd41ead9522b8401937547.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.pngworddav9e8c8e013ff5a0642f69d6a598fe122f.png
In ClearSCADA you can run the Query from ClearSCADA "Select * from TestLinkedTable2" and ClearSCADA would show the result from this table.
worddava2e420b6ebc3b2738962c471e7acb6de.pngworddava2e420b6ebc3b2738962c471e7acb6de.png
Below shows the table in ClearSCADA, you may use similar technique in the script.
worddav45db91caa1df7f92a71c1fca0799b6d2.pngworddav45db91caa1df7f92a71c1fca0799b6d2.png