{{announcement.body}}
{{announcement.title}}

Data Modeling Tools Detailed Comparison

DZone 's Guide to

Data Modeling Tools Detailed Comparison

Detailed comparison of the most notable data modeling tools in the market.

· Database Zone ·
Free Resource

A data modeling tool or a database modeling tool is an application that helps data modelers to create and design databases structureThus, data modeling tools make the Data modeling process easier and provide many features that help data modelers to understand their data. 

Actuallythere are many different data modeling tools available for different database platforms. This multitude of tools available makes it very difficult to choose a tool that suits the user's needs.  

In this article, I aim to provide a detailed comparison of the most notable data modeling tools in the market. The tools will be compared according to the core features they have. 

Some features do not appear on the comparison table because they are available in almost all tools.  

will compare these tools: 

DbSchemaDeZign for Databases, ERBuilderER/StudioERWinNavicat Data Modeler, and finallToad Data Modeler

have tried to focus on the tools that do only data modeling, excluded the tools that do more than data modeling. have selected only the most well-known multi-DBMS tools on the market.

Detailed Comparison of Data Modeling Tools 

(Note: Scroll to the left and right to see all the product compared)

Features\ Tools
DbSchema
         General
Supported  
Database  
Platforms  

Via JDBC: Access,       Informix,    Interbase,      Sybase,   MS SQL Server, Oracle, MySQL,   PostgreSQL, SQLite,  Firebird, Azure SQL Database, Amazon Redshift, MariaDB, and more


Access, 
Informix, Interbase,  
Sybase,
IBM DB2, 
MS SQL Server, AzureSQL, 
MySQL,
Oracle ,
PostgreSQL,
SQLite,  
Paradox ,
FoxPro , Pervasive, PSQL  

MS SQL Server, Oracle, MySQL, PostgreSQL, SQLite,  Firebird, Azure SQL Database, Amazon Redshift, Amazon RDS, MariaDB 

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
Access
IBM DB2 ,
Informix ,
MySQL ,
MS SQL Server
Netezza ,
Oracle
PostgreSQL ,
Sybase , and  others
via ODBC/ANSI SQL  
MySQL,
MS SQL Server,
PostgreSQL, Oracle , SQLite
Access, 
IBM DB2, Informix, MySQL,
MariaDB , PostgreSQL, MS SQL Server, SQLite, Oracle  
Supported  
Data Models
Physical
Logical and     Physical  
Physical  
Conceptual
Logical
and Physical  
Conceptual
Logical
and Physical  
Conceptual
Logical
and Physical  
Logical and  Physical  
Supported  
Notations
IDEF1X, 
IE(Crow's feet), IE with Arrows, Barker 
IDEF1X, IE (Crow's  feet )  
IDEF1X, IE (Crow's  feet ), Codasyl and Relational notations 
IDEF1X, IE (Crow's  feet )  

IDEF1X, IE (Crow's  feet )  


IDEF1X, IE (Crow's  feet )  

IDEF1X, IE (Crow's feet),
and more
Reverse/Forward Engineering  
Generat e
DDL  Script   
✓ 

Generate database from 
a data model 
- - -
Secure connection
to the Database
SSH - SSL SSH/SSL SSH/SSL SSH/HTTP
/SSL
SSL/SSH 
Import from
local and remote databases
Model Validation 
Model validation Check - -
Validate a model using a database sandbox - -
(Virtual test
data
& built-in
query tool)
- - -
Reporting
Generate Model Documentation HTML (navigable), PDF  HTML (navigable), PDF, MS Word HTML
(navigable)
XML, HTML, RTF HTML, Xls, Doc PDF, HTML, Excel HTML, RTF, PDF
Print diagram ✓  ✓  ✓ 
Advanced tools  
Comparison Model/Model

Model/Model

Model/Model

Model/Model

Model/Model 

Model/
Database

Model/Model

Model/Database Model/Database Model/Database Model/Database Model/Database
- Model/ SQL Scripts Database/Database Model/ SQL scripts   Model/ SQL scripts
- - - - Database/ Database


Model to Database

Model to   Model
Database
to Model
Model to Database Model to   Model
Database to Model
Model to Model
 Synchronization
Database to Model
Model to Database

Database to Model Model to Database
- Database to Model - Database to Model
Model to SQL file  Model to SQL file
Database to Model
Populate a Database with Test Data

(Directly on the database)


-

(Directly on the database and SQL Script) 


- - -

(By SQL Script)
Change Database Platform
Multi-Projects Management
(Multi-Instance)
✓ 
(Multi-Instance)
Version Management -
Find and Replace Find Only Find Only Find Only
Collaboration
/Teamwork 
GIT, Mercurial, SVN, CVS, etc. Repository database - ER/Studio 
Repository 
Workgroup Edition Navicat Cloud GIT, 
SVN  
Last release

8.2.12 

Jul 2020

12.0.3 

May 2020

3.4.1 

Apr 2020

18.3.0 

May 2020

9.95 

June 2020

3.0.9 

June 2020

7.2 

May 2020 

Major updates every: 2 or 3 Months 6 Months 2 or 3 Months 4 to 6 months 6 months 3 or 4 years 5 Months
Price for 1 user/perpetual
license
From $63
to $197
From $299
to $959
From $99
to $699
Starts at
$4,000
Starts at
$3,143
From $249
to $459
$568

Conclusion

Some tools may support many databases platforms but crash frequently such as DBSchema and Toad. Other tools have small missing features that slowed you down in your data modeling process. For example, DeZign doesn’t have a Redo action! Navicat and DBSchema do not have enough details on the description of the fields. ERBuilder does not support identifying and non-identifying relationship, you have to specify it manually by setting a foreign key field to a primary key! 

Tools such as ERWin and ER/Studio are very complete data modeling solution but they can be very complex and difficult to use, also their prices are very high compared to the other tools.  

As a result of this comparison, we come to the conclusion that testing each product seems to be the best way to find the best tool for your needs, don't just rely only on the features supported by these data modeling tools.  

References

1- https://dbschema.com/features.html

2- https://www.datanamic.com/dezign/

3- https://soft-builder.com/erbuilder-data-modeler/ 

4- https://www.idera.com/er-studio-enterprise-data-modeling-and-architecture-tools/overview 

5- https://erwin.com/products/erwin-data-modeler/ 

6- https://www.navicat.com/en/products/navicat-data-modeler 

7- https://www.quest.com/products/toad-data-modeler/ 

Topics:
data model, data modeling, data modeling software, data modeling tools, database design, databases

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}