Configuring the ETL

The ETL tool connects to the Building Operation EWS server, reads out the required historical data (Trend logs), and inserts that data into the PME database. Within the ETL, the task descriptions required to complete the data copy process are organized into Jobs.

An ETL Job contains the following:

• An Extract task to read out the data from a server (in this case, Building Operation)
• (Optional) A Transform task to edit the data
• A Load task to write the data to the new location (in this case, the PME database).

TIP: When creating a new job in ETL, you can clone an existing job, rather than making a job from scratch. To clone a job, select an existing job from the Job Management drop down and click Edit. In the Job tab, change the name to reflect the new job. Click the Task tab and edit the new job as necessary. Click Apply or OK from any tab location to save the job with the new name.

The following sections describe how to configure an ETL Job for the PME/EBO Integration solution, Architecture 1 implementation.