Re: PostgreSQL and Datawarehouse tools

On Tue, Jan 20, 2004 at 04:25:58PM -0300, Esteban Kemp wrote:

Hi Esteban,

> I'm start to try to developer a Data Warehouse over PostgreSQL,

Have you been in contact with Carlos Hurtado at Universidad de Chile?
He wanted to work on a similar project.
http://www.dcc.uchile.cl/~churtado/

(Presentó un tema de memoria el semestre pasado buscando un alumno
precisamente para esto).

> I want to know what tools exist to:
>
> Modeling (Diemsnional)
> ETL process (Extract Transform Load)
> Query Report

Did you check whatever exists at techdocs.postgresql.org? Also see if
you can find related projects at gborg.postgresql.org.

For ETL the usual recomendation is to convert your data to a reasonable
ASCII representation (comma separated values, etc) and then massage it
with whatever combination of awk/sed/perl suits you. After that, feed
it to COPY or psql's \copy. There's also PgAdmin2 Migration Wizard, or
something like that.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)