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)

At a vendor showcase I attended last summer, the best-looking ETL tool I saw
was called Sunopsis ETL. It will work with PostgreSQL via the JDBC driver,
and it is relatively affordable compared to the really high-end data
warehousing tools. See http://www.sunopsis.com

For creating ER diagrams and generating Postgresql data models from them, I
highly recommend DeZign for Databases, by Datanamic. See
http://www.datanamic.com

Here are some other links I've bookmarked while researching the same topic.
If anyone has experience with any of these tools or projects, or can
recommend others, please post to this thread.

Open Source Tools for Data Warehousing
----------------------------------
Octopus ETL Tool http://octopus.enhydra.org
Mondrian OLAP server http://sourceforge.net/projects/mondrian/
DataVision Reporting Tool http://datavision.sourceforge.net

Commercial Reporting tools that look interesting
-------------------------------------
Databeacon http://www.databeacon.com
Intelliview http://www.intelliview.com