Choosing business intelligence tools under postgresql?

Question

PostgreSQL

Good afternoon!
In order not to reinvent the wheel, it was decided to use some ready-made BI system for creating reports, dashboard, OLAP and data mining. Unfortunately, I could not find the necessary information on the Internet.
The requirements are: support for postgresql, linux, work through the web interface and not too high a price.
At the moment I'm trying to deal with Pentaho BI Server Community Edition - it seems to have what you need (except for dashboards - there is a paid version), but everything is somehow inconvenient.
Tell me who worked with what and where you can read information on this topic. Thank you.

Answer 1

www.basegroup.ru deductor Analyst
workplace (StudioProfessional) – 29,000 rubles.
User workstation (ViewerProfessional) - 8,700 rubles.
The program has been updated to 5.3. version, the network version 6 will be released by December.
Looks like it should work on Linux. Request it from [email protected]
Deductor in PCLinux Environment
I have long dreamed of trying Deductor in Linux environment. And it was possible in the KDE environment of the PCLinux operating system under the Windows emulator - Wine. Would like to know if anyone has had a similar experience?
Reply Topic: Suggestions and comments
Igor
26-06-2008
Surprisingly, we also have a similar experience. There were experiments with the work of Deductor in Linux. In our case it was Ubuntu 6 and 7, also under Wine, or rather under its modification from Etersoft.
Troubles found:
1. IE needs to be installed, because it is used in a number of visualizers and is used for printing, and the Mozil object does not quite match the available methods and properties, if this is not used, then IE may not be installed.
2. Professional and Enterprise versions require a USB key, there are no drivers for Linux yet, for this reason you can only use a network key on another Windows system.
3. To work with various DBMS, you may need a DBMS client, and they are not always so easy to install under Wine, it works successfully if you just put the client dll. The operability of receiving data from the following DBMS was checked: Firebird (already included in Deductor), MySQL, Oracle (InstantClient), MS SQL (before 2005, via ntwdblib.dll).
Reply

Answer 2

experience "OLAP with Postgres (how we built BI)" Andrey Fefelov, Mastery.pro
you can find their presentation
they used:
Cubes (API) cubes.databrewery.org
Saiku (UI)
there are more options via Pentaho Mondrian https://datavirtuality .com/connectors/integrate/gr...
here you already get support for full-fledged MDX and XML/A
the ability to connect to cubes from Excel