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
181
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (7th), 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)
 

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."
"Informatica Cloud Data Integration is stable."
"It has flexibility in extending the data model."
"The valuable feature is that we can automate the integration part...It is a stable solution."
"It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance. Everything can be built under one particular umbrella. If any issues come up, then there won't be any blame game saying that it could be an integration issue or an MDM hub issue because it's wholly owned by Informatica. That's the biggest advantage of Informatica MDM over that of any other tools that are available on the market."
"We've used the solution for quite some time, so in our organization, the product is pretty mature."
"Informatica Business Process Manager is easy to use and learn."
"The solution allows the complete governance process, starting from the data quality, those definitions, and it can get the data quality in the EDC."
"I like the connectivity and richness of features for the technical team, the maturity of the product, and that it had a cloud version. There is Informatica Cloud, and it is part of the Informatica Cloud platform."
 

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."
"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."
"It is complicated to establish the lineage in EDC using PowerCenter mappings."
"Although we are very satisfied with the design of the UI, executing tasks with it can be difficult."
"The on-prem version's functionalities may not be available on the cloud version."
"I think everything related to the APIs and the manageability of the APIs in Informatica MDM are areas where improvements are required."
"Informatica is very expensive."
"Informatica MDM could improve the interdependency with integration. The solution sometimes becomes a bit difficult to change considering a lot of interdependency with the integration. There can be some improvement in the workflows and they can introduce more artificial intelligence."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
"The initial setup was not very straightforward. Not complex, but not very simple either."
 

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."
"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"Comparatively, their prices are a little bit too high."
"I rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive."
"The product is very expensive"
"It is an expensive solution. I would say it is the most expensive solution in the market."
"It's offers value for money. They're more competitive with respect to pricing and offerings."
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
report
Use our free recommendation engine to learn which Test Data Management solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Insurance Company
13%
Manufacturing Company
8%
Healthcare Company
8%
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Government
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
 

Learn More

 

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.
831,265 professionals have used our research since 2012.