No more typing reviews! Try our Samantha, our new voice AI agent.

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

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 15, 2026

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
214
Ranking in other categories
Data Integration (1st), Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (2nd), API Management (5th), Cloud Data Integration (3rd), Data Governance (3rd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (4th), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (1st), AI Data Analysis (1st)
 

Mindshare comparison

As of April 2026, in the Test Data Management category, the mindshare of IBM InfoSphere Optim Test Data Management (TDM) is 6.6%, down from 8.6% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 6.5%, up from 4.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Test Data Management Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)6.5%
IBM InfoSphere Optim Test Data Management (TDM)6.6%
Other86.9%
Test Data Management
 

Featured Reviews

Ajai Lal - PeerSpot reviewer
Project Manager at Mphasis
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.
Divya-Raj - PeerSpot reviewer
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
Handles large data volumes effectively and offers competitive pricing
There is a lot of improvement required, as we still face some cache issues most of the time, which is a challenge that we expect to see resolved in the future. Additionally, there is some limitation when we are working with a tool, especially regarding In and Out parameters, and I feel that this aspect should be improved going ahead. We face issues with the API side, as Cloud Application Integration cannot handle large volumes; according to the API page, there is a limitation of 500 records or 500 MB. The AI integrated into the Informatica Intelligent Cloud Services solution is called Application Integration, where we still face challenges when dealing with huge volumes, as previously explained.

Quotes from Members

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

Pros

"Makes it really easy to obfuscate big tables involving lots of columns and to manage 100’s of tables without putting in much effort."
"The Data Archive or Data Growth feature is one of the very useful solutions that help organizations to manage and support their database archiving strategies."
"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."
"Data masking with consistency across databases and applications is the most valuable feature."
"The solution can be used on both legacy and non-legacy systems."
"Data archiving saved much storage and improved production performance."
"Reduces the need to keep expanding data storage Faster query performance with shorter batch execution times Consistent data masking and data integrity in non-production environments Efficient test data management"
"Data archiving reduces application performance issues and storage."
"The match and merge functionality is invaluable for discovering golden master data records."
"The process of using the tool's scalability option is well documented."
"The solution is very scalable, and if a company needs to expand it, it should not face any issues doing so."
"Informatica MDM has data quality, mastering the data's capability."
"The staging and hierarchical features are the most valuable."
"The solution is stable."
"It is a highly scalable solution."
"The solution offers good data governance."
 

Cons

"The tool does not support new test data generation."
"I think it could be more secure. It could also have some more features, and the initial setup could be more straightforward."
"Data masking with InfoSphere Optim products creates intermediary extract files and writing the data to persistent storage, which means that extraction, masking, and insertion happen being separate processes, taking more for the process to run."
"In the IBM Optim tool, the Synthetic Test Data Generation feature is lagging behind."
"TDM's efficiency in terms of generating reports needs improvement. It could work faster."
"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."
"In the past, we have waited months for IBM to resolve the problem."
"I would like to be able to combine different masking functions on the same column map, making more complex masking without the need to write a Lua procedure."
"The company that I moved out of was going to be switching off Informatica at some point due to licensing, et cetera, and they just chose to go to StreamSets with Snowflake for storage."
"The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility."
"Database access is highly restricted particularly if you're using the cloud version."
"By improving customer service integration solutions development implementation style."
"The integration with older technology and cloud quality needs improvement."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"UI application performance was quite disappointing until v9.0.x, but with 9.5 and later versions, they have facelifted the UI."
"The main issue probably has nothing to do with end users, but installation can definitely be simplified."
 

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."
"We pay for a yearly subscription."
"So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise."
"Informatica is very expensive."
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
"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."
"Informatica MDM's price could be lower."
"You pay for this solution based on IPUs, Informatica Processing Units. This depends on how much data you process and how much memory you consume from the cloud provider, and you pay as you go."
"The price is high, but the competitors are even higher, like Collibra."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
886,664 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
14%
Insurance Company
10%
Manufacturing Company
8%
Financial Services Firm
14%
Manufacturing Company
10%
Computer Software Company
7%
Retailer
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise1
Large Enterprise14
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise153
 

Questions from the Community

What advice do you have for others considering IBM InfoSphere Optim Test Data Management (TDM)?
The solution does not need much maintenance. The solution is maintained by the infrastructure team. There is a separate team for the software installation. I would recommend the solution to other u...
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, Address Verification, Persistent Data Masking
 

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: April 2026.
886,664 professionals have used our research since 2012.