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."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."
"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."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"The tool is simple to use."
"Straightforward setup."
"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."
"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."
"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."
"The most valuable feature of Protegrity Data Security is the reduction of information being exposed."
"Its technical support team is helpful."
"The solution’s pricing is moderate."
"The product is stable."
"Its dashboards are most valuable. The drill-down of the dashboards is useful."
"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."
"I consider the solution very scalable."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"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."
"We would always like to see Repository performance improve, checking in and checking out."
"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."
"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."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"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"
"Protegrity is using a different OS which has some bugs. Sometimes it's causing an initialization error."
"The solution's UI could be better."
"Protegrity Data Security could improve by having more integration."
"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."
"There's no reporting with this tool, and there really should be. They should add that into future releases."
