Commandline report Generation using Pentaho

Question

I would like to automate the entire report generation process using Pentaho report designer using commandline. Is it possible to achieve it in Pentaho?

Input = results data stored in a database Output = Generate report ( in the form of chart for ex) using Report designer

Thanks Kelly

Answer 1

Another option if you dont want to use a BI server at all, is to use the Pentaho Report output step in PDI/Kettle. This is great for scheduled jobs. The advantage of this over running schedules in the BI server is that you can cron them, and then if the BI server is down your reports will still run! i.e. it's a lot more reliable.