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 can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"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 most valuable features are... those that enable me to represent the database to the development community and the business users."
"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."
"We use the solution to create data models which describe our company's data architecture"
"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."
"It offers a lot of features in one solution. You would have to get multiple other products to bundle together all of the capabilities that you get in just this product."
"This solution has good tools for big data, where you can manage large and complex databases."
"The initial setup was very easy."
"The most valuable feature is that it is a very fast reverse engineering process. It does a very expansive comparison."
"In PowerDesigner, I primarily use BPM and modeling standards. I find it beneficial for process analysis, although I use data modeling to a lesser extent."
"SAP PowerDesigner is fairly stable."
"It's a great tool for documentation."
"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."
"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."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"When building the relationships there should be a little more flexibility."
"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."
"We would always like to see Repository performance improve, checking in and checking out."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"The screens are a bit outdated. They could use a new look and feel."
"This product does not have a good BPMN Modeler."
"In the future, I would like to see data manipulation capability where you can actually write SQL queries and manipulate data from directly within the tool."
"Technical support needs improvement."
"Checking-in models to the repository, especially when working remotely, is a slow process than can sometimes have problems with models being corrupted."
"Not very intuitive or user-friendly."
"Connectivity can be improved because it's not very good."
"SAP PowerDesigner can improve the ease of use. It is not the best tool on the market because it is tough to navigate and use. A beginner would not be able to use it well, it requires some experience. If the solution was more user-friendly it would be able to be used by more audiences. I do not think many people are aware of this solution and they should use it."
"The data governance should be improved, like ER/Studio."
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.