Configuring the PO to PME load task
Configure Power Monitoring Expert Bulk Data Load Task after you add it to the ETL job. Click the load task to display its configurable settings. Click a setting name to change its value. Some settings are configured by entering a value, while others are configured by selecting an option from a drop down list.
After you complete the extract task configuration, click Apply to save the ETL job without exiting the job, or click OK to save and exit the ETL job.
| Setting Name | Description | Setting Parameters / Recommended Values |
|---|---|---|
| Database Settings | ||
| SQL Command Timeout | The wait time (in seconds) before stopping the attempt to execute a SQL command and generating an error. | Default: 3600 |
| Database Settings (Application Modules / ION_Data / ION_Network) | ||
| SQL Server Name | The name and optional instance of the SQL Server to connect to. | Default: localhost\ION |
| Database Name | The name of the target database. | Database > Default values:
Application Modules > ApplicationModules ION_Data > ION_Data ION_Network > ION_Network |
| Authentication Mode | Authentication mode to connect to the database. | Windows Authentication (default) SQL Server Authentication |
| SQL User Name | The SQL Server Authentication Mode user name. | |
| SQL Password | The SQL Server Authentication Mode password | Click the field to display the Browse button. Click the button to enter your password.
|
| Group Name Settings | ||
| Add the 'group Name' prefix to Sources if Needed | When set to 'True', the task adds a group name prefix to all sources that do not already have one. When set to 'False', a group name prefix will not be added. | Default: False |
| Group Name | The name provided in this setting is used as the Group Name prefix setting described previous. | If the previous setting is 'False', this setting does not need to be filled in. |
| Load Options | ||
| Disable in-memory table constraints | When True, constraints are disabled when building up an in-memory table prior to inserting. | Default: True NOTE: In some cases when True, this can improve performance. |
| Enable Limit on records per insert | When True, the Maximum record per insert setting is applied. | Default: False |
| Maximum records per insert |
The maximum number of records passed to any one PME stored procedure call. The load task can break inbound data into batches and invoke the stored procedure for each batch. |
Default: 10000 NOTE: The value is used only when Enable Limit on records per insert is True. |
| Mapping Options - Source and Quantity End Names | ||
| Populate Button - Automatically Set Quantity 'End Names' to 'Start Names' | When True, all quantity End Names will be filled in and given the same value as the Start Name column. When False, all quantity End Names will be left blank. |
False |
| Populate Button - Automatically Set Source 'End Names' to 'Start Names' | When True, all source End Names will be filled in and given the same value as the Start Name column. When False, all quantity End Names will be left blank. |
False |
| Null Values | ||
| Allow Null Values | When set to 'False' the task ignores any null values. When set to 'True', the null values are inserted into the database. | Set to 'False'. |
| Recorders and Channels | ||
| Enable Recorder and Channel Creation | When set to 'False', the task does not create recorders and channels while inserting data. |
The default setting is 'False' to prevent Log Inserter from creating unwanted downstream devices in the database. If the setting is 'True' and you add a device to PME with the same name as a pre-existing ETL source, Log Inserter will create unwanted downstream devices. NOTE: Some reports – such as Energy Cost Report and Load Profile Report – use Recorder and Channel information when retrieving data from PME. If loading data into PME for the purpose of viewing it in one of these reports, set this to ‘True’. |
| Set the IsCurrentConfiguration Flag to False for New Channels | Indicates whether new channels are marked as non-current (True), or current (False.) | Default: True |
| Source And Quantity Creation Settings | ||
| Enable Quantity Creation | When set to 'False' the setting disables creating quantities if they are not already in the database. | Set to 'False'. |
| Enable Source Creation in ION_Data | When set to 'True', the setting enables the creation of sources that are not already in the ION_Data database. | Set to 'True'. |
| Enable Source Creation in ION_Network | When set to 'True', the setting enables the creation of sources that are not already in the ION_Network database. | Set to 'True'. |
| Source Namespace Settings | ||
| Source Namespace Override | Namespace given to all sources that do not have a namespace or that are created during the Load Task. | IONEnterprise |
| Source Type Settings | ||
| Override Source Type | When set to 'True', enables the use of the Source Type Override value when creating sources. | Set to 'True'. |
| Source Type Override | The source type to use when creating sources. | presumed downstream device. |
| Verbose Logging | ||
| Capture Timing Information | When True, additional timing information is logged in the trace log file. | Default: False |
After the ETL tasks are configured, map the extracted data sources to the target data store. See Configuring PO to PME mappings for details.