Support/MetricsDashboardPRD/Setup

Here's the way that the metrics dashboard works and how to get it set up on (staging/production):

• The scripts (which populate the metrics dashboard) are run using pentaho http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=186321&release_id=682677 which runs on java (must be 1.6 or higher, I think)

• scripts are .kjb and .ktr files (XML files) can be checked out into any directory and then run (using a cron job or manually by doing /path/to/pentaho/data-integration/kettle.sh -norep -file mainJob.kjb ) where mainJob.kjb is the name of the parent job file (which then links to the rest.)

• A ~/.kettle/kettle.properties file (in the home directory) specifies parameters such as database names and logins and passwords (I think this is plaintext) specific to the server. This is not in SVN but will need to be generated manually first time.

• Table are also not created automatically by the scripts and will have to be created first time using a few scripted SQL commands.