By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

PostgreSQL and Datawarehouse tools

P: n/a

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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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)

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

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.