Reporting Engine Guidance (Pentaho, JasperReports, BIRT)

manpreet Best Answer 2 years ago

I've spent 4-5 hours or so in various forumns and at their websites researching reporting tools that can aid me in my development. I'm new to using tools like this and could use a bit of specific guidance.

I'm working on an web app that will be hosted on one server, but accessed by multiple users through login. Each user will have their own account and can only access reports that only pertain to their data associated with their account. The site will have around 1,000 to 5,000 accounts (which could end up with 2,000 - 10,000 users running different reports).

My environment is: OS: FreeBSD Webserver: Apache Database: MySQL Programming Languages: PHP, javascript (jquery & my own stuff)

The Business Intelligence reporting tools I spent most of my time on was: Pentaho Suite BIRT Suite JasperSoft Suite

My WebApp has to be able to support Multiple Languages in the output of the report. I read that BIRT and Pentaho offer multi-lingual report output, but I can't remember about JasperSoft. Some reviews said they used Pentaho and included the JasperReports (which I'm assuming was the professional product for $249...the reviews didn't specify this, but that's whats on their site now).

So, here's my question. With your experience, which would you suggest in my situation? I want to come up with 40-50 different reports the user could view online, with graphs, in multiple languages, based off of their account specific data, then if they want set up a schedule to have those reports emailed each week, month, etc. in a pdf, xls, or whatever...to whom ever they specify...the webApp would do this automatically. It would be nice to allow my users to dynamically create their own reports and save them as well. I don't want the system to get bogged down with these reports, most of the data is simple...there will be some aggregate data needs, but it's not going to be too SQL intensive...two, to three table joins or less. I want as small as a learning curve as possible, since I'm new to these types of reports, so which suite has the best documentation/smallest learning curve with the most usefule tools?

Some reviews said BIRT has a large footprint 100MB, where Pentaho has a small one, but JasperSoft has the smallest. Does the footprint really matter much if I own the server this will be stored on and can add more storage if necessary, or is the memory the problem? Should I stick with the Pentaho suite using jasperReports as one review is doing and said they r having good success with it?

Forgive me if this has been answered and is anoying...most of the forum reviews I read were about 2-3 years old... I was hoping to get more up-to-date opinions.

Thanks for your help

manpreet 2 years ago