Configuration
RDBMS Configuration
Tables involved:
Note: The scada_points table only needs to be populated if using scadapop. It is normally populated via device class driven attribute population during the model build process.
To configure the standard SCADA input RDBMS staging table (scada_measurements_st) using scadapop follow the following steps:
Specify which model devices have SCADA (via scada_points table. The scada_points table is generally populated via attribute population during model build construction/update but can be populated after the fact by a custom (project specific) process. A generalization is made that each defined "SCADA" provides a consistent set of attributes for a given NMS object. For example SCADA_A might be defined to always provide a digital "status" and 3 analog values - A_Phase_Amps, B_Phase_Amps and C_Phase_Amps. SCADA_B might be defined to always provide digital "status" and 6 analog values. This generalization is made to simplify configuration. It is generally acceptable if the external SCADA system does not actually provide all SCADA measurements for all configured points - within reason - to simplify configuration.
There are generally two options for populating the scada_points table:
This option involves populating two attributes in the scada_points table:
To set up the scada_points table as a standard Network Management System attribute table generally involves the following RDBMS tables:
Once the scada_points table is populated, the scadapop program can be used to expand the information in the scada_points table to fully populate the more generic scada_measurements_st staging table (see notes below for how to use scadapop).
Note: A given "field device" corresponds to a given scada_points.rtu_alias and would typically be a breaker of some kind (often reporting both device status and multiple analog values). It could also be a transformer reporting analog values with or without status or some other class of device with SCADA data.
Below are two example device_attributes table entries to support population of the scada_points table via standard model build attribute population (option 1 above). For more information on this process, please consult the Network Management System Model Build process documentation. These are examples only.
INSERT INTO device_attributes (
DEVICE_CLS,
ATTR_NAME,
TABLE_NAME,
COLUMN_NAME,
ATTR_TYPE,
LENGTH,
REQUIRED,
MAINTENANCE
) VALUES (
143, 'Rtu_Id', 'scada_points', 'rtu_alias', 3,
32, 'N', 'Y');
COMMIT WORK;
INSERT INTO device_attributes (
DEVICE_CLS,
ATTR_NAME,
TABLE_NAME,
COLUMN_NAME,
ATTR_TYPE,
LENGTH,
REQUIRED,
MAINTENANCE
) VALUES (
143, 'Rtu_Desc', 'scada_points', 'scada_name', 3,
32, 'N', 'Y');
COMMIT WORK;
Example data field explanation:
143Class of device which may report SCADA data. + project specific
scada_pointsAttribute table to populate.
Rtu_IdAttribute id as appears in *.mb file for device.
+ project specific - SCADA device id (rtu_alias).
rtu_alias scada_points column to populate with Rtu_Id value.
Rtu_DescAttribute id as appears in *.mb file for device.
+ project specific - SCADA system name (scada_name).
scada_namescada_points column to populate with Rtu_Desc value.
3 Data type of string (ASCII field); always set to 3 for a string
32Maximum length of this attribute string (bytes)
+ project specific per scada_id len for SCADA.
'N' Required attribute
+ project specific - generally (N)o.
'Y'Set to Y for model builder maintenance. Set this to "Y" if you want the Model Builder to maintain this table via the incremental model build process.
Once the scada_points table is populated the scadapop program can be used to expand this information to fully populate the more generic (required) scada_measurements_st staging table.
Run scadapop -h to get command line options. In general:
The rti.dat file is the configuration file used by the scadapop program. Based on data in this file, and entries in the scada_points table, scadapop populates the standard SCADA configuration (RDBMS) staging table:
The scada_points table contains a record (row) for each device in the Network Management System model that has SCADA information associated with it. Each record has a "scada_name" column which, in order to populate one of the measurements tables, must match a "SCADA_Name" keyword in this configuration file. Where there is a match a row is populated in the scada_measurements_st staging table for each defined attribute.
The syntax rules for the rti.dat file are:
The following keywords exist - they must match EXACTLY:
Note: The colon ":" character is a keyword delimiter. The colon must appear as the first character after the keyword in order for the keyword to be recognized.
Example rti.dat file:
SCADA_Name: USA
Digital: status (Switch Position or "Status")
Analog: Amps_A
Analog: Amps_B
Analog: Amps_C
Analog: Volts_A
Analog: Volts_B
Analog: Volts_C
Example scadapop commands:
scadapop -partition 0 -initFile ${CES_DATA_FILES}/OPAL_rti.dat
scadapop -partition 3111 -initFile rti.dat -debug