automatically update external data using SCADACONNECT

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,

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.

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.

Hello Akshaya.

thank you very much for you answer. I see your blog and I hope it would help me.

Actually I want to monitor a real water distributed systems and (for example) control the pressures in pipes with realtime and online data's from RTU (Remote terminal units).

so I get connect RTU's with database to my watergems model. (I hope this is correct sooution). this is my object of problem and after modeling with watergems I want to view the results again in database.

could you please answer this problem?

thank a lot

Hi Abbas,

Here's a "rumor". The next version that's coming (SS5 of WaterCAD/GEMS) out will have highly improved and tightly integrated SCADAConnect. It will have ability to connect to OPC server so if you already have a  SCADA system that receives signals from RTUs and displays in a monitor then you can tap into that and pull as well as push data from/to OPC. But I highly doubt that it will keep listening to serves and update the model's attributes until you tell it to do so.

The other possible advantage that you can use WaterObjects.NET API with the SCADAConnect and that opens up lot of other possibilities. You can try on current one as well but it's little different.

So, if you can wait till next version, not sure on ETA though, then you can try these things...

Whether it's a rumor or fact, programming option is there and through programming you are in control. You can pull data from any RTU and push to WaterCAD/GEMS before running it. So, what you are trying seems doable and we may need to use some programming here and there.

Not sure if I answered your question.

Hello Akshaha

I think you answer my question, thanks a lot.

but I read "SCADAConnect simulator" help, and it say's that it could do this actions,  in "SCADAConnect Simulator Configuration" documentation.

could I use this feature for my requirement?

HI Abbas,

Sorry for the delay. As you can see in the image you will need a model with SCADAConnect setup to begin with. So, if you like to test it out, please use SCADAConnect, map the signals you need then use that model in SCADA Simulator. If that meets your requirement then great, if not, you will need to use WaterObjects.NET API.

SCADAConnect may/may not be limited for the project you are thinking so I encourage you to setup SCADAConnect and see if meets you criteria. From there, I guess, you will your next step.