IDERA ER/Studio vs Informatica Persistent Data Masking comparison

Cancel
You must select at least 2 products to compare!
IDERA Logo
1,939 views|1,375 comparisons
86% willing to recommend
Informatica Logo
299 views|175 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Enterprise Architecture Management Report (Updated: May 2024).
772,649 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More IDERA ER/Studio Pros →

"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."

More Informatica Persistent Data Masking Pros →

Cons
"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."

More IDERA ER/Studio Cons →

"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."

More Informatica Persistent Data Masking Cons →

Pricing and Cost Advice
  • "The product is pricey."
  • "The process of licensing could be much simpler, from our experience."
  • "I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
  • "I feel the product's pricing is a good value."
  • "Pricing is on point, but do your due diligence - not every developer needs the tool."
  • "As an individual user, the renewal is a little costly."
  • "Pricing is expensive and on the higher-end."
  • "At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
  • More IDERA ER/Studio Pricing and Cost Advice →

    Information Not Available
    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    772,649 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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
    Top Answer:Informatica Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information.
    Top Answer:I think there's only one area that could be improved. Currently, when we apply the Data Masking rate, we don't have a way to view the masked data. It would be helpful if there was a feature to allow… more »
    Top Answer:Test data management is a common use case. When conducting testing in lower environments, we want to avoid exposing sensitive information. To achieve this, we use Data Masking to modify the data. For… more »
    Ranking
    Views
    1,939
    Comparisons
    1,375
    Reviews
    2
    Average Words per Review
    440
    Rating
    8.5
    10th
    out of 31 in Data Masking
    Views
    299
    Comparisons
    175
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
    Data Masking, Informatica Data Masking
    Learn More
    Overview

    IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the organization and Information Technology. Organizational stakeholders can take part in the metadata definition workflow and access information on models and metadata at the right level for their needs.

    Unlike its competition, it provides the broadest range of data platform support, industry-leading enterprise-level capabilities, visual data lineage and flow modeling, full dimensional modeling for data warehousing and business intelligence, and business data objects to bridge the gap between developers and data architects. It also provides a complete solution for enterprise architecture and data governance, extensive model change management, unique incorporation of true enterprise data dictionaries, unique linking of constructs across models, integrated visual data lineage import, and integrated data and business process modeling.

    De-identify, de-sensitize, and anonymize sensitive data from unauthorized access for application users, business intelligence, application testing, and outsourcing.

    Sample Customers
    Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
    Vale, Hot Telecommunication, UPMC
    Top Industries
    REVIEWERS
    Government18%
    Healthcare Company14%
    Financial Services Firm14%
    Computer Software Company9%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company12%
    Government10%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Financial Services Firm24%
    Computer Software Company14%
    Educational Organization7%
    Insurance Company6%
    Company Size
    REVIEWERS
    Small Business11%
    Midsize Enterprise31%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise9%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise11%
    Large Enterprise69%
    Buyer's Guide
    Enterprise Architecture Management
    May 2024
    Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: May 2024.
    772,649 professionals have used our research since 2012.

    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.