Configuration

RDBMS Configuration

Tables Involved

• scada_measurements_st: standard SCADA measurements configuration table. This is a staging table used by DDService for populating the production SCADA measurement tables.

• digital_measurements: production SCADA measurements table for digital measurements. Only DDService should write to this table.

• analog_measurements: production SCADA measurements table for analog measurements. Only DDService should write to this table.

• scada_ids: SCADA definition table.

• scada_points: optional model build attribute table that is used by the scadapop executable - to help populate the scada_measurements_st staging table. If you want to use scadapop – you need to populate the scada_points table.

• scada_control_st: SCADA controls staging table. Used by DDService to populate the production scada_controls table.

• scada_controls: production SCADA controls table. Only DDService should normally write to this table (when it is updated).

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 the scadapop utility. See “Using SCADAPOP”.