Database Answers Logo Lady Gabriella Windsor, a Model (Click for Wikipedia entry)
Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials Site Map
Data Modelling Tools   
Here's a short list of our Favourite Data Modelling Tools and here is an excellent discussion about Modelling Tools on LinkedIn, which makes PowerDesigner the most popular product.

Wikipedia has published a Comparison of Data Modelling Tools which is worth a look - and thanks to Erick Calder for telling us about it.

There's a short note about about Data Modeling and Database design at the bottom of the page.

if you have any specific recommendations or comments, please Email me

PRODUCT
VENDOR
PRICE
COMMENTS
AquaData Studio ER Modeler AquaFold $400 A Free 14-day evaluation copy can be downloaded.
The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price.
"Discounted licences are available for qualified Academic users and Free licenses are available for qualified Open Source Software (OSS) Developers."
Altova Database Spy Altova $499 or $999 One of a broad range of Tools. Thanks to Graham Lattin for telling me about the change in the link.
Archimate OMG Free Trial available Archmimate is described as an Enterprise Architecture Modelling Tool, which would be great ;-). Unfortunately, the download is for documentation and not for the product !!! It looks like Archimate is a specification for which a number of Vendors have developed Modelling Tools. Here's Wikipedia's entry for Archimate.
Argo UML Tigris Free - Open Source For Modelling UML Diagrams - but not for the faint-hearted.
Astah (was Jude) Change Vision A Total System Design tool supporting UML, ERD,DFD, Flowchart, Mind Map, CRUD and Requirement diagrams)
A Free Trial is available.
A Free Community version is available, and they publish a lot of very favourable User Comments in their Community Forum. Follow them on Twitter
Azzurri Clay Azzuri (Japan) Free From Japan -Open Source Plug-In for Eclipe - Reverse Engineering and generates SQL.
Pro version costs 35,000 Japanese Yen (about $150) !!
Borland Together Borland No prices on the Website Described as "Visual Modeling for Software Architecture Design".
The Website offers information on Model-Driven Development.
CA Gen Computer Associates No prices on the Website Provides Model-Driven support for Agile Development. Has a UK Partner in Response Systems.
Case Studio 2 Acquired by Toad (see below under Toad Data Modeler) CharonWare FreeDownload Trial, then $175(Lite) or $369(Full) Looks impressive - supports an unusally wide range of Databases, including Firebird, MaxDB,Postgres - if you try it, please me have your comments.
Here's a "5-Star" Review from Dan Horn.
CASEWise CASEWise   Aimed at Business Process Modelling, but has links to DataArchitect.
ConceptDraw CS Odessa $179 (50% off) For ERD, UML, ORM, FlowCharts, etc. - Free Download Trial is available. I like the appearance of the diagrams this Product produces and this is an important consideration for me.
DataArchitect Sybase $2,000 If you are buying for the company, buy this one.
DataArchitect is part of Power Designer, which is described below.
DataArchitect TheKompany $39.99 Highly recommended by Andy Brown and an unbeatable price. Comments and experiences please.
Database Design Tool (DDT) Open Source   THANKS VERY MUCH to Josh Bosh, Milwaukee's most beloved Web specialist, for providing this link.
Database Design Studio Chilli Source $39 - $200 Comes in two versions - Lite at $79 ($39 Educational), which supports ERD Modeling and Forward Engineering and Professional at $299, which adds support for Reverse Engineering.
Database Designer MicroOlap $125 Specially for PostgreSQL and includes Reverse Engineering.They give it away Free if you mention it in your Blog.
DB Constructor Robert Schambach Free/$150 Here's a glowing reference at the FreeDownloadCenter Web Site.
DBDesigner 4 FabForce.net Free (Donations welcome) Open Source and highly recommended if you work with MySQL.
DBDesigner-Fork SourceForce.net Free A Fork of DBDesigner 4 (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.
DB Diagram Designer PrimeLogics Offers a Free evaluation download or $130 to buy. Looks very interesting - modeller plus data editor using ODBC connections. If you try it please let me know your opinion.
DB Main Rever Free for the Data Modeller, with add-ons available at typical prices of 1,000 Euros or US Dollars. Produced in Belgium, with documentation in English and French.
Offers a very impressive range of features, including :-
"... meta-modeling components that allow its users to develop new functions and extend its repository"
DBSchema Wise Coders, Germany Free Trial and then only $127 to buy. Supports all RDBMSs Databases using JDBC connections.
DBVisualiser Minq Free evaluation and then only $129 to buy,($103 for Education). Helpful for DBA work, like performance monitoring.
A Finalist for 'Best Data Access Tool 2005' in the Java Developers Journal Readers Choice Award and included in the BEA WebLogic Workshop.
Free version available with "the basic level of features that most users require".
DB Wrench Nizana $149 "Forward and Reverse Engineer, Affordable, Easy to Use."
Dezign Datanamic Offers a Free download or starts at $129 to buy. A recent upgrade offers significantly improved features.
Supports Forward and Reverse Engineering for about 20 different Databases.
If you are buying for yourself, buy this one
Dia Hosted by Sourceforge Free - Contributions suggested "Dia is software for drawing diagrams similar to Visio", such as UML. It's Open Source with many authors. Install it from here
Druid From SourceForge   Generates SQL Scripts and Java classes.
Thanks again to Josh Bosh.
Enterprise Architect Sparx Systems Free Download - then $135 to $239 From Australia - supports UML and very affordable, and has an entry in Wikipedia.
Entity Framework Add-on IdeaBlade $995+/developer "Makes Microsoft's Entity Framework easier to use"
ER Creator Model Creator About $100 Includes a Tutorial and a Trial version.
ER Diagrammer KeepTool $240 Free download is available and a User Forum is supported.
ERD Concepts 5 ERD Concepts $179 Euros (single-user) A Free download is available.
ER/Studio Embarcadero $1,500 up to $7,500 (!!!) In response to a helpful comment from Daryl Purcell I have added a link to US prices and UK prices.
ERwin CA Technologies There is a Free Community Edition, and a price list is in the Online Store. One of the Market Leaders - an enterprise solution with a particularly powerful Model Manager for large teams, especially operating from different locations.
Experience Electronic Exerience Free Trial then 90 Euros (about $50)  
FastTracks Code Patterns   Works only with UML and Ruby on Rails
GenMyModel GenMyModel Free !!! A beautiful Web Site "GenMyModel is an innovative online UML tool for software architects and developers.
It allows to create UML-compliant diagrams, export and generate code from your web browser.
Gliffy Gliffy Free option available The ONLY Online Modelling Tool I have found - unfortunately it only does UML at the moment.
Google WWW SQL Designer Ondrej Zara (Czechoslovakia) Free Open Source Good-looking sample Data Model.
Happy Fish Polderij NV. (in Dutch) $89 Renamed ERD Concepts.
HiberObjects Object Generation Free An open source UML Tool for creating Class diagrams that supports Reverse Engineering
IBM InfoSphere Data Architect IBM $5,570 !!! Provides reverse and forward engineering facilities for a range of databases, also ERD and UML Modelling.
ImportER MySQL Datanamic Excellent value at $55 Reverse Engineering for MySQL
KeepTool KeepTool $300 / 300 Euros Can Reverse Engineer Oracle Databases to create Data Models - Comments and experiences welcome.
MagicDraw No Magic   Award-winning UML Modeller and very popular with Java enthusiasts.
Mega Database Builder Mega   Looks like a great product with a wide range of features BUT there is no price information on their Site and they offer an evaluation version but you can't download it - instead they will contact you to discuss your requirements !!!
ModelRight ModelRight Free Trial, then $495 for DB2, Oracle and SQL Server, $295 for MySQL and PostgreSQL, and $195 for Access. An enthusiastic user is David McKelvey from Richardson,Texas, who says “As a pure Database Physical Modeling Tool, nothing else comes close."
MySQL Workbench MySQL Free with MySQL (also Free) Looks good and offers Reverse Engineering.
Navicat Data Modeler Navicat Starts at $79 for a non-commercial version Looks good with a comprehensive range of versions.
Objecteering Objecteering.com Free download trial Looks good with a comprehensive range of features, including UML support.
OmniGraffle Omni Group Free download trial For Mac only
Open ModelSphere Model Sphere Free Open Source and UML
Oracle Designer Oracle $200 Available from the Oracle Technology Network (Free to join).
Oracle says "Oracle Designer is our model-driven development tool based on the principles of Information Engineering."
Oracle J-Developer Oracle Free Download UML diagramming is part of J-Developer.
Also available from the Oracle Technology Network.
Oracle says "Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services."
Oracle SQL Developer Data Modeler Oracle Free Many thanks to Tuomas Kassila in Finland for telling us about this.
Oracle says :-
SQL Developer Data Modeler is a Free data modeling and design tool, for ERD and Multi-dimensional modeling, with forward and reverse engineering. It imports from and exports to a variety of sources and targets.
In a discussion on LInkdedIn, Kent Graziano said :-
Oracle SQL Developer Data Modeler has a Logical Modeling diagrammer that gives you the option of three different notations and the ability to turn various display options on and off.
You also have an option to use box-in-box for sub types (if you like that style), so it is very usable.
ORM Designer Inventic Offers a Free trial then costs $140 or 99 Euros. Thanks to Ludek Vodicka in Czechoslovakia.
PG Designer From John.   Open Source - for PostgreSQL.
Thanks again to Josh Bosh.
Platinum Repository Computer Associates   This is a Repository, rather than a Modelling Tool, with a 'Where-used' facility, and it lets you add entity types,such as Business Function, Business Role and Script.
Poseidon GentleWare   Comes highly recommended, good for UML, and has an open-source Free version.
Power*Architect SQL Power Free (Open Source)  
Power Designer Sybase $2,000 If you are buying for the company, consider this one.
ProVision MetaStorm Free Trial, but prices not avalable on the Website. Includes Frameworks, such as Zachman, and also Reference Models, such as Customers, Finance and Telecomms, and an interesting 3-D Architecture
RevJ SourceForge Free Open Source This Object Source product generates ERD Data Models from SQL. It is a way of understanding complex SQL that you might have 'inherited' from somebody else.
Please Email me if you have any comments on RevJ.
Rhalotel DB Diagram Mgr
Rhalotel
98 Euros/$100  
RM Bench
Byte Refinery
Free Trial then $120 "Graphical Modelling of Relational Databases in Eclipse".
Safyr
Computer Associates 
(acquired from Silwood)
Used to be about $14,000 but check with CA Safyr is more than a Modelling Tool. It sits between an ERP like SAP and a Modelling Tool like ERWin.
It provides a very useful and powerful Metadata manipulation package which allows you to extract metadata from ERPs such as SAP, J.D. Edwards and PeopleSoft, which can then be 'reverse engineered' into a Modelling Tool like ERwin, to see the Data Model.
Schema Spy (command line) or Schema Spy GUI (Point and click)
Schema Spy
Free May not exactly be a Data Modelling Tool.
On the Web Site, it is described as a "Graphical Database Schema Metadata Browser" and a tool to investigate the validity of a Data Model.

The Web Site also says :-
"Do you hate starting on a new project and having to try to figure out someone else's idea of a database?
Or are you in QA and the developers expect you to understand all the relationships in their schema?
If so then this tool's for you.

A Contributor to the LinekdIn Data Architecture Group said :-
"Schemaspy would be nice for Reverse Engineering as it outputs in HTML and you can zip the file and send it around to people. "I have used to to view what is inside a schema, quickly.
It helps you to quickly generate the data model and visualize entities as per 'Degree of Separation' , too.
Very flexible, and quick, it is just a 'jar' file to which you pass your database credentials and it does the job.
SilverRun Data Modeller (now Open ModelSphere)
Grandite
$990  
SmartDraw SmartDraw $50 !!! Recommended - Promoted as a UML Drawing Tool with impressive support.
Sparx Enterprise Architect Sparx Systems Free Download - then $135 to $239 From Australia - supports UML and very affordable, and has an entry in Wikipedia.
SPSS Clemetine IBM   IBM recommends this for Data Mining.
SQL Developer Diagram Editor   Free Not to be confused with Oracle's SQL Developer.
Offers a range of attractive features and has some glowing references.
SQL Maestro SQL Maestro Group Freeware Please let me know if you have any experience with this product.
SQL Manager EMS Free Trial available  
Squirrel Squirrel Free Open Source
StarUML SourceForge Free "The Open Source UML/MDA Platform" (from Korea).
System Architect IBM $3,000-5,000 per seat. In an evaluation, I found this product very difficult to use, the diagrams were very ugly and it crashed too often for me to recommend it. Downloads available for Evaluation.
Toad Data Modeler Quest Free Download, then $479 Price is 30% off to CASE Studio 2 customers
From the makers of Toad, and based on CASE Studio 2 – Includes 24x7 support, runs on over 40 DBMSs, and you can create ER & Data Flow diagrams, reverse engineer and generate SQL Scripts.
TogetherSoft Solo Borland Downloadable Supports UML
Toolkit for Conceptual Modeling (TCM) University of Twente, Holland Free and Downloadable Very interesting combination of Tools, including UML.
Thanks to Tony Adams for suggesting a better link here.
Umbrello SourceForge Free Open Source UML Modeller
Visio Microsoft Trial CD available Many Versions- Standard($199),Technical($399),Professional($399) and Enterprise($999)
Visual Paradigm Visual Paradigm Free Community Edition, also Free trial. Produced by a Hong Kong-based company - supports ERDs and UML, imports Visio
Vertabelo Vertabelo Free trial and then $12 or $48/month - $99 or $399. "Design your database Online"
Visual Thought CERN (Godfathers of the Internet)   Give it a try for UML.
THANKS AGAIN to Josh Bosh, Milwaukee's most beloved Web specialist, for providing this link.
Win A&D Excel Software No price information on the Web Site Unusually offers products for MAC as well as Windows - UML Modelling as well as ERD.
xCase Resolution Software $800 (Download Trial available) "xCase is a complete database design and maintenance tool including archiving and model compare and merge across different DBMSs".

Lady Gabriella Windsor, a Model  (Click for Wikipedia entry)
Useful Links :-
CATEGORY ORGANISATION
COMMENTS
Discussion Group InfoAdvisors Data Model Group
Portal Data Management Centre Directory of Data Modelling Resources (Highly Recommended)
Portal DM Review Search for 'Data Models'
Portal Journal of Conceptual Modelling Worth Checking out


A short note about about Data Modelling and Database Design ...
Data modelling and database design are two very different activities.
 
For data modelling, the question you are asking is :
1) What does the world being modelled look like ?  
   In particular, you are looking for similarities between things. 
   Then you identify a 'super-type' of thing which may have sub-types. 
    For example, Corporate Customers and Personal Customers

   If, for example, supplier contacts are conceptually different things from customer contacts, 
  then the answer is that they should be modelled separately.  
  On the other hand, if they are merely sub-sets of the same thing, then treat them as the same thing.

