up vote 0 down vote favorite
share [g+] share [fb]

I'm trying to find good BI tool which can be connected with PostgreSQL database. I need following abilities: reporting services, dashboards, OLAP and data mining. BI server should work on linux system and solution shouldn't be very expensive.

I looked at wikipedia list of BI tools - almost all of open-source and free tools doesn't fit my needs. List of proprietary products is too big to check all of them. Pentaho Community Edition looks interesting but it doesn't has dashboards (it's only in commercial version but prices are not published) and doesn't seems very useful. JasperSoft doesn't has dashboards in free version too. Please, advice.

link|improve this question
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
feedback

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

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

2 Answers

up vote 1 down vote

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.

link|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
feedback
up vote 0 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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