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."We are able to document the data lineage and data flows of our data from one system to another."
"It does the job."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"The reverse engineering is the most important feature."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"I like how the product integrates with other technical solutions."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"The screens are a bit outdated. They could use a new look and feel."
"When building the relationships there should be a little more flexibility."
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"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.