PowerDesigner is arguably the industry’s leading data modelling tool. Its features include: fully integrated models, different modelling techniques that cater to both an IT-centric audience and non IT-centric. It also supports a powerful metadata repository and various output formats. It has a nice and polished user interface with easily readable help documentation aiding the user to quickly solve ad hoc problems.
Tool Description as in http://www.datasciencecentral.com/profiles/blogs/top-6-data-modeling-tools
ER/Studio is data architecture and database design software developed by Embarcadero Technologies. ER/Studio is compatible with multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data assets. In 2015, Embarcaero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.
Tool Description as in https://en.wikipedia.org/wiki/ER/Studio
Image Credit: https://www.idera.com/er-studio-data-architect-software
Sparx Enterprise Architect
Enterprise Architect is a visual platform for designing and constructing software systems, for business process modeling, and for more generalized modeling purposes. Enterprise Architect is based on the latest UML® 2.5 specification (see www.omg.org). UML defines a visual language that is used to model a particular domain or system (either proposed or existing). Enterprise Architect is a progressive tool that covers all aspects of the development cycle, providing full traceability from the initial design phase through to deployment, maintenance, testing and change control.
Tool Description as in http://www.sparxsystems.com.au/enterprise-architect/index.html
Oracle SQL Developer Data Modeler
Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks. Using Oracle SQL Developer Data Modeler users can create, browse and edit, logical, relational, physical, multi-dimensional, and data type models. The Data Modeler provides forward and reverse engineering capabilities and supports collaborative development through integrated source code control. The Data Modeler can be used in both traditional and in Cloud environments.
Tool Description as in http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
Erwin Data Modeler (erwin) is a software tool for data modeling (data requirements analysis, database design, etc.) of custom developed information systems, including databases of transactional systems and data marts. erwin’s data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well. Logic Works stylised “erwin” from an abbreviation of “Entity Relationships” and Microsoft’s “Windows”.
Tool Description as in https://en.wikipedia.org/wiki/Erwin_Data_Modeler
IBM – InfoSphere Data Architect
IBM InfoSphere Data Architect is a collaborative enterprise data modeling and design solution that can simplify and accelerate integration design for Business Intelligence, Master Data Management and Service-Oriented Architecture initiatives. Data Architect enables you to work with users at every step of the data design process, from project management to application design to data design. The tool helps to align processes, services, applications, and data architectures.
Tool Description as in https://www.ibm.com/in-en/marketplace/infosphere-data-architect
The Archi modelling tool is targeted toward all levels of Enterprise Architects and Modellers. It provides a low cost to entry solution to users who may be making their first steps in the ArchiMate modelling language, or who are looking for a free, cross-platform ArchiMate modelling tool for their company or institution and wish to engage with the language within a TOGAF or other Enterprise Architecture framework.
Tool Description as in https://www.archimatetool.com/
Image Credit: https://www.archimatetool.com/
BiZZdesign Enterprise Studio is the collaborative business design platform that offers powerful, integrated modeling across multiple disciplines. It provides all the capabilities needed to seamlessly plan, track and execute change in a single software platform.
Tool Description as in http://www.bizzdesign.com/enterprise-studio
Image Credit: http://iea.wikidot.com/bizzdesign-architect
Database Deployment Manager
Database Deployment Manager (DDM) is an open source desktop oriented multi-platform database design tool that allows database administrators and/or programmers to create database structures (using an object oriented methodology) and deploy them into an existing database.
Tool Description as in https://en.wikipedia.org/wiki/Database_Deployment_Manager
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
Tool Description as in https://www.mysql.com/products/workbench/
Image Credit: https://www.mysql.com/products/workbench/
Sparx Enterprise Architect