| Product(s): | Bentley WaterGEMS, WaterCAD | ||
| Version(s): | 08.11.06.58 | ||
| Environment: | N\A | ||
| Area: | Layout and Data Input |
Problem
How can I connect to data historians such as GE Proficy?
Solution
Beginning with SELECTseries 6 (08.11.06.58), the ability to enter custom SQL statements has been introduced to SCADAConnect, providing the flexibility needed to connect to various data historians such as GE Proficy. To locate this feature, click the SCADA Signals button on the Configure tab to open the SCADA Signals window, then right click on the folder label and choose "Edit Data Source..."
In order to enable customization, click the checkbox for the "Customize SQL Statements,” which will make the statement text boxes editable. If you make a mistake or want to reset the statements to the default you can click the "Reset to default" button that his highlighted by the blue box in the screen show below.
The below screenshots show how to configure this for GE Historian, depending on the type of “Source Format”. The parameters used in the “Set …” are stated in the OleDB help documentation of the Historian. You may want to choose other available parameters and combinations. For more details, see the WaterGEMS or WaterCAD help topic "Supported Set Statement Syntax"
The remaining part of the setup depends on the “GE Historian” data table you want to use to read signals:
Configuration for “One value per row “
1) Select the fields as shown below:
2) Click “SQL Statements …” to customize the default statements
Modify the available signals SQL statement to:
set rowcount=0 select Tagname from ihTags
Prepend the other 2 select statements with:
set rowcount=5000, intervalmilliseconds=900s, samplingmode=interpolated
Configuration for “Multiple values per row“
1) Select the fields as shown below:
2) Click “SQL Statements …” to customize the default statements
Prepend the statements with:
set rowcount=5000, intervalmilliseconds=900s, samplingmode=interpolated