[Imported] ClearSCADA and MS SQL Server Linked Server

[sbeadle]

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