|
|
 |
Power*Architect
Data Modeling & Profiling Tool
The 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.
|
 |
Features
- Accesses source databases via JDBC
- Connects to multiple source databases
concurrently
- Compares data models & database
structures and identifies
discrepancies
- Drag-and-drop source tables &
columns into the playpen
- Remembers the origin of each
column
- Generates source-to-target visual
Mapping Reports
- Forward/reverse engineers PostgreSQL,
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
- OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels
- GPL (version 3) licensed
Data Architects, DBA's, Analysts and
Designers rely on Data Modeling tools to
facilitate and simplify their data Modeling
efforts, while maximizing the use of their
resources. The Power*Architect allows these
busy highly technical resources to perform
this most intricate part of their job in a
fraction of the time.
Plus, the Power*Architect has the ability
to take snapshots of database structures,
allowing users to design DW data models while
working offline.
Whether you are building a Data Warehouse
or using data models to communicate business
rules, the Power*Architect will facilitate
and automate your data modeling efforts.
 |
"Playpen" Design Workspace
The tree view
makes it easy to navigate through the
database. Drag schemas or tables into the
playpen, then adjust the layout manually or
with the Auto-Layout function. |
 |
Quick & Easy Data ProfilingThe Data
Profiling feature is useful for exploring new
or unfamiliar databases... you can see
information about the size of the data in
each column, maximum & minimum values,
frequency distribution of values in a column
and more. |
The Power*Architect can also open multiple source databases concurrently,
even if they are from competing database vendors.
Another key feature of the Power*Architect that sets it apart
from other data modeling tools, is that it remembers the origin
of each column and is capable of automatically generating the
source-to-target data mappings.
Whether you're building or maintaining your Data Warehouse
data model, the Power*Architect will provide you a complete
view of all required database structures and will expedite
every aspect of your data warehouse design.
Recent & Upcoming Releases
| Version |
Release Date |
Enhancements New Features Improved Functionality |
| 1.0.0 |
Q1 2010 |
- Server-based offering
- Data Model Collaboration
- Meta Data Repository Maintenance screens
- Full thin client offering
|
| 0.9.14 |
Q1 2010 |
- Specify physical names for tables, columns, indexes, and FK constraints
- Proofreader/critic system for relational and OLAP modeling
- ERD Diagram labelling via Text box
- OLAP designer improvements
|
0.9.13  |
May 23 2009 |
- Copy & Paste columns and tables within the playpen and
from the tree into the playpen
- Refresh source database structures
- Produce a diagram with the physical names
- Produce well formatted Data Dictionary Report (thanks to community contribution!)
- Specify colour of relationship lines
- Specify default settings (name, data type, precision, etc) for newly created columns
- Specify verbs on foreign key relationships
- Better database structure caching to improve Oracle 10/11 performance
- Improved compatibility with SQL Server 2008
- SQL Query Tool to replace the older SQL Runner
- Database Types iGUI allows tweaking database type
behaviour without having to directly edit the pl.ini file
|
0.9.12  |
December 12 2008 |
- OLAP schema modeling
- Export OLAP schema to Mondrian XML
- ON DELETE & ON UPDATE support to forward & reverse engineering
- Playpen Navigator
- Russian translation
- Undo/redo functionality
- DDL interface & formatting
- Support for SQL Server 2000/2005 forward engineering
|
indicates this release is available for download
To request changes or feature additions to Power*Architect, please visit our Forum.
Power*Architect News, Reviews & Blogs
 |
|
|
 |
|
The Power*Architect is our tool of choice for this book... Multi-database support, Forward engineering, Reverse engineering, Model comparison...
it is one of the few or maybe even the only open source tool available that supports the four functions in the preceding list... In fact, there are a couple of unique features not available in any other tool, such as the ETL and OLAP options. |
|
 |
 |
|
 |
| Pentaho Solutions by Roland Bouman & Jos van Dongen |
|
 |
|
|
 |
|
What I'm using now, and recommend, is Power*Architect...
I think Power*Architect has a better interface than Mogwai,
creating models and generating SQL is quite easy and takes just
a few clicks. Power*Architect has been declared open source
just a few months ago, way to go guys! |
|
 |
 |
|
 |
|
Ventanazul Webzine |
|
 |
|
|
 |
|
Power*Architect delivered an ERD which is as well laid out as I have
seen: even high end tools I've tried couldn't make any better
job of it in the first pass. |
|
 |
 |
|
 |
|
Diary of a Database Geek |
|
 |
|
|
 |
|
Thank you for making my software
development work a little bit more enjoyable and productive with your
Power Architect tool. |
|
 |
 |
|
 |
| Tomislav Nakic-Alfirevic |
|
 |
|
|
 |
|
I love this application... Power*Architect fills a gap in available free database modelling software,
particularly in light of the native Linux version.
You have helped raise standards of development, and made the software world a better place. |
|
 |
 |
|
 |
| Sam Tuke, Web Developer |
|
News: Power*Architect Adds Cube Designer
|
 |
|