import data

[andrew123]

We are currently using an odbc connection to sql database to retrieve data that is needed. In the future this process will not be allowed as we segment our scada networks, instead the data will be dumped into an xml file on a sftp site. How do i go about importing that data into scada?

[AdamWoodland]

One straightforward way is to write a .NET application/service, that can do the SFTP transfer using third party libraries and using the Geo SCADA .NET API import data into Geo SCADA (either setting each value one at a time or using the methods on CHistory to bulk import, depends which makes the most sense for your data).

If you're feeling brave it can be wrapped up into the DDK framework, but its not necessary.

[BevanWeiss]

As @AdamWoodland said, it could even be done using a PowerShell script if that's more your style.

Then you could execute it on a schedule using the Windows Task Scheduler.

[sbeadle]

Or use a Python program!

See: https://github.com/GeoSCADA/Utilities-and-Examples/blob/main/PythonSamples/NetGeoSCADAExampleSetVQT....