Thread: PostgreSQL and Datawarehouse tools
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 ?
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