2) For database design, you are answering a different question:-
   "How can I efficiently design a database that will support the functions of the proposed application or Web Site ?" 
   The key task here is to identify similarities between entities so that you can integrate them into the
   same table, usually with a 'Type' indicator.
   For example, a Customer table, which combines all attributes of both Corporate and Personal Customers.
   As a result, it is possible to spend a great deal of time breaking things out when creating a Data Model, and 
   then collapsing them back together when designing the corresponding database.
   
Dan Horne writes about Case ...

"I have found Case Studio to be an outstanding tool in its market niche. 
It supports a wide variety of databases, although I've only use it with Oracle, 
where I have found it to be excellent.

It's a bargain at $299, and with additional licenses costing only $89, it is well 
within the budget of most organizations that do not require an enterprise solution. 

I've been searching for a data modelling tool for some time, but most are not within 
my price range, and are generally aimed at larger companies. 

The competitive products I have found are marginally cheaper, but do not support the 
fundamental features I need such as the reverse engineering of existing databases.

The only weakness is the documentation, which is included as a help file.

Some topics such as exporting the diagrams to a graphic file are not covered, and there is 
no detail on writing templates to enhance and extend the system. 

Likewise, Data Flow Diagrams are barely touched on.

Nevertheless, I am very pleased with my purchase. 

Case Studio deserves to be much better known than it is.

Regards

Dan Horne"

© DatabaseAnswers.org 2013

Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials Site Map