Try our new research platform with insights from 80,000+ expert users

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

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
3rd
Average Rating
7.8
Number of Reviews
180
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (5th), Business-to-Business Middleware (3rd), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
Pentaho Data Integration an...
Ranking in Data Integration
30th
Average Rating
8.0
Number of Reviews
50
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Rupal Sharma - PeerSpot reviewer
Aug 23, 2023
Good for data governance, data quality and data exploration
The major points of improvement are stability, integration, and permission to sub-folders or categories of data. If you want to provide access to a particular type of data discovery to a team, it exposes a lot of data points which in turn makes Axon not that useful for them. 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. Mostly, this will come under the data security permission level or admin access.
RicardoDíaz - PeerSpot reviewer
May 19, 2022
We can create pipelines with minimal manual or custom coding, and we can quickly implement what we need with its drag-and-drop interface
Their client support is very bad. It should be improved. There is also not much information on Hitachi forums or Hitachi web pages. It is very complicated. In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud.

Quotes from Members

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

Pros

"The most valuable feature is the building of mockups and tasks."
"I like that Informatica MDM has robust matching technology. Informatica MDM is also porting the external Java applications for validations. I can consider that a must-have. It is also exposed to Rest API calls, and we can engage in real-time integrations with any third-party systems."
"Axon has a marketplace that allows you to showcase all the assets the data owner has, so they can request access. That's one feature we use extensively. Axon also offers great visibility and intuitive searchability, allowing you to easily search data assets. You can check the lineage and see the work EDC does. EDC handles all the classification, cataloging, and lineage. It's integrated with Axon, and anyone can see that."
"Data synchronization tasks."
"The most valuable features of Informatica MDM are the IDQ and RDM data management."
"In the latest version, I like the outlay of the business roles creation. I like seeing that visualization as you're building it, as opposed to going through metatables or XML mappings. We liked that piece, and it makes it more intuitive for the business."
"The features for data quality, data cataloging, and UI are excellent."
"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."
"It has improved our data integration capabilities​."
"The solution has a free to use community version."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"It's my understanding that the product can scale."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
 

Cons

"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"Once the data is masked, we won't be able to reverse it back to its original value."
"The cost of Informatica MDM is expensive and has room for improvement."
"Inserting the GenAI into the master data management will reduce the overall effort of operational activities."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"A general improvement in icons and the virtual interface would be good."
"We currently have issues with real-time integration."
"There are a small number of UI bugs that occur on occasion."
"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."
"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."
"One thing that I don't like, just a little, is the backward compatibility."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"​I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse​."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"Should provide additional control for the data warehouse"
"If you develop it on MacBook, it'll be quite a hassle."
 

Pricing and Cost Advice

"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"The pricing structure is good, but having to pay for extra drivers to be used in an ICS environment makes me a little nervous."
"Informatica MDM's pricing is not cheap but comparable to other vendors."
"The price is high, but the competitors are even higher, like Collibra."
"The product is highly-priced."
"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."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
"The price is neither too high nor too low."
"The price of the regular version is not reasonable and it should be lower."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."
"There was a cost analysis done and Pentaho did favorably in terms of cost."
"The solution reduced our ETL development time by a lot because a whole project used to take about a month to get done previously. After having Lumada, it took just a week. For a big company in Brazil, it saves a team at least $10,000 a month."
"You don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."
"I primarily work on the Community Version, which is available to use free of charge."
"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
802,829 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
23%
Computer Software Company
14%
Government
7%
Educational Organization
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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

Also Known As

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
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

The Travel Company, Carbonite
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Pentaho Data Integration and Analytics and other solutions. Updated: September 2024.
802,829 professionals have used our research since 2012.