Simple Pentaho Setup

I had to set up Pentaho reporting recently. I downloaded the following components (all community edition)

• Pentaho Administration Console (PAC)
• Pentaho BI Server
• Pentaho Reporting (editor)
• Pentaho Data Integration

In the end, I didn't end up using Data Integration. The work flow was something like:

1. Set up Pentaho reporting with data connections
2. Create the report in Pentaho Reporting and publish it to the BI Server
3. Set up a global schedule using the PAC
4. Connect to the BI server and schedule the job I created in step 2.

This worked fairly well. I gave the report an email recipient. The only gotchas I ran into were that I didn't realize you need to create a publish password.This is located at:

biserver-ce/pentaho-solutions/system/publisher_config.xml