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?
One option (and probably the best) would be to develop something using the ClearSCADA "Server Automation" or ".NET Client API" interfaces. However this isn't something that can be interfaced directly with Jython.
Another option is to create a Linked Server 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.
The query in Ignition looks like this, with "CLEARSCADA" being the name of the Linked Server configured on the MSSQL instance:
I don't know the limitations on the latter method, but it definitely works to get information out of a ClearSCADA data silo!
