We performed a comparison between erwin Data Modeler by Quest and Visual Paradigm based on real PeerSpot user reviews.
Find out in this report how the two Business Process Design solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"The product allows us to reuse entities and attributes."
"The data lineage feature is very valuable."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"The solution is very user-friendly. It's easy to just open it and start working."
"The pricing model is attractive."
"The initial setup is extremely straightforward."
"I like the structure. I can see the diagrams and everything I created."
"It is easy-to-use and it helps understand its data modeling structure through the intuitive user interface."
"The initial setup is straightforward."
"Using the Component Diagram, Visual Paradigm helps with design and control, reusing components."
"Some of the most valuable features of this process modeling tool are process simulation and process animation."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"There is a lack of local support in the China region."
"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."
"I would like the solution to be less rigid in terms of its theory."
"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."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."
"The solution's technical support can be improved and accessible for our company location since Visual Paradigm follows a remote support model with some challenges."
"Visual Paradigm is heavier and has more complexity than one of its competitors, e.g. Lucidchart. It could have been better if it was more simplified."
"The solution is not user-friendly. It uses a lot of memory and CPU. You have to have a good computer to use it."
"More flexibility when choosing the type of diagram would be nice."
"It's still early for me to comment since I've only been using it for two months, but the responsiveness when diagramming needs to be improved."
"Visual Paradigm's initial deployment was difficult since we did it for the first time. It is challenging to learn to use the product."
"For me, what needs improvement in Visual Paradigm is the limited features included in the $99 license, which is the cheapest option. If more features could be included in the cheapest licensing package, Visual Paradigm would be better, especially for businesses that have a limited budget for buying software."
"There are some connectivity issues that crop up rarely when used with SQL Server."
erwin Data Modeler by Quest is ranked 9th in Business Process Design with 37 reviews while Visual Paradigm is ranked 7th in Business Process Design with 25 reviews. erwin Data Modeler by Quest is rated 8.6, while Visual Paradigm is rated 8.0. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of Visual Paradigm writes "Very flexible and easy to use with a good pricing model". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and No Magic MagicDraw, whereas Visual Paradigm is most compared with Sparx Systems Enterprise Architect, Visio, Lucidchart, Bizagi and Camunda. See our Visual Paradigm vs. erwin Data Modeler by Quest report.
See our list of best Business Process Design vendors.
We monitor all Business Process Design reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.