[Imported] Remote database

[sbeadle]

>>Message imported from previous forum - Category:Scripts and Tips<<
User: mchartrand, originally posted: 2018-10-19 17:37:02 Id:150
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.
-------------------------------

**_Chris06:
How can I edit a script to connect to remote database of clearscada and place it in a list?_**

-------------------------------

bevanweiss:
Well... I'd recommend against it. It's not really how ClearSCADA is architected.

ViewX reads the systems, and nodes, that it will connect to from the Systems.xml file (which is generally found at C:\\ProgramData\\Schneider Electric\\ClearSCADA\\Systems.xml)

ViewX must be restarted if this file is modified to accept the modifications.
This kind of ruins your plan.

It is possible to use scripting to modify the file, although it would be a bit painful, since the file is XML, and has a particular format to it.

Perhaps you can tell us the actual end goal.
What is the use case that you are trying to achieve?

________________________________________

**_Chris06:
I need to show data from different CS remote systems on my CS local system and place them in lists with a script._**

_____________

bevanweiss:
Ok. Then your clients need to have every remote system that you want data from within their Systems.xml file, and they must be able to connect to each of these servers (and be appropriately licensed).

Then you can just put down an embedded list when you edit a mimic, and select on the 'General' tab of the Embedded List Properties popup which System you want it to query against.
If you want to aggregate the data from several systems into one Embedded Query then you will need to configure the additional systems so that they can be queried under the one system. This is done from the Server Configuration, and SQL Query Configuration - Linked ODBC Tables.. you would need to put in the connection details for the remote systems.

___________________________

**_Chris06:
Thank you very much, this worked._**