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