The Power*Architect is a data modeling tool withadditional features geared specifically for datawarehouse and data mart design. It allows thedesigner to open multiple concurrent sourcedatabase connections, create and explore profilesof 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 modelingplaypen, and forward engineer the resultant targetdatabase and its associated ETL template.License: GNU General Public License v3Changes:
This release has a number of bugfixes andusability improvements, improved support forcreating, editing, and reverse-engineeringindexes, and preliminary support for Apache Derby.This is also the first release licensed under theGPL version 3.

More...