We performed a comparison between IDERA ER/Studio and PTC Windchill based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"The tool is simple to use."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"Straightforward setup."
"I like how the product integrates with other technical solutions."
"We would always like to see Repository performance improve, checking in and checking out."
"The only thing I had an issue with was licensing, and the support was very good."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
"When building the relationships there should be a little more flexibility."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"Some parts of the system are exclusive, so we can't work with them."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while PTC Windchill is ranked 22nd in Enterprise Architecture Management with 1 review. IDERA ER/Studio is rated 8.4, while PTC Windchill is rated 5.0. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of PTC Windchill writes "Pricy and tough to integrate with some solutions, though it provided essential support for workflows". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest, whereas PTC Windchill is most compared with Intralink, Omnify Empower PLM, Siemens PLM TeamCenter, Sparx Systems Enterprise Architect and Aras Innovator.
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.