- Home
- Database Design Tools
- SQL Power Architect
On the recordRead 9 Oct 202615 facts
SQL Power Architect
Plans and prices
Community Edition
Free
GPL v.3 licensed · Java Runtime 8 required for listed downloads
Read 9 Oct 2026 · bestofbi.com
On the record
- Database connections
- It accesses source databases via JDBC and can connect to multiple source databases concurrently.bestofbi.com · read 9 Oct 2026
- Data profiling
- Profiling shows column data size, maximum and minimum values, and value frequency distributions.bestofbi.com · read 9 Oct 2026
- Download platforms
- The download page offers installers for Windows and Mac OS X and a Unix/Generic command-line download.bestofbi.com · read 9 Oct 2026
- ETL metadata
- It remembers the origin of each column and generates source-to-target visual mapping reports.bestofbi.com · read 9 Oct 2026
- File format
- Project data is stored in an XML format described as easy to parse.bestofbi.com · read 9 Oct 2026
- Included JDBC drivers
- The download page lists bundled, preconfigured JDBC drivers for PostgreSQL 8.2, MS SQL Server 2012, MySQL 5.0, and HSQLDB 1.8.0.bestofbi.com · read 9 Oct 2026
- Intended users
- The product page identifies data architects, DBAs, analysts, and designers as users of the tool.bestofbi.com · read 9 Oct 2026
- License
- The GitHub repository identifies the project license as GPL-3.0.github.com · read 9 Oct 2026
- Model comparison
- It compares data models and database structures and identifies discrepancies.bestofbi.com · read 9 Oct 2026
- Offline work
- It saves source data structure snapshots in projects so users can work remotely or design models offline.bestofbi.com · read 9 Oct 2026
- OLAP
- Its OLAP schema modeling covers cubes, measures, dimensions, hierarchies, and levels.bestofbi.com · read 9 Oct 2026
- Purpose
- SQL Power Architect is a data modeling and profiling tool created for data warehouse designers.bestofbi.com · read 9 Oct 2026
- Release status
- The GitHub release page lists version 1.9.0, whose notes identify the software release as Community Edition 1.0.9 and say it supports Java 8.github.com · read 9 Oct 2026
- Reverse engineering
- It can reverse-engineer existing databases and forward- and reverse-engineer PostgreSQL, Oracle, MS SQL Server, and other databases.bestofbi.com · read 9 Oct 2026
- Runtime requirement
- The listed downloads require Java Runtime 8; the Mac download also specifies OS X 10.4 or greater.bestofbi.com · read 9 Oct 2026
