|
Comparison of data modeling toolsThis article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment. General|
| CA ERwin Data Modeler | CA Technologies | SMBs and enterprises | Commercial (Free, limited, community edition available) | Access, IBM DB2, Informix, Ingres, MySQL, Oracle, Progress, MS SQL Server, Sybase, Teradata | All versions of Windows | Standalone | 1992? | | Database Visual Architect | Visual Paradigm | SMBs and enterprises | Commercial | IBM DB2, Firebird, Progress OpenEdge, Cache, MS SQL Server, MySQL, HSQLDB, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux, MAC OS | Standalone (or as part of an UML modeling environment) | Unknown | | dbConstructor | DBDeveloper Solutions | SMBs | Commercial | Oracle, MS SQL Server, MySQL, Access | All versions of Windows | Standalone | Unknown | | DbSchema | Wise Coders Solutions | SMBs | Commercial | MySQL, PostgreSQL, MS SQL Server, Derby, Firebird, Oracle, IBM DB2, Informix, HSql, Pointbase, Mimer, Pervasive, Sybase | All versions of Windows | Standalone | 2005 | | DbWrench Database Design | Nizana Systems | SMBs | Commercial | MS SQL Server, Oracle, PostgreSQL, MySQL | Windows, Linux, Mac | Standalone | 2005 | | DeZign for Databases | Datanamic | SMBs and enterprises | Commercial | MS SQL Server, MySQL, Oracle, IBM DB2, Firebird, InterBase, Informix, MS Access, SQLite, PostgreSQL, Sybase, Paradox | All versions of Windows | Standalone | 1999 | | Enterprise Architect | Sparx Systems | SMBs and enterprises | Commercial | IBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux, Mac | Data modeling is supported as part of a complete modeling platform. | 2000 | | ER/Studio | Embarcadero | SMBs and enterprises | Commercial | Access, IBM DB2, Informix, Hitachi HiRDB, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL | All versions of Windows | Standalone | 1998 | | IBM InfoSphere Data Architect | IBM | Enterprises | Commercial | IBM DB2, Informix, Oracle, Sybase, MS SQL Server, MySQL, Teradata | Linux, Windows | Standalone | Unknown | | MicroOLAP Databaser Designer | MicroOLAP | SMBs | Commercial | MySQL, PostgreSQL | All versions of Windows | Standalone | 2003 | | ModelRight | ModelRight | Enterprises, SMBs, personal | Commercial | MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 | All versions of Windows | Standalone | 2005 | | MySQL Workbench | MySQL (An Oracle Company) | SMBs - personal | Commercial/GPL | MySQL | Linux, Windows, MAC OS | Standalone | 2006 | | Navicat Data Modeler | PremiumSoft | SMBs - personal | Commercial | MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite | Windows, Mac OS | Standalone | 2012 | | Online Data Modeler | JenaSoft | SMBs - personal | Commercial | MS SQL Server, MySQL, PostgreSQL, Oracle, SQLite, MS Access | Online | Standalone | 2011 | | Open ModelSphere | Grandite | SMBs - personal | Commercial and free edition available | MS SQL Server, MySQL | Online | Part of modeling environment with UML support | 2010 | | Oracle SQL Developer Data Modeler | Oracle | Enterprises | Free | Oracle, MS SQL Server, IBM DB2 | Cross-platform | Standalone | Unknown | | PowerDesigner | Sybase | SMBs and enterprises | Commercial | MS SQL Server, Oracle, PostgreSQL, MySQL, IBM DB2, Informix | All versions of Windows | Standalone | 1996 | | SQL Power Architect | SQLPower Software | SMBs | Commercial and free community edition | PostgreSQL, Oracle, MS SQL Server, MySQL, HSQLDB, IBM DB2, Derby Embedded | Windows, Mac OS, Unix/Generic | Standalone | 2004 | | Toad Data Modeler | Quest Software | SMBs and enterprises | Commercial (Free, limited, community edition available) | Access, IBM DB2, Informix, MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite | All versions of Windows | Standalone | 2005 (before this date known as CaseStudio) | | XCase | Resolution Software Ltd | SMBs and enterprises | Commercial | MS SQL Server, Oracle, PostgreSQL, MySQL, IBM DB2 | All versions of Windows | Standalone | 1996 | | Visible Analyst | Visible Systems | SMBs and enterprises | Commercial (Free, limited edition available) | Access, IBM DB2, Informix, ANSI, Oracle, ParadoxSQL, MS SQL Server, Sybase, DBASE, Sybase, XML, User Defined | All versions of Windows | Standalone, Multi-user (concurrent development, floating licenses), Citrix | Data modeling introduced in 1990. First version of Visible Analyst released in 1985. www.visible.com | | Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
|---|
Features|
| CA ERwin Data Modeler | Conceptual, logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Workgroup edition provides collaboration | | Database Visual Architect | Physical | Crows feet | Yes | Yes | Update database and/or update model | Additional product Teamwork Server for collaboration. | | dbConstructor | Physical | Crows feet | Yes | Yes | Update database | No | | DbSchema | Physical | Crows feet | Yes | Yes | Compare to database and generate alter database script (update existing model not supported). | No | | DbWrench Database Design | Physical | Crows feet | Yes | Yes | Update database and/or update model | No | | DeZign for Databases | Logical, physical | IDEF1X, IE (Crows feet) | Yes | Yes | Update database and/or update model | Not directly. Merge functionality available. | | 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 or DBMS Repositoty (or transfer via XMI, CVS/TFS or Difference Merge) | | ER/Studio | Conceptual, logical, physical, ETL | IDEF1X, IE (Crows feet) | Yes | Yes | Update database and/or update model | ER/Studio Repository and Portal for collaboration | | IBM InfoSphere Data Architect | Conceptual, logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes | | MicroOLAP Databaser Designer | Physical | Crows feet | Yes | Yes | Update database with alter scripts | No | | MySQL Workbench | Physical | IE (Crows feet) | Yes | Yes | Update database and/or update model | No | | Navicat Data Modeler | Conceptual, physical | IE (Crows feet) | Yes | Yes | Update database and/or update model | No | | Online Data Modeler | Logical, physical | IDEF1X (incomplete) | Yes | Yes | Update database (update model unknown) | Unknown | | Open ModelSphere | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | No | | Oracle SQL Developer Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes | | PowerDesigner | Conceptual, logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes | | SQL Power Architect | Physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Compare models and generate alter script | No | | Toad Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes | | Visible Analyst | Conceptual, logical, physical | All standard ERD modeling supported, and much more | Yes | Yes | Update database and/or update model | Only modeling tool designed from the ground up as a concurrent development tool. Also can do process modeling, object modeling, state modeling, BPMN modeling, custom modeling, strategic planning, all in one central repository. www.visible.com | | XCase | Physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Not directly. Merge functionality available. | | Tool | Supported data models (conceptual, logical, physical) | Supported notations | Forward engineering | Reverse engineering | Model/database comparison and synchronization | Teamwork/repository |
|---|
See alsoCA ERwin has stopped supporting the MS ACCESS database from version 8.0 |
|
