Best data modeling tool on Reddit

27 reviews from r/SQLServer, r/dataengineering, r/datascience and 2 more subreddits

27 reviews from
and
By Brand
/
By Product
#1

DBT

5.0
(4)
"Currently using dbt for data modeling."
·
"Nothing beats DBT."
·
"Dbt & Matillion for cloud ELT workloads"
·
"Dbt has a huge community and extensive integrations."
#2

Microsoft

5.0
(3)
"SQL Server Data Tools is a great feature of Visual Studio for database development."
·
"It is free and has excellent DDL triggers for source control."
·
"Best of breed for modeling complex data marts."
#3

Erwin

4.0
(3)
"Model manager gives you a central repository to store your data models, which is a great benefit for deploying a federated data modeling team."
·
"Erwin is free for projects with less than 25 entities."
·
"ERwin is probably your best choice for catering to multiple DBMSes, including Teradata."
#4

Oracle

4.5
(2)
"Oracle's free Data Modeler tool is quite nice."
·
"Oracle's SQL Developer Data Modeler isn't too bad. It's free and supports reverse and forward engineering MSSQL."
#5

Open ModelSphere

4.0
(2)
"It's free, and it works for most models."
·
"There is an open source tool that might work for you: [Open ModelSphere](http://modelsphere.org/open_modelsphere.html)."
#6

Dotadda

5.0
(1)
"Dotadda is great"
#7

Databricks

5.0
(1)
"Currently our company is using Delta live tables from Databricks which takes care of SCD 2 and Data quality issues. Works like a charm for data modelling."
#8

Dagster

5.0
(1)
"Currently using Dagster for data modeling."
#9

Lucidchart

5.0
(1)
"For simple stuff I like to use Lucidchart."
#10

Informatica

4.0
(1)
"Informatica is the behemoth for legacy stuff"
#11

Matillion

4.0
(1)
"Dbt & Matillion for cloud ELT workloads"
#12

Dataform

4.0
(1)
"Dataform has similar functionality and is a Google product (acquired)."
#13

Dell

4.0
(1)
"It's gotten more expensive but it's still pretty cheap in my opinion."
#14

IDERA

4.0
(1)
"IDERA's E/RStudio offers robust database design features."
#15

Visual Paradigm

4.0
(1)
"Visual Paradigm's versatility may benefit broader system design needs."
#16

Dezign

4.0
(1)
"Dezign was way cheaper than Erwin."
#17

SQLDBM

3.0
(1)
"SQLDBM is a nice tool but lacks the features of erwin or E/RStudio."
#18

Embarcadero

2.0
(1)
"ERwin totally sucks and always has. ER/Studio is vastly superior, even though it has bugs."

Discover your audience

GummySearch is an audience research toolkit for 130,000 unique communities on Reddit.

If you are looking for startup problems to solve, want to validate your idea or find your first customers online, GummySearch is for you.

Sign up for free, get community insights in minutes.

Tell me more
Get started
Audience Research