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] ClearSCADA and MS SQL Server Linked Server

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
719

[Imported] ClearSCADA and MS SQL Server Linked Server

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: florian, originally posted: 2018-10-25 16:51:30 Id:246
This is a re-posting from the obsoleted (October 2018) "Schneider Electric Telemetry & SCADA" forum.

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

**_HenkSmit:_**
**_As I have explained yesterday I am trying to get the data out of ClearSCADA 2015 R2. I want to integrate the data with other Data that is already in a SQL Server, running SQL Express 2012 R1._**

**_I have configured a System DSN with the Password and Username of a configured ClearSCADA User. The password is specified in the DNS properties.The same DNS also allows me to access the data from MS Access, so I have to believe the DNS is working as it should._**

**_When I create a linked server from within SQL Server, using the DNS, the server is connected immediately, without any problems or errors._**

**_I have created the Linked Server using the System DSN name as the Product Name as well as the Data Source, is this correct?_**

**_My problem is that the server is empty and does not show any table or other information. Is this correct? How do I see the tables in order to access them?_**

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

**_HenkSmit:_**
**_Hi all_**

**_Just a quick follow-up. I have just upgraded my SQL Express to 2014, but the result is still the same. The tree structure when you expand the Linked Server is completely empty._**

**_I only see a Catalogs folder with a Systems Catalogs subfolder. Nothing else, no DB Name, tables or anything else._**

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

du5tin:
If you run a known query against your ClearSCADA DSN do you get results?

I am not sure all clients are created equal when it comes to browsing the ClearSCADA schema. I know Crystal Reports has no trouble, and you indicate that Access has no trouble but I have not yet seen this done from inside MS-SQL.

Maybe try using the ClearSCADA schema to find your fields. It runs on the ClearSCADA server, usually https://localhost/schema/. Write and test the query inside ClearSCADA to be sure it works and then pull the query over to MS-SQL to get the data out.

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

**_HenkSmit:_**
**_Dustin_**

**_Thank you for the reply._**

**_You were spot-on, it seems that for some reason SQL cannot browse the ClearScada schema. Maybe it is because it is not in "logical" db structure (my personal opinion)._**

**_For instance, when I want to select * from the CDBObject you do it with the following query. My Linked server is named "CLEAR"._**

_SELECT *_
_FROM_
_CLEAR..Kernel.CDBObject_

**_But hell, it works and that is all that matters._**

**_Thanks_**