Power*architect 0.9.9 free download

 
Power-Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.

- Accesses source databases via JDBC
- Connects to multiple source databases concurrently
- Compares data models, database structures and identifies discrepencies
- Drag-and-drop source tables, columns into the playpeN
- Remembers the origin of each column
- Generates source-to-target visual Mapping Reports
- Forward-engineers to PostgresSQL, Oracle, MS SQL Server, more
- Saves source data structure snapshots in the project, so you can work remotely
- All project data is stored in an easy-to-parse XML format
- BSD licensed

WHAT'S NEW

Version 0.9.9:

- Added support for explicitly named sequences in PostgreSQL and Oracle
- Added the ability to choose the constraint checking deferrability policy on foreign key relationships on supported platforms
- Tweaked the database comparison feature to ignore meaningless data type differences between columns (for example, DECIMAL vs. NUMERIC)
- Got rid of an excessive repainting problem introduced in version 0.9.8 (improves drawing performance)
- Added the SQL BOOLEAN type to the set of generic types. It forward engineers to BOOLEAN on platforms that support it, and TINYINT on platforms that lack the BOOLEAN type.
- Added DDL (forward engineering) support for HSQLDB
- Fixed a bug in the SQL script dialog where if the user has chosen not to continue after an error, clicking execute has no effect.
- Added a GUI relationship column mapping editor, allowing you to change which primary key column a foreign key maps to in the relationship properties editor.
- Fixed support for self-referencing relationships (where the primary key and foreign key are in the same table).
- Improved 'Zoom-to-Fit' feature so that it can zoom-to-fit on selected objects in the playpen instead of the entire model. Useful for very large data models.
- The table profiler can now optionally perform its calculations locally, instead of on the database server. This may improve profiling performance.
- Changed the action for Enter in the play pen to edit the selected item, it is no longer limited to columns. Follow the link and free download Power*Architect now.  

DETAILS

Related Tags

architect architect software database architect home architect sun architect 3d home architect

Related downloads

Apple & MAC news

• Nokia Sues Apple Over 10 Patents. Apple Countersues Nokia Over 13 Patents
  On October 22 we all had a big surprise to find out that Nokia has ...
• Matrox MXO2 Supports Adobe Premiere Pro CS4 4.2 on Mac
  MXO2 LE, Matrox MXO2 Mini, MXO2 and MXO2 Rack now support Adobe Premiere Pro CS4 ...
• Create an iPhone Worm and You?ll get a job
  Not long after spreading the world?s first iPhone worm, Ashley Towns got hired by Mogeneration, ...