From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: BI tools and PostgreSQL
Date: Mon, 4 Nov 2013 12:49:49 -0800 (PST)
Message-ID: <1383598189237-5776910.post@n5.nabble.com> (raw)
In-Reply-To: <CANxEMJNTsntBSc78wRDRFhCkR3qEqSiDQ6bmmjF2JLXFbTzV=g@mail.gmail.com>
References: <CANxEMJNTsntBSc78wRDRFhCkR3qEqSiDQ6bmmjF2JLXFbTzV=g@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Victor Tan wrote
> BI tools all generate SQL with varying levels of optimization. However,
> do
> any of you know of any BI tools that are more PostgreSQL aware in that
> they
> can generate queries that take advantage of extensions like hstore, arrays
> etc?
>
> Hstore and JSON data types use non-standard syntax within PostgreSQL - not
> that I know of anything in the SQL standards that say how to handle KV
> types in the style of hstore.
>
> Which BI tools, if any, either are aware of PostgreSQL in this way or at
> least minimize hindrances to using these types of data types or
> extensions?
>
> - Victor Tan
Native support is probably "zero" as Simon is implying.
Most BI ends up needing scalar values for calculations and display. Two
dynamics resulting because of this: either you have to supply your own SQL
in the BI tool and perform the needed conversions or you can create a BI
integration layer within your model so the tools can hit pre-defined schema
with the conversions already in place and the SQL the tools generate can be
used as-is.
I get what you are saying but all I am coming up with more questions to ask
regarding your use-case. For better and worse most tool developers want to
be vendor agnostic to the largest degree possible. The good news is there
are a number of open-source projects that may suffice and that with a strong
enough need a PostgreSQL specific module could be developed. Unless you are
willing to try and sponsor some of that work I'd suggest being open with you
needs and desires and give others a chance to buy into and leverage the
ideas and suggestions and thus ideally increase the demand for such.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BI-tools-and-PostgreSQL-tp5776892p5776910.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: polobo@yahoo.com
Subject: Re: BI tools and PostgreSQL
In-Reply-To: <1383598189237-5776910.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox