Pentaho Reporting Output step

Dear Kettle users,

Certain persons kept bugging me about this new “Pentaho Reporting Output” step I was allegedly writing.  It was based on 3 year old code for version 2.4.  So in the end I decided to sacrifice some sleep to get it done for the new upcoming version 4.1.0 of PDI. Here is the announcement I put up on the Pentaho Reporting forum, it contains download, install and source code details. Screenshot: Screenshot of the new step Here is a 4’30” video that Sylvain from made:

Until next time, Matt

14 thoughts on “Pentaho Reporting Output step”

  1. Thanks a lot for this feature!
    Will it be included in PDI’s main code tree?
    Is it reasonable to start using it for a client’s project?
    It will be very useful, the only alternative being calling or hitting the BI server with wget.
    Nicolas Raoul

  2. Now I realize my mistake: is only for PDI, not for PRD.
    I can’t seem to find a command-line way to generate a bunch of reports.
    … which makes this Pentaho Reporting output step even more indispensable.

  3. Bonjour Nicolas,

    This new step will indeed be included in PDI 4.2.0 but even if it wouldn’t, it’s seeing a lot of traction so it’s never going to go away. On the contrary, a lot of improvements have been suggested by my colleagues at Pentaho so we should see interesting options appear in the coming months. (like data injection and data source hijacking)

    Also, Pentaho support will be happy to support this if you have a subscription for PDI/PRD.

    Scheduling and automatic execution of reports have until now been done on the Pentaho BI Server. Please note that contrary to BIRT/Jaspersoft that the Pentaho BI Server is completely free for reporting so don’t discard this method up front. However, the reason that the new plugin is so popular is that it indeed becomes very simple to get a few reports executed in a 3rd party scheduler and so on.

    Good luck!


  4. Very cool! This is working great for me from Spoon, but I can’t get it to work from “Unable to load class for step/plugin with id [PentahoReportingOutput]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution.”

    Any ideas?

  5. I followed the same procedure. I got the error as “Unable to initialize the report error” . I gave the paramater input as given here and used the same table in the demo. After initializing the parameter when i execute the report it says “unable to initialize the report error”.

    Any ideas on solving this?

    Thanks in advance!

  6. Hi,,

    The above said issue is fixed. All I did was just a re-install of the plugin and now I am able to get reports.

    But I could not get the reports with the charts and images. I got empty reports if I use images and dont find any error logs related to that.

    Could you help me in getting it done?

  7. Hi Karthick,

    Please post your questions on the Pentaho Reporting forum.
    I don’t want to turn this blog into another forum.
    Please note that this step is part of the standard PDI distribution from 4.2.0-M1 on (A supported version is to be released in 6 weeks). You can find M1 on Sourceforge to try.

    Good luck,

  8. Thanks Matt.

    I would not post it again and thanks for the information. I will try and let you know in the pentaho forums.

    This is a great job


  9. I don’t see Extraction folder (time within video -2:46 for example) in my DI (version 4.2). It seems a required plugin is not installed. Could you clarify – what modification with package is required to reproduce this very valuable training.

    Thanks for presentation.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.