The 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.
License: GNU General Public License v3
Changes:
This release candidate includes several new features and bugfixes. The most notable is support for creating OLAP schemas and exporting them to Mondrian's XML schema definition format. Other new features include support for ON UPDATE and ON DELETE actions, a new playpen navigation window, a Russian translation of the user interface, and the ability to modify the color, line, and corner styles of multiple tables simultaneously.
More...