Informatica Intelligent Data Management Cloud (IDMC) vs Pentaho Data Integration and Analytics comparison

Informatica Intelligent Data Management Cloud (IDMC) vs. Pentaho Data Integration and Analytics

Download the complete report

Helped 881,082 peers since 2012

Review summaries and opinions

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

ROI

Sentiment score

7.1

Informatica's cloud platform enhances data management efficiency, cost savings, and data security, requiring effective change management for optimal results.

Sentiment score

7.2

Pentaho Data Integration offers cost-effective, efficient ETL solutions with significant time savings, enhancing IT processes despite perceived obsolescence.

Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

The stability and performance remain issues.

reviewer946383

consultant at a energy/utilities company with 5,001-10,000 employees

Compared to Collibra Catalog, where the value is noticeable within six months.

reviewer2696502

Data and Analytics Manager at a insurance company with 10,001+ employees

I have seen a return on investment; my team was able to stay extremely small even though we had a lot of data integrations with many companies.

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

I can testify to the return on investment with metrics regarding time saved; we have increased our efficiency by about 20 to 30 percent due to the swift migration processes facilitated by the tool.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech vendor with 201-500 employees

Customer Service

Sentiment score

6.9

Informatica's customer service is generally rated positively for quick, knowledgeable support, though some report occasional delays and inconsistencies.

Sentiment score

5.1

Pentaho's support is praised for knowledge and responsiveness, but response times vary, especially for the community edition.

Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.

Consulting Principal & Founder at Digital Data Consultancy

Even after going out of service support, they still reached back to me whenever I raised tickets.

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

We expect more responsive assistance because they have the expertise since Informatica is their tool, but I don't see enough expertise on the Informatica support side.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

24/7 assistance is available for the Enterprise Edition.

Data architect at a tech vendor with 10,001+ employees

take the time to understand our business requirements, offering appropriate recommendations.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech vendor with 201-500 employees

Communication with the vendor is challenging

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Scalability Issues

Sentiment score

7.3

Informatica Intelligent Data Management Cloud is praised for scalability and flexibility in handling large datasets, despite pricing concerns.

Sentiment score

7.2

Pentaho scales well for small to medium data, but may struggle with large datasets, fitting diverse organizational roles.

I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

As a SaaS platform, IDMC is quite scalable and provides complete flexibility.

Consulting Principal & Founder at Digital Data Consultancy

There are many options available, and the licensing model is quite good, supporting our needs effectively.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

It can be scaled well until you reach a point where you need to perform a lot of operations, and the issue arises when it runs out of memory to handle some data.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

Pentaho Data Integration handles larger datasets better.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Pentaho Data Integration and Analytics' scalability is commendable, as it allows us to scale up according to our needs.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data architect at a tech vendor with 10,001+ employees

Stability Issues

Sentiment score

7.7

Users generally find IDMC stable, with occasional challenges after updates, especially in older versions or specific integrations.

Sentiment score

7.1

Pentaho is generally stable and reliable, though occasional memory issues and bugs occur, especially in community editions.

Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.

Consulting Principal & Founder at Digital Data Consultancy

There are substantial stability issues with Informatica Cloud Data Quality on the cloud.

reviewer946383

consultant at a energy/utilities company with 5,001-10,000 employees

I find the stability to be good, with occasional restarts required every two to three months due to glitches.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data architect at a tech vendor with 10,001+ employees

I find that version 3.1 is the most stable version I have ever used.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

It's pretty stable, however, it struggles when dealing with smaller amounts of data.

Jefferson Hernandez

Data Architecture and Engineering Specialist at coprocenva

Room For Improvement

Informatica IDMC needs UI improvements, better connectivity, streamlined configuration, cheaper pricing, and enhanced support with AI integration.

Pentaho needs improved logging, debugging, user interface, performance, environment management, cloud support, documentation, and user feedback integration.

The tool needs to mature in terms of category-specific attributes or dynamic attributes.

Consulting Principal & Founder at Digital Data Consultancy

The current solution requires code-writing and tweaking, while other solutions offer material-level matches.

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

If the development interface could be optimized to have fewer modules, it would be greatly beneficial.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.

Data Integration Developer at a tech vendor with 201-500 employees

Pentaho Data Integration and Analytics can be improved by working with different environments, specifically the possibility to change the variables, meaning I write my variables only once and can change them for different environments such as production or development.

Alberto Pedro

Founder-CEO at Ubuntu Analytica

I also lack the option to use programming languages beyond Python and SQL, and a provision to incorporate Scala code in the scripting component would be beneficial.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data architect at a tech vendor with 10,001+ employees

Setup Cost

Informatica IDMC provides a robust but expensive pricing model with complex licensing and potential negotiation discounts for enterprises.

Pentaho Data Integration provides free and paid versions, with users valuing cost-effectiveness despite rising Enterprise Edition prices.

It ranges from a quarter million to a couple of million a year.

Consulting Principal & Founder at Digital Data Consultancy

