# Interface to ClearScada **URL:** \ **Category:** Ignition\ **Created:** [April 11, 2019, 12:27am UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023 "2019-04-11T00:27:15Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![jrd](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@jrd](https://forum.inductiveautomation.com/u/jrd)\ **Post date:** [April 11, 2019, 12:27am UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023/1 "2019-04-11T00:27:15Z")
Hi We have a water industry customer with a number of legacy SCADA/Historians/RTUs etc across around 30 sites. We are doing a Proof Of Concept that will hopefully replace these systems One stumbling block is that a some sites have ClearScada connected to DNP3 devices and/or Radtel RTUS (with proprietary protocol) So our options are to develop Radtel interface (undesirable) or connect to the ClearScada System at these sites. Has anyone have any experience and/or advice on how we may go about connecting to ClearScada? Thanks in advance ---
**Author:** ![Cose\_Peter1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cose_peter1/32/79174_2.png) [@Cose\_Peter1](https://forum.inductiveautomation.com/u/Cose_Peter1)\ **Post date:** [February 13, 2025, 3:24am UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023/2 "2025-02-13T03:24:27Z")
> [@jrd](#): > > how we may go about connecting to ClearScada Hi were you able to progress with this? I have the same problem at hand. ---
**Author:** ![jrd](https://avatars.discourse-cdn.com/v4/letter/j/b9bd4f/32.png) [@jrd](https://forum.inductiveautomation.com/u/jrd)\ **Post date:** [February 13, 2025, 3:44am UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023/3 "2025-02-13T03:44:56Z")
Afraid not ---
**Author:** ![RylanM](https://avatars.discourse-cdn.com/v4/letter/r/8797f3/32.png) [@RylanM](https://forum.inductiveautomation.com/u/RylanM)\ **Post date:** [February 13, 2025, 3:50pm UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023/4 "2025-02-13T15:50:11Z")
One option (and probably the best) would be to develop something using the ClearSCADA "Server Automation" or ".NET Client API" [interfaces](https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Net-API-Automation-Interface-and-Web-Interfaces-SOAP-and-XML/ba-p/279096). However this isn't something that can be interfaced directly with Jython. Another option is to create a [Linked Server](https://www.se.com/us/en/faqs/FAQ000244790/) connection to the ClearSCADA Database, then create a database connection between Ignition and the MSSQL Server instance (that has the Linked Server). Once you have that you can query the ClearSCADA database directly in Ignition using [OPENQUERY](https://learn.microsoft.com/en-us/sql/t-sql/functions/openquery-transact-sql?view=sql-server-ver16). The query in Ignition looks like this, with "CLEARSCADA" being the name of the Linked Server configured on the MSSQL instance: ![image](https://us1.discourse-cdn.com/inductiveautomation/optimized/3X/d/c/dc9104935a9ee191c74396df8c379b2e08a67f27_2_690x54.png) I don't know the limitations on the latter method, but it definitely works to get information out of a ClearSCADA data silo! ---
**Author:** ![Chris\_Bingham](https://avatars.discourse-cdn.com/v4/letter/c/e5b9ba/32.png) [@Chris\_Bingham](https://forum.inductiveautomation.com/u/Chris_Bingham)\ **Post date:** [May 9, 2025, 3:13pm UTC](https://forum.inductiveautomation.com/t/interface-to-clearscada/24023/5 "2025-05-09T15:13:01Z")
> [@RylanM](#): > > Another option is to create a [Linked Server](https://www.se.com/us/en/faqs/FAQ000244790/) connection to the ClearSCADA Database +1 for the ODBC Driver via Linked Server method.