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."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"It does the job."
"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 most valuable feature of the solution is generating DDL (data definition language)."
"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."
"Straightforward setup."
"The solution is a very pragmatic tool. It's quite easy to use."
"SAP PowerDesigner is fairly stable."
"Provides the flexibility to create logical and conceptual data models."
"It allows us to have proper documentation in terms of the databases."
"The initial setup was very easy."
"It has helped me to develop the as-is state, design its to-be state, and track the capital investment according to gap analysis."
"The most valuable features of SAP PowerDesigner are the creation the flow charts and folders. It is a powerful tool."
"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."
"The solution's reporting could be improved because the report writer is terrible."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"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."
"When building the relationships there should be a little more flexibility."
"What needs the most improvement are semantic lineage and usability."
"The focus is more on mainstream development environments, and I see a lack of focus on the open source world. I think SAP PowerDesigner probably interfaces better with SQL Server and Db2 but not with open source databases like PostgreSQL and MySQL."
"The tool lags in the area of customer service."
"Technical support needs improvement."
"The user interface could be more user-friendly."
"Connectivity can be improved because it's not very good."
"It would be helpful if there were glossary, catalog and governance tools. It would help make it a true end-to-end product."
"The portal of SAP PowerDesigner could be better. The tool also needs more features and integration with other products, such as Collibra. It would be interesting for SAP PowerDesigner to have more integration."
"This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements."
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.