General SCADA setup details for WaterOPS and SewerOPS

Product(s): WaterOPS, SewerOPS
Version(s): CONNECT Edition
Area: Modeling


OpenFlows WaterOPS and OpenFlows SewerOPS can utilize SCADA data to analyze an existing mode. Historical and real-time data base used from a number of different sources. Once the data source is connected with the model, it is possible to compare model results to the SCADA data using the SCADA element. Since WaterOPS and SewerOPS models are based on existing WaterGEMS or SewerGEMS models, the SCADA data may already be set up for your model. However, you can find information on setting up your SCADA data below.


SCADA elements are typically added manually since there are likely a manageable number of them for a given model. SCADA elements can be a added to a model from the Layout tab and placed near the element it is associated with. Pumps and tanks are common elements that SCADA elements will be associated with, but they can also be associated with pipes and valves. It is important to have a good understanding of your data so you know where to add SCADA elements.

The screenshot below shows SCADA elements associated with two pumps and a pipe. The SCADA signal associated with the pumps relates to the relative speed factor; the SCADA signal for the pipe is for flow.

Once the SCADA Elements are added, you will need to associate them with an model element. To do this, double-click the SCADA element to view the properties. Find the attribute Model Element and select “Select Model Element.” This will open a Select toolbar to allow you to choose and element in the drawing pane. When you select the element, it will be connected with a dashed line, as shown in the screenshot above.

You will also need to assign the Field attribute. This denotes what element property field the SCADA Element represents. This will vary based on the element used. For example, a pump may use flow ore relative speed factor, a tank may used level or tank status, and a pipe may uses pipe status or flow. You can set the Field attribute for the SCADA Element either in the properties grid or by opening the SCADA FlexTable. The SCADA Element FlexTable can be accessed by going to Home > FlexTables. Below is the property grid for a SCADA element associated with a pump, and representing the pump’s relative speed factor.

Note: New SCADA properties were added in CONNECT Edition Update 3 (build These include Tank Status (whether it is filling or emptying) and Difference and Difference (Relative). The Difference fields define the numerical and relative difference between the SCADA data and the calculated results.

The next step would be to link the SCADA data to the SCADA Elements in the model by going to Home > SCADA Signals. 

On the left side of the dialog, you will see the SCADA connections available for the model. To create a new connection, click the New button. You will see the available sources that are available in SCADAConnect: Database Source (which include a wide array or source and include Excel or Access files), OPC Historical Source, and OPC Real-Time Source.

Data Sources

Database Source

To add a Database Source connection from the SCADA Signals dialog, New > Database Source. This will open Database Source dialog.

Click on the "Edit..." button beside the Connection pulldown menu. This will open a Database Connection dialog, as shown below:

For Data Source Type, choose the appropriate data source, such as Excel. Next to Data Source, click the ellipsis ("...") button and select data source file. Next, click on the Test Connection button and make sure to see the "Connection succeeded" message. Then, click OK to close the Database Connection window. This will return you do the Database Source dialog.

Then continue to fill in the data. What is entered will depend on the data source and the available data. Table Name is the data table that contains the SCADA data. Source Format can vary depending on the source. For many database sources, there is one value per row, so that option would often be selected. Signal Name Field is the column in the data source that contains the 'Tag' or 'Signal' name. Value Field is the column that contains the SCADA value. Time Stamp Field contains the FULL date and time. Questionable Field is not supported by all SCADA systems. You can leave this as the default if you are unsure. Lastly, you would choose whether the data is real-time or historical. Database source are typically historical sources. Next, choose the Select SCADA Signals button. You will see the dialog below:

The available SCADA elements will be listed on the left side. Add the necessary signals by, double-clicking the label or clicking ">" or ">>" button. The ">>" will add all. Click OK button when finished. The Database Source will now be filled in.

SCADA Signals window will now list the signals in the left panel as a tree structure. Clicking on the signal on the left will show the corresponding data. Make sure to click either on Refresh or Auto Refresh to see the data. The screenshot below shows the data from the Excel source file for the SCADA element associated with pipe P-1 in the earlier screenshot.

OPC Source

The OPC Source type gives operators he ability to connect to the OPC server and allow the user to communicate directly to the same interface that SCADA operator uses. There are two types of OPC connection, Real-time and Historical.

If the OPC server is in the same machine as WaterGEMS, click on the drop-down next to OPC Server: and select the server. If OPC server is in another computer (which can be remotely reached at) then put a check on Host and then click "Refresh" button.

Usually the SCADA system is protected from the Internet or other outside threats by a firewall or other security measures, allowing you to connect with the OPC server directly or export the file with data needed to SCADAConnect. A more secure alternative is to use OLEDB along with custom SQL statements.

Once the source is selected, click on the Select SCADA Signals button and add the interested signals towards the right list, in the new window.

Assigning Data

Now that the model elements are associated with the SCADA signals and where tags in the SCADA file are located, the SCADA elements need to be matched with the tags. This can be done element-by-element in the property grid or more quickly by opening the SCADA Element FlexTable.

How you assign the data will depend on what kind of data it is: real-time or historical. If you are using historical data, find the column for “Signal (Historical).” For each row of the FlexTable, pick the SCADA tag associated with that element. When done, the table should look like the screenshot above. (If you are using real-time data, you would use the “Signal (Real-time)” column in the FlexTable.)

Once this is completed, you will be able to view SCADA data as compared to model results as described here: Using the SCADA Element for annotation and reporting.

See Also

Using the SCADA Element for annotation and reporting

OpenFlows WaterOPS TechNotes and FAQs

OpenFlows SewerOPS TechNotes and FAQs

  • Created by Bentley Colleague
  • When: Mon, Mar 23 2020 4:32 PM
  • Last revision by Bentley Colleague
  • When: Mon, Jul 27 2020 3:24 PM
  • Revisions: 4
  • Comments: 0