Sunday, August 18, 2013

Downloading Pentaho CE

I've started first by downloading the world of Pentaho CE. It's a lot of stuff, and it's probably not everything I need.

I pulled everything through the following link: Pentaho CE latest stable builds

This also looks like a good place to navigate the community, see what people are talking about, and maybe, hopefully, find help.

I downloaded this:

Component File(s)
Kettle - Data Integrationt pdi-ce-4.4.0-stable.tar.gz
BI Server biserver-ce-4.8.0-stable.tar.gz
biserver-manual-ce-4.8.0-stable.zip*
Pentaho Metadata pme-ce-4.8.0-stable.tar.gz
Design Studio pds-ce-linux-64-4.0.0-stable.tar.gz
Mondrian mondrian-3.5.0.zip
Schema Workbench psw-ce-3.5.0.tar.gz
Aggregation Designer pad-ce-1.5.0-stable.tar.gz
pentaho-aggdesigner-ui-1.5.0-stable-sources.zip
Report Designer pentaho-reporting-engine-classic-extensions-3.9.1-GA.zip
pentaho-reporting-engine-classic-demo-3.9.1-GA.zip
pentaho-reporting-engine-classic-core-3.9.1-GA.zip
Reporting SDK pre-classic-sdk-3.9.1-GA.tar.gz

For convenience:

New projects

So, I've got two configuration project going on at the moment.


  1. Set up cascaded replication of a Postgresql server using the built-in hot-standby functionality.
    1. Also try and use Slony-I to then replicate on the database level from the hot-standbys to read-write mirrors for development and test
  2. Set up Pentaho community edition on Ubuntu against an existing Postgresql RDMS where we've already done a lot of the ETL to an OLAP-style table structure, fact/dim, etc.

Should be fun.
Well, I thought I'd start recording my trials and tribulations with getting stuff to work. This may be useful for others, but it's mostly a place I can put things so I don't forget.

If you find anything here useful, excellent, glad I could help.

Tchau.