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

Ataccama ONE Platform vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive Summary

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

Ataccama ONE Platform
Average Rating
8.0
Reviews Sentiment
7.1
Number of Reviews
10
Ranking in other categories
Data Quality (4th), Data Scrubbing Software (2nd), Master Data Management (MDM) Software (4th), Data Governance (11th)
erwin Data Modeler
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (4th), Business Process Design (10th)
 

Featured Reviews

JohnZacharkan - PeerSpot reviewer
Enhanced data quality with machine learning support in diverse environments
We used Ataccama ONE to read data from the mainframe for a data quality perspective. There's a significant lack in that area with tools being able to interface with mainframe. MetLife has a diverse environment, including DB2, Oracle, SQL Server, legacy, and vSAN files. Being able to work in these various environments and put them to a single data quality tool was very appealing. Additionally, Ataccama supported AI and machine learning, which was one of the features I liked. Furthermore, we were able to interface bidirectionally with Collibra for data governance, catching data quality issues before propagating through the system.
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

"The ease of use of the user console is valuable."
"The data profile itself is excellent. You can understand the quality of the data in layman's terms."
"The desktop version of the solution was particularly valuable to me, primarily for creating components. We opted for the data quality aspect to assess the quality of our data warehouse. The functionalities available allowed us to not only check data quality but also serve as an ETL tool. This versatility enabled data transformation and storage in various formats, including files on platforms like SharePoint or local online directories. The flexibility of the tool catered to the specific needs of those building components, contributing to our desired outcomes."
"The product’s important feature is data profiling and quality check."
"The drag-and-drop feature is incredibly flexible and straightforward."
"Customer service was excellent, and I would give it a ten out of ten."
"The notable aspect lies in the workflow structure, where building the workflow aligns significantly with data governance."
"It is also easy to deploy."
"It is a scalable solution...The technical support team is fine."
"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."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"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's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"The principal feature that I liked is that the solution has a very graphic interface."
 

Cons

"Speaking specifically about the version we use, version 12.3, I'm unsure if this has been addressed in subsequent versions. One improvement I'd like to see pertains to the language used in certain components, especially in data quality checks. The language complexity posed a challenge for beginners. Although we had on-site assistance from Ataccama, making it manageable for us, some individuals found it difficult to comprehend, necessitating additional support. The provision of a comprehensive guide for on-premise installation can also be enhanced. The lack of detailed information on the solution's workings and the overwhelming nature of notifications, with extensive content, were areas of concern. Streamlining the notification content in newer versions would significantly expedite issue resolution."
"Although DQA can fetch data from most of the commonly used data sources, it has limited modifiers to get data, meaning that the number of technologies from which the data can be acquired is limited. For example, DQA does not support fetching data from Twitter or Facebook. Many competitors have this feature."
"Data movement is a pain."
"I believe it would be beneficial if it could enhance its flexibility to connect with a wider range of downstream systems beyond just Excel and Postgres."
"There is a notable challenge in having to provide detailed filters before the site recognizes the search criteria."
"It is complicated to fetch 20-25 reports when we profile the data."
"The interfacing to tools such as Collibra was somewhat cumbersome and required more thought."
"They could focus more on marketing the product. The current marketing strategy is not working."
"I would like the solution to be more user-friendly to deploy."
"It does not have a cloud application."
"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"erwin is not as robust as a data warehousing project I've been on in the past."
"I still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"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."
 

Pricing and Cost Advice

"Our licensing model wasn't user-specific; instead, we paid fees for the engine and maintenance. As we didn't have a support contract, maintenance fees were likely nonexistent. Regarding the upgrade, we had an account for the initial two or three years, and considering the features provided by the solution, the pricing was reasonable."
"Despite not being extremely low-cost, the pricing appears reasonable, making it a profitable and viable choice for companies that prioritize data security and adhere to specific policies."
"There is no need to buy a license. You can just download it and use it for free."
"The product is reasonably priced."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"Though the solution is not cheap, it's worth the money."
"I don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
"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."
"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."
"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."
"The solution is expensive."
report
Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Ataccama ONE Platform?
The notable aspect lies in the workflow structure, where building the workflow aligns significantly with data governance.
What needs improvement with Ataccama ONE Platform?
The interfacing to tools such as Collibra was somewhat cumbersome and required more thought. While it was possible to configure these interfaces, they required some coding. It would be beneficial i...
What is your primary use case for Ataccama ONE Platform?
Some of the use cases for Ataccama ONE included data quality, identifying and mapping to Collibra, which was their data governance tool. It was critical for them to interface directly with that too...
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

Ataccama DQ Analyzer
erwin DM
 

Overview

 

Sample Customers

Société Générale, First Data, Raiffeisenbank International, T-Mobile, Avast, RSA, Toronto Public Library
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Find out what your peers are saying about Microsoft, Informatica, Collibra and others in Data Governance. Updated: July 2025.
865,384 professionals have used our research since 2012.