The Power*Architect is a Java-based data modeling tool geared specifically for data darehouse and data mart design. It allows the designer to open multiple concurrent source database connections, create and explore profiles of the source data, 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.
This release marks the first public release of the product under an open source license. It includes enhancements and bugfixes in many areas, including ETL integration with Pentaho's open source Kettle ETL tool, robust project file loading and saving in the face of illegal XML characters, enhanced usability and appearance, MySQL support, and more.
URL: SQL Power - POWER*ARCHITECT Data Modeling Tool