Comparison of data modeling tools

From Wikipedia, the free encyclopedia
Jump to: navigation, search

This 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[edit]

Tool Creator Target Business Size License Supported Database Platforms Supported OSs Standalone or bundled into a larger toolkit Launch Date
CA ERwin Data Modeler CA Technologies SMBs and enterprises Proprietary Access, IBM DB2, Informix, Ingres, MySQL, Oracle, Progress, MS SQL Server, Sybase, Teradata All versions of Windows Standalone 1992?
DeZign for Databases Datanamic SMBs and enterprises Proprietary MS SQL Server, MySQL, Oracle, IBM DB2, Firebird, InterBase, Informix, MS Access, SQLite, PostgreSQL, Sybase, Paradox All versions of Windows Standalone 1999
ER/Studio Embarcadero SMBs and enterprises Proprietary Access, IBM DB2, Informix, Hitachi HiRDB, Firebird, 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 Proprietary IBM DB2, Informix, Oracle, Sybase, MS SQL Server, MySQL, Teradata Linux, Windows Standalone Unknown
ModelRight ModelRight Enterprises, SMBs, personal Proprietary MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 All versions of Windows Standalone 2005
MySQL Workbench MySQL (An Oracle Company) SMBs - personal Proprietary or GPL MySQL Linux, Windows, MAC OS Standalone 2006
Navicat Data Modeler PremiumSoft SMBs - personal Proprietary MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite Windows, Mac OS, Linux Standalone 2012
Open ModelSphere Grandite Enterprises - SMBs - personal GNU GPL3 MS SQL Server, MySQL, PostgreSQL, Oracle, DB2 Windows, Mac OS, Linux Standalone with Data, UML, and process modeling 2008
Oracle SQL Developer Data Modeler Oracle Enterprises Proprietary Oracle, MS SQL Server, IBM DB2 Cross-platform Standalone Unknown
PowerDesigner Sybase SMBs and enterprises Proprietary MS SQL Server, Oracle, PostgreSQL, MySQL, IBM DB2, Informix All versions of Windows Standalone 1996
Sql Power Architect SQL Power Group SMBs and enterprises Proprietary (free demo available) "Any database" (incl. MySQL, Oracle, Progress, MS SQL Server, Sybase, "and more") Java (Any OS with a JRE 5.0 or above) Standalone 2007
Software Ideas Modeler Dusan Rodina Enterprises, SMBs, personal Proprietary MS SQL Server, MySQL Windows Standalone 2009
Toad Data Modeler Quest Software SMBs and enterprises Proprietary Access, IBM DB2, Informix, MySQL, Oracle, PostgreSQL, MS SQL Server, SQLite All versions of 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[edit]

Tool Supported data models (conceptual, logical, physical) Supported notations Forward engineering Reverse engineering Model/database comparison and synchronization Teamwork/repository
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
DeZign for Databases Logical, physical IDEF1X, IE (Crows feet) Yes Yes Update database and/or update model Not directly. Merge functionality available.
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
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
Open ModelSphere Conceptual, 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 Conceptual, logical, physical Unknown Yes Yes Update database and/or update model Yes
Toad Data Modeler Logical, physical IDEF1X, IE (Crows feet), and more Yes Yes Update database and/or update model Yes
Tool Supported data models (conceptual, logical, physical) Supported notations Forward engineering Reverse engineering Model/database comparison and synchronization Teamwork/repository

See also[edit]