Configuring SCADAConnect for GE Historian / GE Proficy

  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

See Also

SCADAConnect Simulator for WaterGEMS V8i SELECTseries 6

Recommended
Related