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."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."
"The tool is simple to use."
"It does the job."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"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."
"Data lineage tracking: It allows us to identify upstream and downstream systems using data."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We use the solution to create data models which describe our company's data architecture"
"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 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."
"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."
"The most valuable features are the structure masking and platform masking."
"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 visual presentation is a little too colorful and seems that it is dumbed down."
"The screens are a bit outdated. They could use a new look and feel."
"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."
"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"
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"The only thing I had an issue with was licensing, and the support was very good."
"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."
"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."
"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."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 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, IBM Security Guardium Data Protection and Oracle GoldenGate.
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.