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."We are able to document the data lineage and data flows of our data from one system to another."
"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."
"The tool is simple to use."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"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."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"It does the job."
"Informatica Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information."
"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."
"The most valuable feature is data discovery. This is the most exciting feature for all of the banks."
"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."
"This solution needs more precise documentation."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The solution's reporting could be improved because the report writer is terrible."
"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."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"We would always like to see Repository performance improve, checking in and checking out."
"The only thing I had an issue with was licensing, and the support was very good."
"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'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."
"Once the data is masked, we won't be able to reverse it back to its original value."
"I have encountered some issues using the substitution, which is one of the techniques of data masking."
"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 34 reviews while Informatica Persistent Data Masking is ranked 10th 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, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest, whereas Informatica Persistent Data Masking is most compared with Delphix, IBM InfoSphere Optim, Protegrity Data Security and IBM Security Guardium Data Protection.
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.