SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Data modeling tools for SAP ASE / Sybase
List of data modeling and database design tools.
Data modeling is the process of creating and analyzing data models for resources stored in a database. The Data Model is an abstract model that standardizes the data description, data semantic, and consistency constraints of data. Its main purpose is to represent the types of data within a system, the relationships between objects, and its attributes. The data model helps to understand what data is needed and how data should be organized. It is like a blueprint for an architect to better understand what is being created.
erwin Data Modeler
erwin Data Modeler (erwin DM) is a data modeling tool used to find, visualize, design, deploy, and standardize high-quality enterprise data assets. Discover and document any data from anywhere for consistency, clarity, and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence, and analytics initiatives.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: |
|
ER/Studio
ER/Studio provides robust logical and physical modeling and determines all data sources along with managing the transformation of data between the staging area and data warehouse. It helps to build out an enterprise data model and represent business concepts with full documentation of attributes, definitions, relationships, etc.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
MagicDraw
MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. Cameo Data Modeler plugin for MagicDraw provides data-related modeling features. MagicDraw provides intuitive controls within a very well designed GUI which allows users to model without having to spend time learning about the controls.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
IBM InfoSphere Data Architect
IBM InfoSphere Data Architect is a data design solution that enables you to discover, model, relate, standardize and integrate diverse and distributed data assets throughout the enterprise. It enables information designers to create both logical and physical data model diagrams, which can be used to describe a variety of applications and systems.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
PowerDesigner
PowerDesigner DataArchitect is the industry-leading data modeling tool. It offers a model-driven approach to empower and align business and IT. PowerDesigner enables enterprises to more easily visualize, analyze, and manipulate metadata for effective enterprise information architecture.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
WinA&D
WinA&D is a comprehensive tool for system analysis, requirements management, structured analysis and design, object-oriented modeling with UML and data modeling of information systems. With WinA&D, dynamic systems can be modeled, parameterized, simulated and charted. The tool provides requirements specification and traceability, design verification reports and text import/export features.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Mac OS,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
Gleek.io
Gleek.io diagram maker is freemium text-to-diagram tool for developers and software architects. It is a cloud tool for model driven software development, and you can run in any browser. Gleek.io is designed to be used during software planning meetings and live collaboration, so it is vital that diagrams can be created quickly.
| Desktop/Cloud: | Cloud |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | - |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: |
|
The wider the scope of data works in an organization, the more advanced data modeling tool is needed. The functionality spectrum of these tools can be very broad. However, the core features of these tools include: