Comparison of data modeling tools

Short description: Comparison of notable data modeling tools

This article provides a comparison of notable data modeling tools, including standalone tools specifically designed for data modeling and tools that support data modeling as part of a broader modeling environment.[1]

## Contents

* 1 General
* 2 Features
* 3 See also
* 4 References

## General

Tool  | Creator  | Target Business Size  | License | Supported Database Platforms  | Supported OSs  | Standalone or bundled into a larger toolkit  | Launch Date

|
|
|
|
|
|
|

Astah[2] | Change Vision  | Enterprises  | Proprietary | MySQL, Oracle,  | Windows, macOS, Linux  | Standalone  | 2006
Database Workbench[3] | Upscene Productions  | SMBs and enterprises  | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB | Windows, Linux and FreeBSD (both through Wine)  | Standalone  | 2001
DbSchema[4] | Wise Coders GmbH  | SMBs and enterprises  | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB, SQLite, PostgreSQL, Sybase | Windows, Linux, macOS  | Standalone  | 2018
Enterprise Architect[5] | Sparx Systems  | SMBs and enterprises  | Proprietary | IBM Db2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux (Wine), macOS (via CrossOver)  | Data modeling is supported as part of a complete modeling platform.  | 2000
ER/Studio[6] | Embarcadero (acquired by IDERA) | SMBs and enterprises  | Proprietary | Access, Snowflake, Microsoft Azure IBM Db2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL  | Windows  | Standalone  | 1998
Erwin Data Modeler[7] | Logic Works (now Quest)  | SMBs and enterprises  | Proprietary | Access, IBM Db2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL  | Windows  | Standalone  | 1998
MagicDraw[8] | No Magic | Enterprises, SMBs, personal  | Proprietary | MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2 | Windows, Linux, macOS  | Standalone  | 1995
ModelRight[9] | ModelRight  | Enterprises, SMBs, personal  | Proprietary | Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2 | Windows  | Standalone  | 2005
MongoDB Compass[10] | MongoDB, Inc. | Enterprise, SMBs, Personal | Server Side Public License | Any MongoDB Server (Atlas, Localhost, EA, Community, etc.) | Linux (64-bit), Windows (64-bit), Mac OS (64-bit)  | Standalone or bundled into a larger toolkit  | 2015
MySQL Workbench[11] | MySQL (An Oracle Company)  | SMBs - personal  | Proprietary or GPL | MySQL | Linux, Windows, macOS  | Standalone  | 2006
Navicat Data Modeler[12] | PremiumSoft  | SMBs and enterprises  | Proprietary | MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite | Windows, macOS, Linux  | Standalone  | 2012
NORMA Object-Role Modeling[13] | Terry Halpin  | SMBs and enterprises  | Open source (CPL)  | MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2 | Windows  | Visual Studio Extension  | 2005
Open ModelSphere[14] | Grandite  | Enterprises - SMBs - personal  | Open source (GNU GPL3)  | MS SQL Server, MySQL, PostgreSQL, Oracle, IBM Db2 | Windows, macOS, Linux  | Standalone with Data, UML, and process modeling  | 2008
Oracle SQL Developer Data Modeler[15] | Oracle | Enterprises  | Proprietary | Oracle, MS SQL Server, IBM Db2 | Cross-platform  | Standalone  | 2009
PowerDesigner[16] | SAP | SMBs and enterprises  | Proprietary | Access, Greenplum, Apache Hive, HP Neoview, IBM Db2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick Warehouse, SAP business Suite, SAP Hana, SAP Adaptive Server Enterprise, SAP IQ, SAP SQL Anywhere, MS SQL Server, Teradata | Windows  | Standalone  | 1989
Software Ideas Modeler[17] | Dusan Rodina  | Enterprises, SMBs, personal  | Proprietary | MS SQL Server, MySQL | Windows  | Standalone  | 2009
SQLServer Management Studio[18] | Microsoft | Unknown  | Proprietary | MS SQL Server | Windows  | Standalone  | 2005
SQLyog[19] | Webyog, Inc.  | Enterprises, SMBs, personal  | Proprietary | MySQL, MariaDB | Windows and Linux (using Wine)  | Standalone  | 2001
Toad Data Modeler[20] | Quest Software | SMBs and enterprises  | Proprietary | Access, IBM Db2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, Oracle | Windows  | Standalone  | 2005 (before this date known as CaseStudio)
Tool  | Creator  | Target Business Size  | License | Supported Database Platforms  | Supported OSs  | Standalone or bundled into a larger toolkit  | Launch Date

## Features

Tool  | Supported data models (conceptual, logical, physical)  | Supported notations  | Forward engineering  | Reverse engineering  | Model/database comparison and synchronization  | Teamwork/repository

|
|
|
|
|
|

