Environment prerequisites

The pdrLoader needs:

  1. Access to a local database (read and write) in which to install the PDR* tables for controlling the pdrLoader process, plus access to all the target tables (Data Model).
  2. A set of local working directories.

File subscriptions

Before installing the pdrLoader application, ensure you have subscribed to the required files from AEMO to supply the data you require for the Data Model. Ensure you have at least two days of files available, so you can be sure you have not missed any data. To establish file subscriptions, use the Data Subscription application, in the Markets portal: EMMS > Data Interchange >Data Subscription.

Ensure your subscriptions are only for the Data Model database; otherwise you need to filter out the files from the data flow into the pdrLoader application.

Local database

To interact with the local database, the pdrLoader requires the following items:

  1. Database connectivity details – server, username and password.
  2. A JDBC driver with user and/or technical documentation sufficient to configure the pdrLoader for connectivity and optimal performance. Each target database requires a unique parameter set for best performance. Please consult the documentation supplied with the JDBC driver being used to determine what parameters may be required.

Working directories

On the local machine, the pdrLoader requires working directories for the pdrLoader processes. A default set creates as part of the decompression of the distribution file. Check each directory and delete each file with the name delete.me.

Additionally, a purging process needs to be put in place so the Loader working directories do not consume the free disk space on the server.

Configuring pdrLoader

The pdrLoader needs information about the data in the files it receives for processing, including what tables in the Data Model the data is to be placed. The configuration information is part of the Data Model. If using the GUI installer, the configuration information downloads automatically when pdrLoader is first installed.