The Power Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
Using this program you can:
Access source databases via JDBC.
Connect to multiple source databases concurrently.
Compare data models & database structures and identifies discrepancies.
Drag-and-drop source tables & columns into the playpen.
Remember the origin of each column.
Generate source-to-target visual Mapping Reports.
Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more.
Save source data structure snapshots in the project, so you can work remotely.
All project data is stored in an easy-to-parse XML format.
OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels.