Try our new research platform with insights from 80,000+ expert users

Ardoq vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Ardoq
Ranking in Enterprise Architecture Management
12th
Average Rating
7.6
Reviews Sentiment
5.7
Number of Reviews
2
Ranking in other categories
No ranking in other categories
erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Business Process Design (9th)
 

Mindshare comparison

As of March 2025, in the Enterprise Architecture Management category, the mindshare of Ardoq is 3.4%, up from 3.1% compared to the previous year. The mindshare of erwin Data Modeler by Quest is 11.0%, up from 10.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

Anthony Houghton - PeerSpot reviewer
Provides stable performance and scalability but not intuitive for data modeling
Overall, I would rate it around six out of ten. The training environment wasn't very intuitive, but maybe with more use, it will get better. We need to learn to navigate it. So, there is a potential learning curve in this tool. I use it once in a blue moon, and not very frequently because I have not found it very intuitive.
JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is a stable solution."
"Snapshots are the most valuable feature."
"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."
"The data lineage feature is very valuable."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"The fitting model is very intuitive."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
 

Cons

"Scalability as a standalone system is good, given the information that has been described inside Ardoq. But not the scalability as a third-party system or with integration with other systems. Because in this direction, the scalability is about zero for Ardoq."
"The training environment wasn't very intuitive, but maybe with more use, it will get better."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"I would like the solution to be less rigid in terms of its theory."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"It does not have a cloud application."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
 

Pricing and Cost Advice

"We pay for extended support."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
"erwin Data Modeler by Quest is an expensive solution."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
841,004 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
11%
Government
8%
Insurance Company
7%
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Any experience with Strategic Project Portfolio Management Solutions?
Hi @Cheryl Joseph ​Looking at the crossover between Project and Portfolio management with EA, then Planview could be a good choice. If looking at Portfolio Management from an EA perspective then Le...
What needs improvement with Ardoq?
It doesn't seem good for data modeling. So, I would like to see some features related to that in future releases.
What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
 

Also Known As

No data available
erwin DM
 

Overview

 

Sample Customers

Schibsted, Government of Malmo, Torvald
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Find out what your peers are saying about Ardoq vs. erwin Data Modeler by Quest and other solutions. Updated: March 2025.
841,004 professionals have used our research since 2012.