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, 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 fixes a bug that caused corrupt project files to be saved. The handling of automatic cascading primary keys in multi-level identifying relationships now works better. The profile manager is now even more stable. It is now possible to add new database connection types from within the GUI.
URL: SQL Power - Power*Architect Data Modeling Tool