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 Ingres
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.
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: | - |
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: |
|
GenMyModel
With GenMyModel’s standard data modeling notation, data architects not only keep
glossaries and data models under control, but they can design and reverse engineer data
models and link them to other IT and business models, such as UML, Archimate and BPMN.
| Desktop/Cloud: | Cloud |
|---|---|
| Commercial: | Commercial |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Mac OS,Windows |
| Forward engineering: |
|
| Reverse enginering: |
|
| Synchronization: | - |
ModelSphere
ModelSphere is an exciting and unique modeling tool that combines many features, such as business process modeling, data modeling and UML modeling, and provides a flexible model management environment. It provides complete data modeling features covering conceptual, logical and physical modeling.
| Desktop/Cloud: | Desktop |
|---|---|
| Commercial: | Free |
| Free edition: |
|
| ER Diagram: |
|
| Runs on: (for desktop): | Linux,Windows |
| 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: