Creating a PO to PME ETL job

To create a PO to PME ETL job:

1. In the ETL Administration Tool, click New.
2. Enter the name of the job in the Name field.

   

   NOTE: The ETL job name has to be unique. Make sure your ETL job name does not conflict with any other ETL jobs on your system. This is particularly important to consider when registering ETL jobs to run as Windows services.

3. For testing purposes, use the default Sleep Time Between Execution interval of 3600 seconds.

   NOTE: After you confirm that the ETL job runs successfully, the initial data transfer has occurred, and the ETL job is ready to be scheduled to run as a service, you can set the Sleep Time Between Execution to 900 seconds; PO uses a 15 minute interval to collect trend data.

4. Click the Tasks tab.
5. From Select Category select Extract.
6. From Select Type select PO Extract Task.
7. Click Add.

   The extract task name and description appear under the Extract heading:

   

8. In the Field Editor pane, configure the extract task. See Configuring the PO to PME extract task for details.
9. (Optional) Add and configure a transform task. See Configuring the PO to PME transform task for details.

NOTE: For most PO to PME ETL jobs, the transform task is not needed.

10. From Select Category select Load.
11. From Select Type select Power Monitoring Expert Bulk Data Load Task.
12. Click Add.

    The load task name and description appear under the Load heading:



13. In the Field Editor pane, configure the load task settings. See Configuring the PO to PME load task for details.

    NOTE: If you plan to use the Energy Cost Report or Load Profile Report, review the Enable Recorder and Channel Creation setting in the Configuring the PO to PME load task table.

14. Click Apply to save without exiting the job, or click OK to save and exit the job.

After the ETL tasks are configured, map the extracted data sources to the target data store. See Configuring PO to PME mappings for details.