SQL Power Architect is a data modeling tool with additional features geared specifically for data
warehouse and data mart design. It allows the
designer to open multiple concurrent source
database connections, create and explore profiles
of the source data, discover differences between two schemas (even if they're on different database platforms), drag and drop source schemas,
tables, and columns into the data modeling
playpen, and forward engineer the resultant target
database and its associated ETL template.