Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Comparison of data modeling tools
open-in-new
<h2 id="general">General</h2> <table><tbody><tr><th>Tool</th><th>Creator</th><th>Target Business Size</th><th><a href="/facts/Software_license/7enfIqhL">License</a></th><th>Supported Database Platforms</th><th>Supported OSs</th><th>Standalone or bundled into a larger toolkit</th><th>Launch Date</th></tr><tr><td><a href="/facts/Astah/YmSLdWfG">Astah</a></td><td>Change Vision</td><td>Enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>,</td><td>Windows, macOS, Linux</td><td>Standalone</td><td>2006</td></tr><tr><td><a href="/facts/Database_Workbench/aMpFKyV7">Database Workbench</a></td><td>Upscene Productions</td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/Firebird_(database_server)/hKVdDnBR">Firebird</a>, <a href="/facts/InterBase/V7BHtV5N">InterBase</a>, <a href="/facts/SQL_Anywhere/hMxuvhhF">SQL Anywhere</a>, <a href="/facts/NexusDB/g7PASESX">NexusDB</a>, <a href="/facts/MariaDB/QWobVFIq">MariaDB</a></td><td>Windows, Linux and FreeBSD (both through Wine)</td><td>Standalone</td><td>2001</td></tr><tr><td>DbSchema</td><td>Wise Coders GmbH</td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/Firebird_(database_server)/hKVdDnBR">Firebird</a>, <a href="/facts/InterBase/V7BHtV5N">InterBase</a>, <a href="/facts/SQL_Anywhere/hMxuvhhF">SQL Anywhere</a>, <a href="/facts/NexusDB/g7PASESX">NexusDB</a>, <a href="/facts/MariaDB/QWobVFIq">MariaDB</a>, <a href="/facts/SQLite/1PwYzIft">SQLite</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Sybase/2U3d6RUt">Sybase</a></td><td>Windows, Linux, macOS</td><td>Standalone</td><td>2018</td></tr><tr><td><a href="/facts/Enterprise_Architect_(software)/ND88VrMT">Enterprise Architect</a></td><td><a href="/facts/Sparx_Systems/lBeXejgh">Sparx Systems</a></td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/Firebird_(database_server)/hKVdDnBR">Firebird</a>, <a href="/facts/InterBase/V7BHtV5N">InterBase</a>, <a href="/facts/Informix/jDdeW93c">Informix</a>, <a href="/facts/Ingres_(database)/Bp9kqJV4">Ingres</a>, <a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/SQLite/1PwYzIft">SQLite</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Sybase/2U3d6RUt">Sybase</a></td><td>Windows, Linux (Wine), macOS (via <a href="/facts/CrossOver_(software)/a9u8qods"> CrossOver</a>)</td><td>Data modeling is supported as part of a complete modeling platform.</td><td>2000</td></tr><tr><td><a href="/facts/ER/Studio/sKps6xgJ">ER/Studio</a></td><td><a href="/facts/Embarcadero_Technologies/Cw6SpURL">Embarcadero (acquired by IDERA)</a></td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/Snowflake_Inc./t8zG3Xld"> Snowflake</a>, <a href="/facts/Microsoft_Azure/CCnIHTHd">Microsoft Azure</a> <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/Informix/jDdeW93c">Informix</a>, Hitachi HiRDB, <a href="/facts/Firebird_(database_server)/hKVdDnBR">Firebird</a>, <a href="/facts/Interbase/V7BHtV5N">Interbase</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/Netezza/jVU2WM4f">Netezza</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Sybase/2U3d6RUt">Sybase</a>, <a href="/facts/Teradata/sarnALYT">Teradata</a>, <a href="/facts/Visual_FoxPro/yLCCj4HM">Visual Foxpro</a> and others via ODBC/ANSI SQL</td><td>Windows</td><td>Standalone</td><td>1998</td></tr><tr><td><a href="/facts/Erwin_Data_Modeler/BFjR6mfC">Erwin Data Modeler</a></td><td>Logic Works (now Quest)</td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/Informix/jDdeW93c">Informix</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/Netezza/jVU2WM4f">Netezza</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Sybase/2U3d6RUt">Sybase</a>, and others via ODBC/ANSI SQL</td><td>Windows</td><td>Standalone</td><td>1998</td></tr><tr><td><a href="/facts/MagicDraw/us2Sr2Ky">MagicDraw</a></td><td><a href="/facts/No_Magic/Jht7YIIn">No Magic</a></td><td>Enterprises, SMBs, personal</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a></td><td>Windows, Linux, macOS</td><td>Standalone</td><td>1995</td></tr><tr><td><a href="/facts/SQL_Server_Management_Studio/pPIVukeP">SQL Server Management Studio</a></td><td><a href="/facts/Microsoft/nGIDDXdx">Microsoft</a></td><td>Unknown</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a></td><td>Windows</td><td>Standalone</td><td>2005</td></tr><tr><td>ModelRight</td><td>ModelRight</td><td>Enterprises, SMBs, personal</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a></td><td>Windows</td><td>Standalone</td><td>2005</td></tr><tr><td><a href="/facts/MySQL_Workbench/PI2qkpIw">MySQL Workbench</a></td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a> (An <a href="/facts/Oracle_Corporation/0z14FygH">Oracle</a> Company)</td><td>SMBs - personal</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a> or <a href="/facts/GNU_General_Public_License/S75KhLSX">GPL</a></td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a></td><td>Linux, Windows, macOS</td><td>Standalone</td><td>2006</td></tr><tr><td><a href="/facts/Navicat/PdB13bE3">Navicat</a> Data Modeler</td><td>PremiumSoft</td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/SQLite/1PwYzIft">SQLite</a></td><td>Windows, macOS, Linux</td><td>Standalone</td><td>2012</td></tr><tr><td><a href="/facts/NORMA_(software_modeling_tool)/3yn8aSG2">NORMA</a> Object-Role Modeling</td><td>Terry Halpin</td><td>SMBs and enterprises</td><td><a href="/facts/Open_source/7X9rCdz4">Open source</a> (<a href="/facts/Common_Public_License/M12x3DgF">CPL</a>)</td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Oracle_Database/FHv5g732">Oracle</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a></td><td>Windows</td><td>Visual Studio Extension</td><td>2005</td></tr><tr><td><a href="/facts/Open_ModelSphere/eJAvIolG">Open ModelSphere</a></td><td>Grandite</td><td>Enterprises - SMBs - personal</td><td><a href="/facts/Open_source/7X9rCdz4">Open source</a> (<a href="/facts/GNU_GPL3/S75KhLSX">GNU GPL3</a>)</td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/Oracle_Database/FHv5g732">Oracle</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a></td><td>Windows, macOS, Linux</td><td>Standalone with Data, UML, and process modeling</td><td>2008</td></tr><tr><td><a href="/facts/Oracle_SQL_Developer/DVSut3Xe">Oracle SQL Developer</a> Data Modeler</td><td><a href="/facts/Oracle_Corporation/0z14FygH">Oracle</a></td><td>Enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Oracle_database/FHv5g732">Oracle</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a></td><td>Cross-platform</td><td>Standalone</td><td>2009</td></tr><tr><td><a href="/facts/PowerDesigner/keVyVdpr">PowerDesigner</a></td><td><a href="/facts/SAP_SE/pVwH8lks">SAP</a></td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/Pivotal_Greenplum_Database/CNIAxda2">Greenplum</a>, <a href="/facts/Apache_Hive/G3M79J6b">Apache Hive</a>, <a href="/facts/HP_Neoview/swxTP9NY">HP Neoview</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/Informix/jDdeW93c">Informix</a>, <a href="/facts/Ingres_(database)/Bp9kqJV4">Ingres</a>, <a href="/facts/InterBase/V7BHtV5N">Interbase</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/Netezza/jVU2WM4f">Netezza</a>, <a href="/facts/NonStop_SQL/JSIk6m3c">NonStop SQL</a>, <a href="/facts/Oracle_Database/FHv5g732">Oracle</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, Red Brick Warehouse, <a href="/facts/SAP_Business_Suite/BjDdIg6C">SAP business Suite</a>, <a href="/facts/SAP_HANA/QUmJmqtj">SAP Hana</a>, <a href="/facts/Adaptive_Server_Enterprise/eocfB6I6">SAP Adaptive Server Enterprise</a>, <a href="/facts/SAP_IQ/XLsYXDac">SAP IQ</a>, <a href="/facts/SQL_Anywhere/hMxuvhhF">SAP SQL Anywhere</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/Teradata/sarnALYT">Teradata</a></td><td>Windows</td><td>Standalone</td><td>1989</td></tr><tr><td><a href="/facts/Software_Ideas_Modeler/dkIUswfm">Software Ideas Modeler</a></td><td>Dusan Rodina</td><td>Enterprises, SMBs, personal</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a></td><td>Windows</td><td>Standalone</td><td>2009</td></tr><tr><td><a href="/facts/SQLyog/ocoTGh0X">SQLyog</a></td><td>Webyog, Inc.</td><td>Enterprises, SMBs, personal</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MariaDB/QWobVFIq">MariaDB</a></td><td>Windows and Linux (using Wine)</td><td>Standalone</td><td>2001</td></tr><tr><td><a href="/facts/Toad_Data_Modeler/9uSjVdCd">Toad Data Modeler</a></td><td><a href="/facts/Quest_Software/lNUrFVqJ">Quest Software</a></td><td>SMBs and enterprises</td><td><a href="/facts/Proprietary_software/9zcskxYL">Proprietary</a></td><td><a href="/facts/Microsoft_Access/1tID4rKM">Access</a>, <a href="/facts/IBM_Db2/2cYITuuY">IBM Db2</a>, <a href="/facts/Informix/jDdeW93c">Informix</a>, <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, <a href="/facts/MariaDB/QWobVFIq">MariaDB</a>, <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a>, <a href="/facts/MS_SQL_Server/eCdt2JBL">MS SQL Server</a>, <a href="/facts/SQLite/1PwYzIft">SQLite</a>, <a href="/facts/Oracle_Database/FHv5g732">Oracle</a></td><td>Windows</td><td>Standalone</td><td>2005 (before this date known as CaseStudio)</td></tr><tr><th>Tool</th><th>Creator</th><th>Target Business Size</th><th><a href="/facts/Software_license/7enfIqhL">License</a></th><th>Supported Database Platforms</th><th>Supported OSs</th><th>Standalone or bundled into a larger toolkit</th><th>Launch Date</th></tr></tbody></table> <h2 id="features">Features</h2> <table><tbody><tr><th>Tool</th><th>Supported data models (conceptual, logical, physical)</th><th>Supported notations</th><th>Forward engineering</th><th>Reverse engineering</th><th>Model/database comparison and synchronization</th><th>Teamwork/repository</th></tr><tr><td><a href="/facts/Database_Workbench/aMpFKyV7">Database Workbench</a></td><td>Conceptual, logical, physical</td><td><a href="/facts/Entity%E2%80%93relationship_model/U8A0mwYe">IE (Crow’s foot)</a></td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>No</td></tr><tr><td><a href="/facts/Enterprise_Architect_(software)/ND88VrMT">Enterprise Architect</a></td><td>Conceptual, Logical & Physical + MDA Transform of Logical to Physical</td><td><a href="/facts/IDEF1X/HX56QXmF">IDEF1X</a>, <a href="/facts/UML/qdd3WcLv">UML</a> DDL, Information Engineering & <a href="/facts/Entity-relationship_diagram/U8A0mwYe">ERD</a></td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge).</td></tr><tr><td><a href="/facts/ER/Studio/sKps6xgJ">ER/Studio</a></td><td>Logical, physical, ETL</td><td>IDEF1X, IE (Crow’s feet)</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>ER/Studio Repository and Team Server (formerly Portal/CONNECT) for web based publishing collaboration and model management, with Business Glossary as standard.</td></tr><tr><td><a href="/facts/MagicDraw/us2Sr2Ky">MagicDraw</a></td><td>Conceptual, Logical & Physical + MDA Transform of Logical to Physical</td><td>IDEF1X, UML DDL, Information Engineering & ERD</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge).</td></tr><tr><td><a href="/facts/MySQL_Workbench/PI2qkpIw">MySQL Workbench</a></td><td>Physical</td><td>IDEF1X, IE (Crow’s feet), UML, and more</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>No</td></tr><tr><td><a href="/facts/Navicat/PdB13bE3">Navicat</a> Data Modeler</td><td>Conceptual, Logical & Physical</td><td>IE (Crow’s foot)</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>No</td></tr><tr><td><a href="/facts/NORMA_(software_modeling_tool)/3yn8aSG2">NORMA</a> Object-Role modeling</td><td>Conceptual (ORM), Logical, Physical</td><td>ORM, Relational(Crow’s foot option), Barker</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>No</td></tr><tr><td><a href="/facts/Open_ModelSphere/eJAvIolG">Open ModelSphere</a></td><td>Conceptual, Logical, physical</td><td>IDEF1X, IE (Crow’s foot), and more</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>No</td></tr><tr><td><a href="/facts/Oracle_SQL_Developer/DVSut3Xe">Oracle SQL Developer</a> Data Modeler</td><td>Logical, physical</td><td>Barker, IE (Crow’s foot), and Bachman</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Yes</td></tr><tr><td><a href="/facts/PowerDesigner/keVyVdpr">PowerDesigner</a></td><td>Conceptual, logical, physical</td><td>IDEF1X, IE (Crow’s foot), and more</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Yes</td></tr><tr><td><a href="/facts/Software_Ideas_Modeler/dkIUswfm">Software Ideas Modeler</a></td><td>Conceptual, logical, physical</td><td>IDEF1X, IE (Crow’s foot), UML and more</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Yes</td></tr><tr><td><a href="/facts/Toad_Data_Modeler/9uSjVdCd">Toad Data Modeler</a></td><td>Logical, physical</td><td>IDEF1X, IE (Crow’s foot), and more</td><td>Yes</td><td>Yes</td><td>Update database and/or update model</td><td>Yes</td></tr></tbody></table> <h2 id="see-also">See also</h2> <ul><li><a href="/facts/Comparison_of_database_administration_tools/CkDoCj7A">Comparison of database administration tools</a></li> <li><a href="/facts/List_of_Unified_Modeling_Language_tools/SF0W2Fjm">List of Unified Modeling Language tools</a></li> <li><a href="/facts/Data_modeling/bryA2moP">Data modeling</a></li> <li><a href="/facts/IDEF1X/HX56QXmF">IDEF1X</a></li></ul>