Can a 3rd Party Application Query a GeoSCADA Data Table

[MikeSI]

Hi all,

Subject pretty much sums it up; I have a Data Table object in GeoSCADA which I would like to query (SQL) from a 3rd party application. Mainly SELECT queries, but also INSERT/UPDATE.

The purpose is for reporting, and for correcting/adjusting values in the Data Table.

Can it be done using the .NET Client API? Any examples available?

Failing that, what other options are available without getting too complex? Simple is preferred. 

Finally, can a product like SQL Server Management Studio (or SS Reporting Services) connect and query the Data Table?

Thanks a million to everyone on the forum.

[sbeadle · Accepted solution]

Access to tables is (a) via ODBC v1. You can use .Net or other code to access.

Note that some Microsoft and 3rd party software don't support v1, sometimes v3 only, so may not access Geo SCADA.

You can also use the Geo SCADA .Net Client API to bypass ODBC and query directly. Code examples in the GitHub.

[MikeSI]

Thank you @sbeadle . Found example 'List References' on GitHub which was useful.