Powerarchitect

Data modeling and profiling tool

[ excerpt from developer’s www site ]

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.

Plus, the Power*Architect has the ability to take snapshots of database structures, allowing users to design DW data models while working offline.

WWW http//software.sqlpower.ca/page/demos