PostgreSQL and Datawarehouse tools

[Esteban Kemp]

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

I want to know what tools exist to:

Modeling (Diemsnional)
ETL process (Extract Transform Load)
Query Report


thanks

PD: someone know if exist some complete and integrate suite for Data
Warehousing, over postgresql ?



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Alvaro Herrera]

Re: PostgreSQL and Datawarehouse tools

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

Hi Esteban,
[color=blue]
> I'm start to try to developer a Data Warehouse over PostgreSQL,[/color]

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).
[color=blue]
> I want to know what tools exist to:
>
> Modeling (Diemsnional)
> ETL process (Extract Transform Load)
> Query Report[/color]

Did you check whatever exists at techdocs.postgr esql.org? Also see if
you can find related projects at gborg.postgresq l.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)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster