This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

automatically update external data using SCADACONNECT

Hi

I want to fetch data from SOL-Server to field of elements in a water gems scenario.

the data are periodically   updated in database, and I want water gems to updates the correspond fields automatically. (without click on load external data)

Thanks

  • Abbas,

    You can do that by using SCADAConnect. The "Database Connection" option will allow you to connect to SQL Server. The help file on SCADAConnect will give you some guidance.

    To get the values from remote server you can click on "Load to Initial Settings"  If you like to use some real time data then explore the "SCADAConnection Simulator". To use SCADAConnect simulator you need the SS4 version (or higher) of WaterGEMS/WaterCAD.

    Thanks,



    Answer Verified By: Abbas Maazallahi 

  • Thanks a lot Akshaya

    I use connection manager and connect to sql server. so I could Update external fields of an element with this connection. but I want watergems to update automatically the field in case it changed in database.

    also I use SCADAConnection Simulator but I couonldn't choose baseline scenario.

  • Let me step back and ask you what are you trying?

    Are you trying to import modeling element properties such as pipe diameter, node elevation etc from external source? If so then SCADAConnect is not the right tool rather ModelBuilder is. Tools > ModelBuilder can bring data in and has ability to push data to source file as well. Now, the model builder doesn't show SQL Server in the Data Source. What you can do is select the OLE DB > click Browse button. Go to Provider Tab  in Data Link Properties window and select appropriate option such as Micorsoft OLE DB Provider for SQL Server.

    In any case software won't keep listening to external source for any change. You have to press a button to bring the data into the model.



  • Than you again

    In case of real control systems, some attributes (such as pressure) changed with sensors automatically and updated in SOL-Server.

    So I want the value of these attributes in watergems automatically change before run the model (without click on "Load to Initial Settings" or "Load to Calibrate Field Dataset").

    I wish I could explain my requirement clearly. I want to use watergems for controlling real water distributed systems.

  • Hello Abbas,

    If you don't want to push any button other than compute and expect software to gather data from attached sources then it's doable. However, you have to custom built your tool. Using WaterObjects.NET programming API you can write your own program that will interact with the model and will do whatever you want to do with or without any click. So, it will pull the data from datasources, update model's attributes, compute the model, push the result to external source and much more but you have to specify what to do in programming.

    To see some of the WaterObjects.NET examples, please click on the "Akshaya's Blog" in my signature.