Configuration
The script expects the CSV file at the path $OPERATIONS_MODELS/derms_forecasts. Processed CSV files are moved to $OPERATIONS_MODELS/derms_forecasts/parsed_CSVs subdirectory, and errors are logged in the $OPERATIONS_MODELS/derms_forecasts/log directory. The CSV file format is specified in the PF_DERMS_ADAPTER_CONFIG database table. This includes configuring information like number of columns, column positions, and whether header present or not. NCA forecast data has additional columns so the forecast file category is identified based on the number of columns.
If the input is an RDBMS table, then the forecast updates are expected in a database table. If the adapter is running on enterprise service network, then the forecast updates are expected in the DERMS_FORECAST_UPDATES table. If the adapter is running on operational service network, then the forecast updates are expected in the PF_DERMS_FORECAST_UPDATES table.
External Load and Gen Forecast data has additional columns the forecast file category is identified based on the number of columns and file extension name.
PF_DERMS_ADAPTER_CONFIG
 
Name
Data Type
Description
parameter_name
VARCHAR2(32)
The name of the parameter. Required.
parameter_value_1
VARCHAR2(64)
Required parameter value.
parameter_value_2
VARCHAR2(64)
Optional parameter value.
parameter_value_3
VARCHAR2(64)
Optional parameter value.
 
The following parameters are configured in the in the table PF_DERMS_ADAPTER_CONFIG:
Parameter
Description
sourceDBServiceName
Sets the database service name, server name, and port details for the forecast updates table.
• parameter_value_1: server name. The default value is DB.
• parameter_value_2: port number.
• parameter_value_3: database service name.
operationalService
Sets whether the adapter is running on the operational service network or the enterprise service network.
• parameter_value_1: Yes | No
• Yes: operational service network
• No: the enterprise service network
useSqlLoader
Sets whether to use SQL Loader or NMS Import to load the data into NMS tables.
• parameter_value_1: Yes | No
• Yes: SQL Loader
• No: NMS Import or other process
forecastDir
The directory containing the forecast CSV file.
numDataCol
Define rule to specify the number of columns in raw CSV
dermsColumnMap
Defines the CSV columns.
• parameter_value_1: column name.
• parameter_value_2: column number.
The column numbering starts with 0, which is the first column in the table. The standard configuration is defined as follows:
• Column 0 = ForecastDate (mm/dd/yyyy HH24:MI:SS)
• Column 1 = ResourceName
• Column 2 = PowerSourceType
• Column 3 = ForecastValue
headerPresent
Sets whether the CSV file has a header row or not.
• parameter_value_1: Yes | No
forecastnumDataCol
Define rule to specify the number of columns in External Load and Gen CSV file
forecastColumnMap
Defines the CSV columns for External Load and Gen CSV file
• parameter_value_1: column name.
• parameter_value_2: column number.
The column numbering starts with 0, which is the first column in the table.
The standard configuration is defined as follows:
• Column 0 = ForecastDate (mm/
• dd/yyyy HH24:MI:SS)
• Column 1 = ResourceName
• Column 2 = ForecastSource
• Column 3 = Forecastobject
• Column 4 = ForecastkW
• Column 5 = ForecastkVAR