Informatica Intelligent Cloud Services is affordable for my specific use cases, with the pricing being rated three or four on a scale where one is very cheap.

Data Integration Architect at Endeavour Foundation

Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.

JuanCarlosMartinezLara

Project Manager at Laberit

The setup cost was minimal, and the pricing experience was pretty good.

reviewer2787603

Data engineer at a educational organization with 1,001-5,000 employees

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Valuable Features

Informatica IDMC offers seamless data integration, AI-enhanced features, and efficient governance, enhancing user experience and operational efficiency.

Pentaho offers intuitive data integration with extensive customization, supporting rapid ETL development, big data, and minimal coding.

The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.

Consulting Principal & Founder at Digital Data Consultancy

The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

We could run data quality rules as part of Service Bus, which ensured the integrity of customer information before it was entered into our database.

reviewer2696502

Data and Analytics Manager at a insurance company with 10,001+ employees

Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us.

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

It automates the data workflow, including extraction, cleansing, and loading into warehouses for BI reporting purposes, while also removing duplicates, validating data, and standardizing formats, enabling real-time decision-making.

For more quotes and insights, download the Pentaho Data Integration and Analytics report

Data Integration Developer at a tech vendor with 201-500 employees

Pentaho Data Integration and Analytics has positively impacted my organization because it is easier to use, and my knowledge about this work facilitates the translation from the source to my final system.

JuanCarlosMartinezLara

Project Manager at Laberit

Categories and Ranking

Informatica Intelligent Dat...

Ranking in Data Integration

2nd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

214

Ranking in other categories

Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (6th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (3rd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (1st), Metadata Management (1st), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (1st), AI Data Analysis (1st)

Pentaho Data Integration an...

Ranking in Data Integration

11th

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of January 2026, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.7%, down from 5.5% compared to the previous year. The mindshare of Pentaho Data Integration and Analytics is 1.5%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Integration Market Share Distribution
Product	Market Share (%)
Informatica Intelligent Data Management Cloud (IDMC)	3.7%
Pentaho Data Integration and Analytics	1.5%
Other	94.8%

Data Integration

Featured Reviews

Handles large data volumes effectively and offers competitive pricing

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

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.

Read full review

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

Streamlines complex data workflows and has supported automated customer payment notifications

I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Data Integration solutions are best for your needs.

See recommendations

881,082 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Manufacturing Company

11%

Computer Software Company

Retailer

Financial Services Firm

14%

Educational Organization

Computer Software Company

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	51
Midsize Enterprise	27
Large Enterprise	153

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	18
Large Enterprise	29

Questions from the Community

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 ...

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

Collibra Platform vs Informatica Intelligent Data Management Cloud (IDMC)

Comparisons

Compared 4% of the time

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

Qlik Talend Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

Semarchy xDM vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 11% of the time

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 8% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 7% of the time

CloverETL vs Pentaho Data Integration and Analytics

Compared 3% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Informatica Intelligent Data Management Cloud (IDMC)

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Informatica Intelligent Data Management Cloud (IDMC) report

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

Informatica Intelligent Data Management Cloud (IDMC) offers seamless integration of master data management, data quality, and data integration with a cloud-native architecture supporting multiple data management styles, optimizing data governance through metadata management.

IDMC enhances data synchronization and mapping tasks, utilizing a broad range of connectors to interact efficiently with data sources. Its precise address validation via AddressDoctor and intuitive navigation bolster user empowerment, delivering agility, scalability, and security in data governance. Despite its strengths, areas like ease of use, SAP integration, and reporting could benefit from enhancements. Connectivity issues and workflow complexities are noted, needing improvements in performance, support, and licensing cost. Users demand expanded ETL capabilities, real-time processing, and broader data source support to address growing data needs.

What are the key features of IDMC?

Integration Capabilities: Ensures seamless connectivity between on-premise and cloud environments.
Master Data Management: Centralizes and streamlines data processes for enhanced quality.
Data Quality: Employs tools for cleansing and standardizing data accuracy.
Address Validation: Features AddressDoctor for precise address verification.
Real-Time Processing: Supports real-time data handling for critical operations.
Connectivity Options: Offers a wide array of connectors for easy data source interaction.

What benefits and ROI should users consider?

Scalability: Cloud-native design boosts system agility, adapting to data volume changes.
Security: Enhances data protection with robust encryption and compliance measures.
Efficiency: Automates processes to reduce manual effort and errors.
Flexibility: Supports diverse data management styles, offering adaptability to business changes.
Governance: Empowers effective data governance through comprehensive metadata management.

In industries such as banking, healthcare, and telecom, IDMC is implemented for data integration, cloud migration, and enhancing data quality. Its capabilities are crucial for metadata management, lineage tracking, and real-time processing, ensuring high data quality and streamlined operations.

Informatica

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

The Travel Company, Carbonite

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Informatica Intelligent Data Management Cloud (IDMC) vs. Pentaho Data Integration and Analytics