Multi platform, multi database, data modeling and profiling tool with support for PostgreSQL, Oracle, MS SQL Server etc.
It has features geared specifically to the data warehouse architect.
The Community edition is free.
Ranked in these QuestionsQuestion Ranking
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
Pro Reverse engineering
Pro Drag and Drop
Con Black & white diagrams
No colors in diagrams.
Con The manual is not free
The SQL Power Architect User Guide costs $ 99.