We performed a comparison between erwin Data Modeler by Quest and Sparx Prolaborate based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"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 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."
"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 is a scalable solution...The technical support team is fine."
"The product lets us import different types of models from various databases."
"It allows us to give a better description of our project than using the written word."
"What is really powerful in Sparx is the way in which you can model business processes. You can link business processes to organizational objectives. You can also take those business processes and link them to specific product features that you want to deliver."
"It is valuable to have diagrams available in real time."
"Its extensibility is most valuable."
"Sparx Prolaborate is user-friendly, easy to use, and has good documentation."
"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."
"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"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."
"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."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"I would like the solution to be less rigid in terms of its theory."
"In the next release, there should be more editable objects. We find Sparx Prolaborate very user-friendly, and having more features that are in the Enterprise Architect would be great, such as managing different versions of diagrams."
"The product is not very user-friendly."
"The solution could offer different sources for design."
"There should be more cloud capabilities."
"A lot of product teams use a lot of visualizations for mapping out the product roadmap, brainstorming, or understanding the vision of the product, but Sparx is not a great visualization tool. Sparx has to improve the way for visualizing processes, journeys, software designs, etc. It would really benefit the product management teams or even enterprise architects."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while Sparx Prolaborate is ranked 19th in Enterprise Architecture Management with 5 reviews. erwin Data Modeler by Quest is rated 8.6, while Sparx Prolaborate is rated 7.2. 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 Sparx Prolaborate writes "Diagram are available in real time but edits sometimes require a manual refresh". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and Sparx Systems Enterprise Architect, whereas Sparx Prolaborate is most compared with Sparx Systems Enterprise Architect, LeanIX and Sparx Pro Cloud Server. See our Sparx Prolaborate vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors.
We monitor all Enterprise Architecture Management 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.
