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
7.8
Reviews Sentiment
6.8
Number of Reviews
182
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (11th), Business-to-Business Middleware (4th), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (2nd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Mindshare comparison

As of March 2025, in the Test Data Management category, the mindshare of IBM InfoSphere Optim Test Data Management (TDM) is 8.8%, down from 12.6% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.5%, up from 3.3% 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

"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 features are the most valuable, as non-production environments are used by diverse parties and data privacy has to be guaranteed."
"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 scalability is very high."
"I know that there are two good features, APN and ServiceNow but we haven't explored all of its features yet."
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."
"We are able to set rules, establish a data quality management platform, and monitor the quality."
"The staging and hierarchical features are the most valuable."
"Informatica MDM stands out as a tool that can give you the flexibility needed for doing channel-specific data quality or business validation."
"The most important features are the mastering of the data and the UI intuitiveness."
"We use parts and standardization for most of our testing. We purchase the US Postal Service address database, which is updated periodically. Many useful tools, such as Google Maps, can detect and mark new businesses or changes in business locations. Informatica captures and updates this information. Some periodic maintenance is involved, but setting it up is not overly complicated."
 

Cons

"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."
"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."
"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."
"User/group administration could use improvement."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"The product could be improved in the area of architecture and technology. All the parts are old."
"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."
"The ability of the product to leverage the power of big data could be improved."
"I would like to see support for more data sources."
"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them."
 

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."
"The price is high, but the competitors are even higher, like Collibra."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"Informatica Axon is a costly solution. I rate Informatica Axon a four out of ten for its pricing."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
"I rate the product's pricing a seven on a scale of one to ten, where one is the lowest price and ten is the highest price."
"Informatica is very expensive."
"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."
"We have licenses, and we are provided with certain particular services in the solution."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
841,004 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Insurance Company
14%
Manufacturing Company
9%
Educational Organization
8%
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
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: January 2025.
841,004 professionals have used our research since 2012.