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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


migration rejected from Jan 8 '15 at 10:09

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by RolandoMySQLDBA, Max Vernon, Paul White, RLF, ypercubeᵀᴹ Jan 8 '15 at 10:09

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – RolandoMySQLDBA, Max Vernon, Paul White, RLF, ypercubeᵀᴹ
If this question can be reworded to fit the rules in the help center, please edit the 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
@Alexius - I'd recommend that you post this on the softwarerecs site, as that's more appropriate to a software recommendation request. – Nathan Clayton Jan 6 '15 at 0:33

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.

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
I haven't had any major issues regarding PG and data-warehousing, esp. with smart partitioning, good physical design, and judicious use of partial indexes. Also, we've had pretty good luck with Jaspersoft (the commercial edition brings a few nice features to the table), but if I were redoing things, I'd probably start out with Actuate and their F-Type server (they can come in at the high-end price-wise though for large BI deployments). – Nathan Clayton Jan 6 '15 at 0:34

I came across this site, i think it will give you some tips on possible BI tools that work well with postgres,-Reporting,-and-Light-application-development.html

Savio, refrain from just posting a link without quoting or summarizing its content - if the link goes down your comment becomes useless. – John M Jan 5 '15 at 19:14

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