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."It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"The fitting model is very intuitive."
"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 visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"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."
"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 is easy-to-use and it helps understand its data modeling structure through the intuitive user interface."
"The pricing model is attractive."
"It is a scalable solution since it can be used at an individual level as well as for enterprise-sized businesses."
"Some of the most valuable features of this process modeling tool are process simulation and process animation."
"What I found most valuable in Visual Paradigm is diagramming. I had a great user experience as diagramming in the tool is easy and convenient, even for complex diagrams or models. Visual Paradigm is the perfect tool for me, and I prefer it over Sparx Systems Enterprise Architect. Visual Paradigm is better for collaboration if you consider, for example, versioning, so this is another valuable tool feature that's simple and embedded in the solution. In Visual Paradigm, it's also easy to set up the project with team members and collaborate, and it's also a pro of the tool."
"What I like best about Visual Paradigm is its simple GUI, especially since I'm a new user. In my two years of experience with this tool, I didn't find it complex because I was able to learn how to use it via YouTube videos. Visual Paradigm is enough for me. I also find the bridging feature in the tool valuable."
"The most valuable feature of the Visual Paradigm that I use is process modeling. Additionally, the solution has a complete set of features."
"It is a scalable solution...The initial setup was straightforward."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"The erwin Data Modeler is quite complex to use."
"The interface must be improved."
"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."
"Visual Paradigm can improve by having better process mining tools and model integration."
"There are some connectivity issues that crop up rarely when used with SQL Server."
"The solution is not user-friendly. It uses a lot of memory and CPU. You have to have a good computer to use it."
"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."
"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."
"There is room for improvement in the licensing model. I would suggest implementing country-specific pricing, as many other products in India do. This would make Visual Paradigm more affordable and accessible."
"I was looking to generate code from the diagrams, but it was not totally clear how to do it."
"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."
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, Lucidchart, Visio 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.