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) (13th), 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 (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Mindshare comparison

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

"The solution can be used on both legacy and non-legacy systems."
"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 platform's ability to generate metrics is the most valuable feature for data management. It is a user-friendly and easy-to-use tool."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"The mass ingestion functionality and the elasticity of the solution are great."
"The features for data quality, data cataloging, and UI are excellent."
"The solution's technical support is pretty good, especially since the turnaround time is good."
"It is easy to create REST-based interfaces of the master data objects."
"The most valuable feature of Informatica Axon has been the data marketplace."
"A great product enrichment tool."
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
 

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."
"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."
"The solution still is a bit manual in its functionality. We want t to be more automation-driven."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"We currently have issues with real-time integration."
"The ability of the product to leverage the power of big data could be improved."
"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."
"There are also some technical issues sometimes with integrations because clients have a lot of different types of data sources."
"There's no direct way to connect to Amazon APIs from Informatica Cloud."
"The pricing model is problematic."
 

Pricing and Cost Advice

"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 purchase TDM's yearly license."
"It is an expensive solution. I would say it is the most expensive solution in the market."
"There is no doubt that it is very expensive, but the brand value comes at a cost. Other MDM solutions in the market that haven't proven themselves like Informatica are also pretty expensive. We need to understand that MDM itself is very expensive to implement. So, Informatica is also pretty expensive. I would rate it a two out of five for being pretty expensive."
"Informatica MDM is a costly solution because it comes as a bundle. They are also globally positioning themselves and are definitely working on very upgraded technologies. If someone wanted to do it on the cloud, they have a lot of flexibility because they upgrade themselves according to the current needs. It definitely comes with a lot of features and that's the reason why it's costly. The licensing cost should be approximately one million dollars. It's about four to five times that of other vendors."
"I rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive."
"We switched to Informatica PIM because it was cheaper than the Oracle solution. It is cheaper initially, but they will bundle it later. This is what happens in the industry."
"It's a costly solution"
"The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives."
"It's a very expensive solution"
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
845,564 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
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: March 2025.
845,564 professionals have used our research since 2012.