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.

Answer 2

Try to use wget and submit URL of xaction.

Answer 3

There's an issue As a reporting user, I want to be able to run reports via a simple GUI tool or via the command line without a GUI open since Dec 2009.

According to Command line tool to run reports it's not planned as of Mar 2014.