Power*Architect 0.9.1
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.
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 an innovative Java-based data modeling tool 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.
The Power*Architect is a user-friendly Data Warehouse data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect
Requirements:
OS X 10.4 or greater with the Java 5 Update required
Here are some key features of "Power*Architect":
Access any JDBC or ODBC accessible source database
Quickly create profiles of source data, including information about the size of the data in each column, maximum and minimum values, frequency distribution of values in a column, and more.
Profile information is saved with the project, so profile data can still be used to aid off-site design sessions when it is not possible to access the source databases.
Design the target database Data Model (Data Warehouse)
Compare the database structure of any two databases highlighting the structural differences and generating the required DDL to synchronize
Compare the Data Model data structures to an existing target database
Save a snapshot of all source systems' data structures in the project file, allowing data warehouse designers to evolve their target data model remotely
Forward engineer to Oracle, SQL Server, DB2, and PostgreSQL and more.
Forward engineer ETL Templates containing source-to-target data mappings
Invoke ETL Engine to load initial set of data into the target database
Enable easy centralized installation and updates to many end users (Supports Java WebStart technology).
The Power*Architect can 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.
Design your Data Warehouse in a fraction of the time with the Power*Architect.
We look forward to showing you how!
The Power*Architect is available now for download! The product is available for free to individuals for personal use. Commercial licensing and support are available at competitive prices. Please call us at 1-866-SQL-POWR to purchase.
tags
data warehouse the power*architect data modeling the data data model target database the source with the your data forward engineer target data source databases the project
Download Power*Architect 0.9.1
http://download.sqlpower.ca/architect/0.9.1/Architect-OSX-0.9.1.dmg
Authors software
|
 Power*Architect 0.9.1 (by  SQL Power Group Inc.)
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.
|
Similar software
|
Power*Architect 0.9.1 (by SQL Power Group Inc.)
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.
|
|
Data Architect 3.2 (by TheKompany.com)
Discover what database professionals have known for years — that enterprise databases are designed with enterprise modelling tools.
|
|
DataArchitect 3.5-060504 (by theKompany.com)
DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions.
|
|
DataMorph 2.14 (by Gerald Holmann)
DataMorph is an intuitive, easy to use data conversion tool that provides powerful conversion functions for the most common data interchange formats.
|
|
TDF Czar 2.6 (by Herb Bowie)
TDF Czar is a Java application/applet that does all sorts of useful things with tab-delimited data files.
|
Other software in this category
|
StudioCzar 2.2.3 (by Thetasphere, LLC)
StudioCzar is the premier project tracking, billing and reporting solution for the Agency, Graphics, or Design Studio environment.
|
|
CheckMark Payroll 6.6.5 (by CheckMark Software Inc.)
Are you the only one you know who dreads pay day? Help is on the way! From 401(k)s to vacation accruals, CheckMark Payroll keeps you on track, in compliance, and stress-free no matter what type of business you run.
|
Featured Software
Picture Address Book 6.0.5
Apimac Address Book is a practical telephone and address program for Mac that allows you to quickly and easily manage addresses, phone numbers, URLs and Email addresses.
Textris 1.0
Textris is an attempt to combine aspects of both these games into one fast paced test of your lexicon.
iMagine Photo 2.1.4
iMagine Photo adds imaging and drawing functionality to AppleScript.
0.00 
Freeware
8977K
RSS
