Re: BI tools and postgresql - Mailing list pgsql-general

From Jacqui Caren
Subject Re: BI tools and postgresql
Date
Msg-id 501269B4.1090905@ntlworld.com
Whole thread Raw
In response to Re: BI tools and postgresql  (Vincent Veyron <vv.lists@wanadoo.fr>)
Responses Re: BI tools and postgresql
List pgsql-general
On 26/07/2012 15:04, Vincent Veyron wrote:
> The money spent in licences alone would pay for scores of developpers to
> produce any kind of reporting you will need many times over (the data
> and its structure is what counts, reporting is easy if you have that)

I disagree that licences will cover reporting costs...

I come from the other end of the spectrum. We provide reporting systems
for telco's banks etc. These are relatively stable, carefully designed
reports going to either a small number of high profile clients or
to a large number of end users.

When we installed a system for a UK telco some years ago it ended up
being the biggest outsourced print job in europe. It took up two
exchange trunks for data and ran a months reports iin a few days.

Initially the reporting hardware was three(ish) mid range sun desktops :-)

We dont "do" generic reporting systems - our target audience are
established complex and configurable reports that are run
periodically and take up lots of manula or system resources.

If the Op wants more detail I can pass provide $boss's email address
but as I say it is more of a niche reporting product.

Jacqui

p.s. I am interested in this thread as I have a clinet who has a larg(ish)
PG db and creates ad-hoc crosstab style reports. If I can find a tool he could
use  - he is a salesman and very non technical :-)

At the mo I am building reporting tables and using thsi to populate
crosstabs in openoffice using datapilot - crude but alot faster than
the existing solution which involves manually calcing each cell in
the crosstab :-/ openoffice replaces weeks of work with no more
that an hours report design/config.

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: postgres maintenance db
Next
From: Igor Neyman
Date:
Subject: information_schema.referential_constraints broken?