companyproductsserviceandsupportpartnersresourcesforum
SQL Power Architect Data Modeling Tool

 

SQL Power Architect

Data Modeling & Profiling Tool

The SQL Power Architect data modeling tool was 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

 

open source 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 SQL Power Architect allows these busy highly technical resources to perform this most intricate part of their job in a fraction of the time.

Plus, SQL 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, SQL 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.

munge process

Quick & Easy Data Profiling

The 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.

 

SQL Power Architect can also open multiple source databases concurrently, even if they are from competing database vendors. Another key feature of the SQL 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, SQL Power Architect will provide you a complete view of all required database structures and will expedite every aspect of your data warehouse design.

 

SQL Power Architect News, Reviews & Blogs


The SQL 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 SQL Power Architect... I think SQL Power Architect has a better interface than Mogwai, creating models and generating SQL is quite easy and takes just a few clicks. SQL Power Architect has been declared open source just a few months ago, way to go guys!
Ventanazul Webzine

SQL 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

SQL Power Architect is the best ERD drawing tool I've found
Jon's Code Blog

Thank you for making my software development work a little bit more enjoyable and productive with your SQL Power Architect tool.
Tomislav Nakic-Alfirevic

I love this application... SQL 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

Now you can get hold of a data modelling tool that is open source rather than having to buy Erwin
Andy on Enterprise Software

News: SQL Power Architect Adds Cube Designer

 

Recent & Upcoming Releases

Version Release Date Enhancements
  • New Features   IMPROVED  Improved Functionality
1.0.0 Q1 2010
  • Server-based offering
  • Data Model Collaboration
  • Meta Data Repository Maintenance screens
  • Full thin client offering
  • 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.15  Jan. 29 2010
  • MySQL DDL generator now allows column comments
  • Improved copy/paste of tables between different schemas
detailed release notes
Yes indicates this release is available for download

To request changes or feature additions to SQL Power Architect, please visit our Forum.

 



Data Modeling & Profiling have never been easier...
download the SQL Power Architect today!


Contact Us
Info Request
Demo Request

Member Log-In




Need an account?
Register for free