Comparison of data modeling tools

! Tool

! Creator

! Target Business Size

! License

! Supported Database Platforms

! Supported OSs

! Standalone or bundled into a larger toolkit

! Launch Date

| Change Vision

| Enterprises

| Proprietary

| MySQL, Oracle,

| Windows, macOS, Linux

| Standalone

| 2006

| 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

| 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

| 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

| 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

| 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

| No Magic

| Enterprises, SMBs, personal

| Proprietary

| MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2

| Windows, Linux, macOS

| Standalone

| 1995

| Microsoft

| {{unk}}

| Proprietary

| MS SQL Server

| Windows

| Standalone

| 2005

| ModelRight

| Enterprises, SMBs, personal

| Proprietary

| Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM Db2

| Windows

| Standalone

| 2005

| MySQL (An Oracle Company)

| SMBs - personal

| Proprietary or GPL

| MySQL

| Linux, Windows, macOS

| Standalone

| 2006

| PremiumSoft

| SMBs and enterprises

| Proprietary

| MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite

| Windows, macOS, Linux

| Standalone

| 2012

| Terry Halpin

| SMBs and enterprises

| Open source (CPL)

| MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2

| Windows

| Visual Studio Extension

| 2005

| 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

| Enterprises

| Proprietary

| Oracle, MS SQL Server, IBM Db2

| Cross-platform

| Standalone

| 2009

| 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

| Dusan Rodina

| Enterprises, SMBs, personal

| Proprietary

| MS SQL Server, MySQL

| Windows

| Standalone

| 2009

| Webyog, Inc.

| Enterprises, SMBs, personal

| Proprietary

| MySQL, MariaDB

| Windows and Linux (using Wine)

| Standalone

| 2001

| 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

! Tool

! Supported data models (conceptual, logical, physical)

! Supported notations

! Forward engineering

! Reverse engineering

! Model/database comparison and synchronization

! Teamwork/repository

| Conceptual, logical, physical

| IE (Crow’s foot)

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{no}}

| 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).

| 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.

| 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).

| Physical

| IDEF1X, IE (Crow’s feet), UML, and more

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{no}}

| Conceptual, Logical & Physical

| IE (Crow’s foot)

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{no}}

| Conceptual (ORM), Logical, Physical

| ORM, Relational(Crow’s foot option), Barker

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{no}}

| Conceptual, Logical, physical

| IDEF1X, IE (Crow’s foot), and more

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{no}}

| Logical, physical

| Barker, IE (Crow’s foot), and Bachman

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{yes}}

| Conceptual, logical, physical

| IDEF1X, IE (Crow’s foot), and more

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{yes}}

| Conceptual, logical, physical

| IDEF1X, IE (Crow’s foot), UML and more

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{yes}}

| Logical, physical

| IDEF1X, IE (Crow’s foot), and more

| {{yes}}

| {{yes}}

| Update database and/or update model

| {{yes}}