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."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."
"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."
"We are able to document the data lineage and data flows of our data from one system to another."
"The data modeling and reverse engineering features are most important to us."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"It has helped me to develop the as-is state, design its to-be state, and track the capital investment according to gap analysis."
"It can automate many routine tasks and save human resources to focus on real problems."
"The most useful feature has been the detailed possibility to model almost anything regarding physical databases."
"I mostly work on the conceptual and logical side of things, and I enjoy how easy it is to use."
"Has a specific template that's very helpful for importing metadata."
"The physical database model is definitely the most valuable feature because it describes normalization exactly the way you understand the data, and it deploys it perfectly with open source systems."
"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."
"The most valuable features of the solution are it's built very well, easy to use, and simple to describe freely what is needed in logical and physical data models."
"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."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"The only thing I had an issue with was licensing, and the support was very good."
"We would always like to see Repository performance improve, checking in and checking out."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"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 itself does not need to be improved. However, they could add support for different languages."
"The user interface could be more user-friendly."
"This product does not have a good BPMN Modeler."
"Technical support needs improvement."
"One disadvantage of SAP PowerDesigner is that you cannot reverse engineer the ALTER statements, so that's an enhancement or area for improvement I'm looking forward to seeing from the SAP team in the future. That should directly reflect on the physical data models my company builds."
"You have the possibility to complete a connection for abbreviations if you are creating columns or names of the tables. In the Citrix environment, this has been lagging to the point where the PowerDesigner was not usable."
"I have found the solution not easy to use. When publishing you have to download the HTML, make adjustments against the updated HTML, convert it to HTML, then finally paste the HTML. There is not an on-the-fly function available to bypass the step-by-step converting process that other solutions have."
"Not very intuitive or user-friendly."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while SAP PowerDesigner is ranked 4th in Enterprise Architecture Management with 32 reviews. IDERA ER/Studio is rated 8.4, while SAP PowerDesigner is rated 8.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 SAP PowerDesigner writes "Difficult to operate, long process to publish, but scalable". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Toad Data Modeler, erwin Evolve by Quest and Aqua Data Studio, whereas SAP PowerDesigner is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, Visio, LeanIX and MEGA HOPEX. 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.