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."Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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 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."
"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."
"It does the job."
"We are able to document the data lineage and data flows of our data from one system to another."
"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."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"The most useful feature has been the detailed possibility to model almost anything regarding physical databases."
"I've used the reverse engineering feature a lot. I can take a look at the structure of the database and what relationships it has."
"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 mostly work on the conceptual and logical side of things, and I enjoy how easy it is to use."
"It can automate many routine tasks and save human resources to focus on real problems."
"It's a great tool for documentation."
"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."
"I do a data-centric design, so for me, the data analysis and design tools are the most valuable features."
"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"
"We would always like to see Repository performance improve, checking in and checking out."
"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."
"What needs the most improvement are semantic lineage and usability."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"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."
"There should be a better usage of current hardware including multicore CPUs, higher resolutions, and multiple displays."
"The data governance should be improved, like ER/Studio."
"There are many areas of this solution that needs to be changed."
"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."
"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."
"Not very intuitive or user-friendly."
"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."
"Technical support needs improvement."
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.