When comparing SQL Power Architect vs OmniDB, the Slant community recommends OmniDB for most people. In the question“What are the best cross-platform GUI tools for DBMS?” OmniDB is ranked 1st while SQL Power Architect is ranked 11th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Convert
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
Pro Reverse engineering
Pro Drag and Drop
Pro Open source and actively developed
Pro PL/pgSQL Debugger
Pro Web-based, can be run locally or deployed on server
OmniDB is web-based and works similarly to pgAdmin 4. You can run the web server locally or deploy it on a server, and connect to it through a web browser.
Pro Multi-database
Supports PostgreSQL, Oracle, MySQL and MariaDB, with support in the pipeline for Firebird, SQLite, SQL Server and DB2.
Pro Simple and intuitive interface for everyone.
An easy-to-discover tree panel to classify features/objects on left (with context menus if you don't know what you're doing). Tabs panels for ins and outs on right. That's it.
Pro OmniDB has 2ndQuadrant as its main sponsor
Cons
Con The manual is not free
The SQL Power Architect User Guide costs $ 99.