Tell me more ×
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.
up vote 2 down vote favorite
1

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
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

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

3 Answers

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.

share|improve this answer
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.

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
up vote -3 down vote

http://www.inetsoft.com offers a complete BI solution with visual analytics, reporting, dashboarding, data access, security that is easier to deploy, use and administer and is more affordable than traditional BI solutions from the "big BI" vendors.

A key feature differentiator is end-user defined data mashup, which allows business end-users to drag and drop data from disparate data sources, including self-imported ones, to create new analyses that can now be shared and refreshed automatically. This is a kind of BI self-service service capability without which end-users have been frustrated by the time & effort required to accomplish with IT support that has driven them to spreadmarts and Excel-based analysis.

The application can access terabyte-sized data sources and delivers performance optimization through in-memory caching, pre-aggregation and materialized views.

share|improve this answer
1  
If you are associated in any way with Inetsoft, you should always add that to your answer. – Max Vernon Feb 27 at 21:22
-1 This just reads like an advertisement – Paul White Feb 28 at 2:12

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.