The Power*Architect is a user-friendly data modeling tool with ETL Support!
DESCRIPTION
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
Free Download & Open-Source Development
Recommended download:
Power*Architect for Mac OS X
Looking for a different download?
See below for more options.
Power*Architect for Windows
runnable installer · Java Runtime 5 or greater required
Download Download Power*Architect for Windows
Power*Architect for Mac
DMG disk image · OS X 10.4 or greater required
Download Download Power*Architect for Mac OS X
Power*Architect for Unix/Generic
launch from command line · Java Runtime 5 or greater required
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.
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.
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.
http://download.sqlpower.ca/architect/current.html Categories: Office Applications - Data Modeling - Mac System X - Leopard - Tiger - PPC - MacIntel - LINUX - Windows