We performed a comparison between IDERA ER/Studio, Protegrity Data Security, and Quest Spotlight 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."We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"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."
"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."
"The data modeling and reverse engineering features are most important to us."
"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."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"Its technical support team is helpful."
"The product is stable."
"The most valuable feature of Protegrity Data Security is the reduction of information being exposed."
"The solution’s pricing is moderate."
"Its dashboards are most valuable. The drill-down of the dashboards is useful."
"I consider the solution very scalable."
"The tool is a SaaS product where I just need to type a URL and start with the design process. I can integrate all elements of source control like GitHub, GitLab, etc. The tool also supports authentication-related provisions like SSH."
"The screens are a bit outdated. They could use a new look and feel."
"This solution needs more precise documentation."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"What needs the most improvement are semantic lineage and usability."
"When building the relationships there should be a little more flexibility."
"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."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"Protegrity Data Security could improve by having more integration."
"The solution's UI could be better."
"Protegrity is using a different OS which has some bugs. Sometimes it's causing an initialization error."
"There's no reporting with this tool, and there really should be. They should add that into future releases."
"The software does not support webhooks. It doesn't support advanced versions of APIs. The tool also doesn't support advanced versions of specifications. The change that we do in one part of the model is not reflected throughout the specification. There are also some mutations in the clones. I am not able to do a local source control with the product as well."
"Some customizations of the dashboard, such as having backup reports, would be useful."