Try our new research platform with insights from 80,000+ expert users

IBM InfoSphere Optim Test Data Management (TDM) vs Informatica Intelligent Data Management Cloud (IDMC) comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Oct 1, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

IBM InfoSphere Optim Test D...
Ranking in Test Data Management
6th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
15
Ranking in other categories
No ranking in other categories
Informatica Intelligent Dat...
Ranking in Test Data Management
3rd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Integration (2nd), Data Quality (1st), Business Process Management (BPM) (11th), Business-to-Business Middleware (5th), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Mindshare comparison

As of June 2025, in the Test Data Management category, the mindshare of IBM InfoSphere Optim Test Data Management (TDM) is 8.6%, down from 10.9% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.1%, up from 3.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Test Data Management
 

Featured Reviews

Ajai Lal - PeerSpot reviewer
Supports both legacy and non-legacy systems
The solution's initial setup is neither complex nor too easy. Around six or seven people, including database administrators, were involved in the solution's deployment. On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup a four to five out of ten.
Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Data masking features are the most valuable, as non-production environments are used by diverse parties and data privacy has to be guaranteed."
"I like the features compared to other tools. This tool is more flexible to use than other tools like an Oracle product or SAP product. I think IBM tools are more flexible, and this tool is also a good product."
"The solution can be used on both legacy and non-legacy systems."
"The platform's ability to generate metrics is the most valuable feature for data management. It is a user-friendly and easy-to-use tool."
"The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
"The ability to clean out data and improve the data quality is the best feature."
"The interface is really good."
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."
"The user interface is flexible and the visibility of the data flow is amazing."
"Its data cleansing capabilities are very valuable. The match and merge and the audit trail functionalities are very good."
"It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten."
"The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."
 

Cons

"I would like to be able to combine different masking functions on the same column map, making more complex masking without the need of writing an Lua procedure."
"TDM's efficiency in terms of generating reports needs improvement. It could work faster."
"I think it could be more secure. I don't have experience with the security aspects concerning PII data, but I think it can still be streamlined a little more. It could also have some more features, and the initial setup could be more straightforward."
"Metadata querying is right now not there in Informatica Cloud Data Integration."
"The user interface can be a bit more functionality-aligned."
"Currently, there are limitations in processing and the interface."
"Informatica MDM has a complex user interface, which could be improved."
"In terms of what could be improved, they need to create a rules repository. Business rules for the attributes that you have, keeping them in that central repository, and governance of them is something which Axon is lacking a bit. The Informatica Data Quality tool actually caters to that, so that's probably why they have not built that up in the Axon, but it is definitely something that can be built in to this product, as well."
"The configurations could be better. It is a bit confusing because we must develop two tools when building a data model in Informatica MDM. Even though Informatica MDM is a single tool, we have our hub console plus the provisioning tool within that. Whatever data model we are building in the hub console, we have to develop it in the provisioning tool again. It is double the work to create a data model. We are also using external calls or the Java custom plans functions. This can be both positive and negative. Since MDM as a client does not support any complex validation, we have to depend on the external call or a Java call. Every time we deployed, the entire solution was impacted if something went wrong."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"Informatica MDM has limitations with connectivity."
 

Pricing and Cost Advice

"We purchase TDM's yearly license."
"You have to pay yearly for the license, which comes at a reduced cost. The monthly payment option for a shorter project duration is also good."
"Comparatively, their prices are a little bit too high."
"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."
"I rate Informatica MDM's price a six on a scale of one to ten, where one is a low price, and ten is a high price."
"I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
"It is cost effective and an easily accessible tool."
"Informatica MDM's price could be lower."
"A yearly subscription is paid based on the number of people using the solution. Price-wise, it falls under the medium range since it is neither very costly nor too cheap."
"It's a costly solution"
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Insurance Company
15%
Computer Software Company
10%
Educational Organization
9%
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
9%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM InfoSphere Optim Test Data Management (TDM)?
The platform's ability to generate metrics is the most valuable feature for data management. It is a user-friendly and easy-to-use tool.
What needs improvement with IBM InfoSphere Optim Test Data Management (TDM)?
TDM's efficiency in terms of generating reports needs improvement. It could work faster.
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
 

Also Known As

IBM Optim Test Data Management, Optim Test Data Management, IBM InfoSphere Optim Test Data Management
ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
 

Overview

 

Sample Customers

Dignity Health
The Travel Company, Carbonite
Find out what your peers are saying about IBM InfoSphere Optim Test Data Management (TDM) vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: June 2025.
856,873 professionals have used our research since 2012.