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 platform's ability to generate metrics is the most valuable feature for data management. It is a user-friendly and easy-to-use tool."
"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."
"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."
"It is a highly scalable solution."
"It has been leading the market with hierarchy management and all the different match concepts and algorithms. They're very robust."
"It's helpful in integration, and it can be moved around in SharePoint. So, from the SharePoint View, data integration and reporting, it help a lot in that way."
"There are a couple of valuable features. One is that it is very quick on the profiling. So, you get a very fast snapshot of the type of data that you're looking at from the profiling perspective. It can highlight anomalies in the data."
"The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation."
"The ability to clean out data and improve the data quality is the best feature."
"Able to customize data search and data sharing."
"We use it for various use cases, including data provisioning, data validation, continuous monitoring of data quality, and data standardization."
 

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."
"Metadata querying is right now not there in Informatica Cloud Data Integration."
"Permissions, scalability, and connection with other informatic tools are the main areas that need development. Integration with other tools, such as IDQ, is challenging. The management of data discovery is highly challenging because many data points have identical definitions."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"There is room for improvement in the Data Marketplace aspect."
"The UI is terrible and not user-friendly."
"Right now, although they offer some templates, I would want more templates available to be imported."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
 

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."
"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."
"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"Informatica MDM's price could be lower."
"The price is high, but the competitors are even higher, like Collibra."
"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 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."
"The solution is very expensive."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
845,712 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
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,712 professionals have used our research since 2012.