We performed a comparison between IDERA ER/Studio and SAP PowerDesigner 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."IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"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."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"The reverse engineering is the most important feature."
"The most valuable feature of the solution is generating DDL (data definition language)."
"The data modeling and reverse engineering features are most important to us."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"The tool is simple to use."
"The feature I found valuable in SAP PowerDesigner is extraction. I also like that my company hasn't faced any issues because of the clear documentation about SAP PowerDesigner."
"The most valuable feature is the way you can extend it and customize it. With most modeling tools, you fit your modeling process to fit the tool. In PowerDesigner, you can make the tool fit the way you want to work."
"Provides the flexibility to create logical and conceptual data models."
"I like the property sheet capability and the user-defined attributes that you can set up."
"I do a data-centric design, so for me, the data analysis and design tools are the most valuable features."
"It's a great tool for documentation."
"SAP PowerDesigner is an excellent tool that does what I need it to do. What I like most about it is that it's stable, fast, and easy to understand."
"I mostly work on the conceptual and logical side of things, and I enjoy how easy it is to use."
"What needs the most improvement are semantic lineage and usability."
"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."
"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."
"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."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"When building the relationships there should be a little more flexibility."
"The only thing I had an issue with was licensing, and the support was very good."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"I've tried to use Power Designer to bring in images, which didn't work very well at all."
"Technical support could be better and more human."
"Checking-in models to the repository, especially when working remotely, is a slow process than can sometimes have problems with models being corrupted."
"There are some minor things that could be easier. We're writing up procedures to bring all the modeling back into one group as this reduces delays in production."
"SAP PowerDesigner could improve by making the repository easier to understand. It is difficult to understand how the repository works because when I used logical models as part of the team, we wanted to use them together and update the older versions of the data model version but it was confusing. The repository needs to be explained."
"The solution is very, very expensive. It would be ideal if it was a more affordable product."
"Pricing for small consultancies needs improvement. They sustain prices to competing tools. The competing tools tend to do special offers. PowerDesigner SAP doesn't pay much attention to the pricing of it and there are no special offers."
"The data governance should be improved, like ER/Studio."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 reviews while SAP PowerDesigner is ranked 5th in Enterprise Architecture Management with 34 reviews. IDERA ER/Studio is rated 8.4, while SAP PowerDesigner is rated 7.8. 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 SAP PowerDesigner writes "Effective in terms of validating everything, but sometimes they don't allow us some flexibility and GUI could improve". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Toad Data Modeler, erwin Evolve by Quest and LeanIX, whereas SAP PowerDesigner is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Visio, LeanIX and BiZZdesign HoriZZon. See our IDERA ER/Studio vs. SAP PowerDesigner 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.