We performed a comparison between IDERA ER/Studio, Oracle Enterprise Manager, and Quest Foglight for APM [EOL] based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."The most valuable features are... those that enable me to represent the database to the development community and the business users."
"The tool is simple to use."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"It does the job."
"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."
"Straightforward setup."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"Oracle Enterprise Manager has eased the responsibilities among our DBAs. We can now assign individual tasks to separate DBAs."
"We use it extensively for performance tuning testing, monitoring, and configuration."
"The job subsystem, monitoring subsystem, alerting, grouping of targets, and reporting features are valuable to us."
"It is a stable solution...The initial setup of Oracle Enterprise Manager was straightforward."
"I like that it's stable."
"The dashboards are great for gathering analytic information and seeing where the problems are."
"It is the best database management system."
"This solution allows us to quickly drill down when there are issues."
"The ability to track performance of an application or application suite over time is extremely valuable to our business partners and for our application development team with near real time results."
"Real time database monitoring and alerting are valuable."
"The most valuable feature is drill-down monitoring, which shows us from one interface the transaction chain from the front end to back end."
"It provides a history of the activities on our SQL servers."
"Having standard monitoring features and a central repository saves us a lot of time and reduces risk of incidents."
"With the APM you can replay the end user session and see issues quickly by viewing the session."
"Capacity on database and file servers. I found the algorithms to forecast growth and concerns particularly intuitive."
"Intuitive, Single-pane-of-glass dashboards for real-time statistics and long-term statistics for capacity management and in-depth analytics"
"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)."
"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."
"When building the relationships there should be a little more flexibility."
"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 model diagram because very clumsy when you save it on the team server and the models are very big."
"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 like to have a single dashboard for monitoring and controlling all of our products."
"My opinion is that this solution needs to improve consolidation. That is what our business needs the most right now."
"The fact that Oracle Enterprise Manager is an expensive solution is a matter of concern and needs to be considered for improvement."
"Reporting and statistical charting is largely still left up the end-user to develop custom solutions."
"We have encountered performance issues when the load is huge."
"Technical support could be more responsive."
"We could use it but definitely with some effort we can streamline much better and sometimes some box here and there, like 13C you have to really wait, but there are great features. Just have to make sure it is a stable product."
"The tool's pricing is costly."
"I want to see mobile access application in the next release."
"SQL agents often failed but again this may have been addressed in future versions."
"There are some metrics I'd like to track that are difficult to find or implement into a tracking solution without a lot of manual work."
"I would perhaps like to see more SSMS connections."
"They need to improve the stability of FxM and FxV."
"Being able to incorporate other bespoke monitoring into Foglight would have made the tool even more useful."
"I think installation and setup needs little more improvement especially when you are installing with external database."
"The version compatibility needs work."
Earn 20 points