We performed a comparison between IDERA ER/Studio and Informatica Persistent Data Masking 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."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."
"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."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"We are able to document the data lineage and data flows of our data from one system to another."
"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."
"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."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"Informatica is user-friendly, stable, and scalable. These three aspects are the most valuable for us. If we can make it work well with the CRM, we can continue or try again this year to complete that part of the project. I am confident that this kind of solution is what we need because we have a third-party resource that works in the development."
"The most valuable features are the structure masking and platform masking."
"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."
"The most valuable feature is data discovery. This is the most exciting feature for all of the banks."
"Informatica Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"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"
"The visual presentation is a little too colorful and seems that it is dumbed down."
"When building the relationships there should be a little more flexibility."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"This solution needs more precise documentation."
"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."
"Once the data is masked, we won't be able to reverse it back to its original value."
"Informatica's support understands the solution, but they lack the experience we need for our use case. That was one thing that we prioritized when we started searching for this kind of solution."
"I have encountered some issues using the substitution, which is one of the techniques of data masking."
"The data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud."
"Informatica should simplify the rules for setting classifications and user access management permissions. It's too complex to define, configure, and make work."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while Informatica Persistent Data Masking is ranked 6th in Data Masking with 5 reviews. IDERA ER/Studio is rated 8.4, while Informatica Persistent Data Masking 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 Informatica Persistent Data Masking writes "Enables secure data protection during testing and controlled access to sensitive information". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas Informatica Persistent Data Masking is most compared with Delphix, Protegrity Data Security, IBM Security Guardium Data Protection, IBM InfoSphere Optim and Imperva SecureSphere Database Security.
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.