Informatica Data Archive (legacy) vs. Oracle Data Masking and Subsetting

To manage users, go to the admin dashboard, here is a section for users. In this users section here you can see which users are configured and you have the ability to suspend a user. If you want to edit or add users, you need to go to the Organization section, then click on another user section there, which then gives you the ability to edit or add users.

Incentivized

The tool is excellent when you need to provide all the details about your clients, yet hide their identity - all while maintaining the referential integrity of the data (so child-records of the masked parent record and maintain the same fake ID of the parent).

Incentivized

• Works well with curated data
• Allows you to monitor data movements within an organisation
• Advisable to use ILM if already using Informatica PowerCenter

Incentivized

• It offers several ways in which you can mask your data; for example, you can choose to replace all names with "real fake names", or choose to replace all SSNs with existing SSNs, but randomly assigned. You control the algorithm.
• It works on non-Oracle databases as well (in our case, we use it for both Oracle and SQL/Server).
• The overhead is minimal (it doesn't take long to run, and it doesn't consume too many system resources.

Incentivized

• As we are still piloting the product at our company at this time the feedback is highly limited.

Incentivized

• The learning curve was not trivial - but we got through it.
• Cost - this product is not cheap.

Incentivized

[The] customer support is quite good. Cost also has another point to add, along with process integration and ease of using new tool.

Incentivized

We also looked at Delphix: the tool was quite powerful, easy to use, and competitive from a cost standpoint. However, since our entire data warehouse environment is built on the Oracle technology stack, it made sense to us to use the Oracle product here, as it integrates very well with other Oracle database and ETL products.

Incentivized

• it is also fully integrated with all other AWS services
• manages the entire life cycle of the Certificates by itself, so it will reduce your work by a really big amount
• it can also be easily integrated with ELB and front-end cloud services.

Incentivized

• We have many compliance regulations we need to adhere to. Without this tool, we were always taking a risk of exposing client information, and get penalized by the State of the Feds (the financial consequences are significant).
• So while the tool doesn't save us money directly, it greatly reduces the risk we had been taking all these years. To some degree, this is much like an insurance policy.
• Given the above, it also allows us to share information with other departments/agencies, in situations where before we simply couldn't take the risk of exposing client information.

Incentivized