Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
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
84248members
353348posts

[Imported] Remote database

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

sbeadle
Janeway Janeway
Janeway
0 Likes
0
363

[Imported] Remote database

>>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._**