IDERA ER/Studio vs Informatica Persistent Data Masking comparison

Cancel
You must select at least 2 products to compare!
IDERA Logo
1,897 views|1,335 comparisons
86% willing to recommend
Informatica Logo
287 views|167 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,679 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
"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."

More IDERA ER/Studio Pros →

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

More Informatica Persistent Data Masking Pros →

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

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

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,679 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,897
    Comparisons
    1,335
    Reviews
    3
    Average Words per Review
    393
    Rating
    8.0
    10th
    out of 31 in Data Masking
    Views
    287
    Comparisons
    167
    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,679 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.