SQL Power Business Intelligence Productivity Tools

Data Modeling & Profiling Tool: SQL Power Architect

Data Modeling & Profiling Tool: SQL Power Architect

 

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.

 

image: Data Modelling Tool

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
  • Free Download (Open Source, GPL v.3 licensed) (Community Edition)

 

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.

 

image: Playpen Design Workspace

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

image: Data Profiling

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

 

Roadmap / Upcoming Releases

DateVersion & Features
Current SQL Power Architect Community Edition 1.07
SQL Power Architect Enterprise Edition 1.05
2014 Q3 SQL Power Architect Community Edition 1.08
  • Improved project file format (simplified format, smaller files, faster saves)
  • Improved 'undo' functionality
  • Performance enhancements & bug fixes
SQL Power Architect Enterprise Edition 1.08
  • Improved server/client synchronization
  • Improvements, performance enhancements and bug fixes from 1.08 Community Edition
2014 Q4 NEW! SQL Power Architect "Pro" Edition 1.08
  • Single-user, desktop-based application
  • Some Enterprise features, starting with Custom Data Domains & Types, with more features to be added later

 

 

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!

Quick Links

Contact Us

Member Log-in

Email/ID

Password

Need an account?
Register for free