Informatica Test Data Management (TDM) Reviews

• It has good integration with other platform products
• Imports data domains and profiles created with other tools of the suite, such as analysts and developers

It forced the organization to a more extensive and deeper profiling of data. We got a better understanding of our data, which also helped the startup of MDM projects.

The interface design needs improvement. Sometimes it’s a bit cumbersome. It could be more uniform with other tools such as analyst, including organization and functionality.

I have used this solution for almost a year.

I have not had any stability issues.

I have not had any scalability issues because the product uses the ETL part of the suite (PowerCenter).

Informatica’s support for the entire platform is very good and this product is no exception.

We didn’t have a previous solution.

The setup is not complex, but not completely straightforward. With a bit of trial and error, we developed a good methodology to accomplish our goals, i.e., mainly slicing and masking the data.

I don’t have such information. Generally speaking, with Informatica you have to be extremely careful of what are you buying because sometimes the licensing model is a bit tricky.

We have not tried other products.

Take extreme care in developing an effective strategy to use the sections of the product that you need.

Data masking is the most valuable feature of this product.

I could mask PHI and PII information in my data before sharing it with both the testing teams and the teams that are outside our organization.

If there were some methods to mask data in the cloud, then that would be good.

I have been using this solution for one year.

We have not encountered any stability issues. It is highly stable.

It is highly scalable.

The technical support is excellent.

I have not used another different solution before. This is the first time I am using such a solution.

The initial setup process was straightforward.

It is an excellent product. It is easily maintainable and flexible. The pricing and licensing policy depends upon the budget and compliance needs for the project.

We have not evaluated any other product prior to this solution.

Go ahead and use this product. It is easy for an organization to train the employees with this product.

The product provides four main features:

Data discovery to profile data and mask sensitive data.

Data subsetting to take a subset of production data from all schema tables while preserving referential integrity.

Data masking to create masking rules and mask the fields that we select.

Data generation If we don’t want to mask production data, the tool can generate data based on rules that we configure.

All of the features are strong, however my favorite is data masking. Also, it provides many built-in rules and rules that we can customize to mask all types of data. The masking engine is very strong.

TDM includes built in policy packs, and these are masking and data discovery techniques that are created for common confidential fields like name, Date of Birth, address… Such fields that you can find almost in every database in any company.

The data discovery techniques are regular expressions (RegEx) that are executed on the metadata (the column names) or the data itself to find matches to my discovery.

Example: a data discovery rule with a regular expression set to *name* will find all the fields that include “name” like First_name_EN, full_name_FR… but it will not return the field FN_EN (And I mean by this First Name English)

So if I want to discover all the fileds in my database that might include names I will miss some, since the data discovery rule with RegEx = *name* is very simple and needs to be more complex to cover all columns syntaxes.

I did the implementation for many clients. It is mostly used to mask production data and get values that are realistic but not real. With this, they create development and testing environments with data that looks like it’s real. Developers and UAT will be able to work with such better data sets.

Data discovery and the built in policy packs are very simple; they need stronger ones.

I have been using Informatica since 2012.

I have not encountered stability issues.

I have not encountered scalability issues.

Informatica provides good support for this tool, from knowledge base to tickets for direct support. Any issue is always solved thanks to their support.

I have not used another tool.

To install TDM, you need to install PowerCenter first, which is another Informatica tool. So the installation takes time but it’s always smooth and not that complex.

This is the only product I’ve used.

I recommend it. A very user friendly tool and it’s not mandatory to be technical to use it.