Power*Architect
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.
| Tags | Database |
|---|---|
| Licenses | GPLv3 |
| Operating Systems | OS Independent |
| Implementation | Java SQL |
| Translations | English Russian Korean |
Recent releases
- 25 May 2009 17:30
Changes: In addition to several bugfixes and usability enhancements, this release includes a number of new features. These include relationship labels, cut and paste support for tables, columns, and relationships, an HTML report generator, and more.
- 25 Apr 2009 08:50
Changes: This release added a refresh feature for source databases, an HTML data model report generator, support for Copy, Cut, and Paste for Tables, Columns, and Relationships, PDF export for OLAP Playpens, the ability to define default column properties, and the ability to label foreign key relations. Reverse engineering speed on Oracle has been greatly improved since the previous release. Several compatibility issues with SQL syntax in MySQL, PostgreSQL, and SQL Server have been solved.
- 05 Jan 2009 03:06
Changes: This release candidate includes a number of major bugfixes, including improvements in Print Preview and some stability improvements. A few new features were also added, including a new SQL Query Tool and an advanced PL.INI properties editor.
- 12 Dec 2008 23:07
Changes: This release includes several new features and bugfixes. The most notable addition since 0.9.11 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.
- 28 Nov 2008 21:28
Changes: This release candidate makes a couple of bugfixes to the previous release candidate. Major fixes include a fix to a error caused by a missing dependency when creating a New Measure in the OLAP Schema editor, and a fix to an error when using the Copy Table feature to copy data to a table in MySQL.
