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

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.

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