Thread: Data Warehouse

Hi,

Anyone here knows if exists a data warehouse software that uses postgresql?
if it is open source that will be a plus...

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In an attempt to throw the authorities off his trail, systemguards@gmail.com ("Jaime Casanova") transmitted:
> Anyone here knows if exists a data warehouse software that uses
> postgresql?  if it is open source that will be a plus...

There tends to be 3 parts to this...

1.  Data storage

The RDBMS of your choice...

2.  ETL - Loading data into the data store.

Often this is a custom application, as it must be attuned to your
unique data sources.

Bizgres spun off something called KETL; some might consider Perl or
Python to be "the ETL software."

3.  Query tools

The Bizgres guys have put together some tools for this; you may also
be able to hook up commercial tools from Cognos and Business Objects
and such.

Or build your own...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/lisp.html
"Did you  ever walk in a  room and forget  why you walked in?  I think
that's how dogs spend their lives." -- Sue Murphy

Take a look at the Pentaho project (http://www.pentaho.org/). They
have an ETL and reporting framework. You can use any DB as the back
end as long as it has JDBC drivers (PostgreSQL included <grin>). The
ETL piece is Kettle, which is fairly mature, the reporting piece is
still a little rough around the edges, but usable.

Chris Hyde
Remember, no matter where you go, there you are. - Buckaroo Banzai



On Sep 9, 2006, at 3:18 PM, Jaime Casanova wrote:

> Hi,
>
> Anyone here knows if exists a data warehouse software that uses
> postgresql?
> if it is open source that will be a plus...
>
> --
> regards,
> Jaime Casanova
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs and the universe trying
> to produce bigger and better idiots.
> So far, the universe is winning."
>                                       Richard Cook
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq