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."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."
"The reverse engineering is the most important feature."
"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 valuable features are... those that enable me to represent the database to the development community and the business users."
"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 most valuable feature of the solution is generating DDL (data definition language)."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"It does the job."
"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 Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information."
"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."
"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."
"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."
"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."
"What needs the most improvement are semantic lineage and usability."
"When building the relationships there should be a little more flexibility."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"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."
"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."
"I have encountered some issues using the substitution, which is one of the techniques of data masking."
"Once the data is masked, we won't be able to reverse it back to its original value."
"Informatica should simplify the rules for setting classifications and user access management permissions. It's too complex to define, configure, and make work."
"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."
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.