Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to find a good BI tool which can be connected to a PostgreSQL database.

I need the following abilities:

  1. Reporting Services
  2. Dashboards
  3. OLAP
  4. Data Mining.

The BI server should work on Linux and the solution shouldn't be very expensive.

I looked at the Wikipedia entry list of BI tools - almost all are open-source and free tools and don't fit my needs.

The list of proprietary products is too big to check all of them.

Pentaho Community Edition looks interesting but it doesn't have dashboards, that feature is only in the commercial version but prices are not published and doesn't seems very useful.

JasperSoft doesn't have dashboards in the free version either.

Can anyone point me in the right direction?

share|improve this question

migrated from stackoverflow.com Jul 15 '11 at 15:29

This question came from our site for professional and enthusiast programmers.

    
I really think that this should be back in Stack Overflow - it's looking for high-level info about software which will (with configuration, programming or both) sit on top of Postgres, rather than asking a DB admin question. –  Jamie Jul 27 '11 at 1:13
    
@Alexius you don't really seem to be asking a question here, except that you seem to be doing what we call a shopping rec question, which the stacks are not well setup for. I can go into lots of reasons why that is, but atm, suffice to say, that's not for the here and now. Please revise this to ask a question or I shall be forced to delete this, as it is not a question and is just clutter. –  jcolebrand Jul 27 '11 at 16:59

2 Answers 2

The best open-source BI tools out there are Actuate/Birt, Jaspersoft, and Pentaho. I'd take a look at them.

On a side note, what prompted you to use Postgres for an analytic/BI database? Typically, it's transactional, and it will force you to truncate data too early.

share|improve this answer
    
Please explain what you mean by "it will force you to truncate data too early" –  Jack Douglas Aug 4 '11 at 16:21
    
Eventually, your indexes will start bogging down at large data volumes (tens to hundreds of gigs). It just isn't designed to scale. Thus, it'll either force you to look at different options (such as an analytic db), make you buy bigger/better hardware, or more likely cause you to truncate/clear off "older" data. –  JeffIB Aug 5 '11 at 18:09

You may have a look to icCube (we've got a production system using PostgreSQL). You may contact us directly or use our forum for more details.

share|improve this answer
    
second the icCube solution. –  Chris Travers Aug 16 at 13:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.