🧠 Second Brain
Search
Data Modeling Tools
Popular data modeling tools include Sqldbm, DBDiagrams, Enterprise Architect, and SAP PowerDesigner. These tools are widely used in the industry and offer powerful features such as data modeling, profiling, and visualization.
Open-source data modeling tools such as MySQL Workbench and OpenModelSphere are free and offer essential features for creating data models. They are helpful for small projects and provide an opportunity for data engineers to learn data modeling skills.
Choosing the right data modeling tool depends on the organization’s needs, budget, and project size. Large organizations may require expensive enterprise-level tools, while small businesses may opt for open-source tools. Selecting a tool that is easy to use, has the needed features, and is compatible with the organization’s database management system is essential.
Other tools are Ellie.ai, whose key features are Data Product Design, Data Modeling, Business Glossary, Collaboration, Reusability, and Open API.
dbt can be seen as a transformation modeling tool. Dagster can be used as a DAG modeling tool. And so forth. But you can also use ExaliDraw for Markdown-based drawing or draw.io (lots of templates for AWS, Azure, etc.) to draw architectures.
If you struggle to think in dbt tables and SQL is not the SQL is not the right language. One problem, SQL is a declarative language, which is a blessing and a curse. Especially if you do recurring queries, SQL gets nasty spaghetti coded, which again dbt helps with Jinja Template, but as it’s not a language, without much in-built support. Reconfigured (not free) was built for people without years of experience, focusing heavily on business logic.
# Tools
- DBDiagram: Open-source and collaborative.
- SqlDBM: Advanced Enterprise Modeling tool.
- DrawDB: Free, simple, and intuitive online database design tool and SQL generator.
- Enterprise Architect
- DbSchema
- dbVisualizer
- DeZign for Databases
- Erwin Data Modeler
- IDERA ER/Studio
- Lucidchart
- MagicDraw
- MySQL Workbench
- Navicat Data Modeler
- Oracle SQL Developer Data Modeler
- SAP PowerDesigner
- Toad Data Modeler
- Vertabelo Data Modeler
- pgModeler
# Open-Data Modeling Formats
DBML, integrated with DBDiagram.
Read more on the three-part series at Data Modeling - The Unsung Hero of Data Engineering: Architecture Pattern, Tools and the Future (Part 3) | ssp.sh.
Origin: Data Modeling
References: Data Modeling Frameworks
Created 2023-03-06