Database Workbench | Conceptual, logical, physical  | IE (Crow’s foot) | Yes  | Yes  | Update database and/or update model  | No
Enterprise Architect | Conceptual, Logical & Physical + MDA Transform of Logical to Physical  | IDEF1X, UML DDL, Information Engineering & ERD  | Yes  | Yes  | Update database and/or update model  | Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge).
ER/Studio  | Logical, physical, ETL  | IDEF1X, IE (Crow’s feet)  | Yes  | Yes  | Update database and/or update model  | ER/Studio Repository and Team Server (formerly Portal/CONNECT) for web based publishing collaboration and model management, with Business Glossary as standard.
MagicDraw | Conceptual, Logical & Physical + MDA Transform of Logical to Physical  | IDEF1X, UML DDL, Information Engineering & ERD  | Yes  | Yes  | Update database and/or update model  | Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge).
MySQL Workbench | Physical  | IDEF1X, IE (Crow’s feet), UML, and more  | Yes  | Yes  | Update database and/or update model  | No
Navicat Data Modeler  | Conceptual, Logical & Physical  | IE (Crow’s foot)  | Yes  | Yes  | Update database and/or update model  | No
NORMA Object-Role modeling  | Conceptual (ORM), Logical, Physical  | ORM, Relational(Crow’s foot option), Barker  | Yes  | Yes  | Update database and/or update model  | No
Open ModelSphere | Conceptual, Logical, physical  | IDEF1X, IE (Crow’s foot), and more  | Yes  | Yes  | Update database and/or update model  | No
Oracle SQL Developer Data Modeler  | Logical, physical  | Barker, IE (Crow’s foot), and Bachman  | Yes  | Yes  | Update database and/or update model  | Yes
PowerDesigner | Conceptual, logical, physical  | IDEF1X, IE (Crow’s foot), and more  | Yes  | Yes  | Update database and/or update model  | Yes
Software Ideas Modeler | Conceptual, logical, physical  | IDEF1X, IE (Crow’s foot), UML and more  | Yes  | Yes  | Update database and/or update model  | Yes
Toad Data Modeler | Logical, physical  | IDEF1X, IE (Crow’s foot), and more  | Yes  | Yes  | Update database and/or update model  | Yes

## See also

* Comparison of database administration tools
* List of Unified Modeling Language tools
* Data modeling
* IDEF1X

## References

1. ↑ (in en-US) Database Modeling and Design. 2011-02-10. ISBN 978-0-12-382020-4. https://shop.elsevier.com/books/database-modeling-and-design/teorey/978-0-12-382020-4.
2. ↑ "Change Vision, Inc.". https://www.change-vision.com/index_en.html.
3. ↑ "Database Workbench: database GUI tool for MySQL, MariaDB, InterBase, Firebird, Oracle, PostgreSQL, SQL Server, NexusDB and SQLite @ Upscene Productions". https://www.upscene.com/database_workbench/.
4. ↑ "Database Workbench: database GUI tool for MySQL, MariaDB, InterBase, Firebird, Oracle, PostgreSQL, SQL Server, NexusDB and SQLite @ Upscene Productions". https://www.upscene.com/database_workbench/.
5. ↑ "Documentation | Sparx Enterprise Architect SAAS" (in en-US). 2023-07-13. https://saas.sparxsystems.com/ea-saas-documentation/.
6. ↑ Hirsch, Ryan (2025-09-10). "Enterprise Data Architecture: A Complete Guide" (in en-US). https://erstudio.com/blog/enterprise-data-architecture/.
7. ↑ https://www.dlt.com/sites/default/files/resource-attachments/2024-05/erwin-data-modeler-datasheet-147769.pdf
8. ↑ "MagicDraw" (in en). 2023-05-22. https://www.3ds.com/products/catia/no-magic/magicdraw.
9. ↑ "ModelRight - DBMS Tools" (in en). https://dbmstools.com/tools/modelright.
10. ↑ "MongoDB Compass" (in en-us). https://www.mongodb.com/products/tools/compass.
11. ↑ "MySQL :: MySQL Workbench". https://www.mysql.com/products/workbench/.
12. ↑ "Products | Navicat". https://www.navicat.com/en/products#navicat-data-modeler.
13. ↑ https://marketplace.visualstudio.com/items?itemName=ORMSolutions.NORMA2019
14. ↑ "Open ModelSphere - User's Guide". http://www.modelsphere.com/org/help/User_Guide.html.
15. ↑ https://www.oracle.com/database/sqldeveloper/technologies/sql-data-modeler/
16. ↑ "SAP Help Portal | SAP Online Help". https://help.sap.com/docs/SAP_POWERDESIGNER/abd3434b4987485c92057ab9392aadbe/c7da4cc66e1b10148d14bee11248a325.html.
17. ↑ "Diagram CASE Tool for Software Modeling & Analysis - UML, BPMN, ERD". https://www.softwareideas.net/.
18. ↑ rwestMSFT. "SQL Server Management Studio" (in en-us). https://learn.microsoft.com/en-us/ssms/.
19. ↑ "SQLyog Ultimate - Powerful MySQL Development and Administration" (in en-US). https://webyog.com/product/sqlyog/.
20. ↑ https://www.quest.com/documents/toad-data-modeler-datasheet-68531.pdf

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/Comparison of data modeling tools. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Comparison_of_data_modeling_tools&oldid=4345088"