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."Straightforward setup."
"The data modeling and reverse engineering features are most important to us."
"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."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"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."
"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 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."
"I do a data-centric design, so for me, the data analysis and design tools are the most valuable features."
"It's a stable system. It never crashes."
"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."
"The most valuable features of SAP PowerDesigner are the creation the flow charts and folders. It is a powerful tool."
"The most valuable feature is that it is a very fast reverse engineering process. It does a very expansive comparison."
"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 like the property sheet capability and the user-defined attributes that you can set up."
"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 screens are a bit outdated. They could use a new look and feel."
"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."
"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."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"UI could be improved by enabling simpler navigation."
"There are many areas of this solution that needs to be changed."
"The solution is very, very expensive. It would be ideal if it was a more affordable product."
"This product does not have a good BPMN Modeler."
"Technical support could be better and more human."
"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."
"Checking-in models to the repository, especially when working remotely, is a slow process than can sometimes have problems with models being corrupted."
"The solution itself does not need to be improved. However, they could add support for different languages."
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.