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

Altair Monarch vs Pentaho Data Integration and Analytics comparison

 

Comparison Buyer's Guide

Executive Summary

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

Altair Monarch
Average Rating
9.6
Reviews Sentiment
8.4
Number of Reviews
2
Ranking in other categories
Data Preparation Tools (4th)
Pentaho Data Integration an...
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
53
Ranking in other categories
Data Integration (21st)
 

Mindshare comparison

Altair Monarch and Pentaho Data Integration and Analytics aren’t in the same category and serve different purposes. Altair Monarch is designed for Data Preparation Tools and holds a mindshare of 10.4%, up 8.4% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.6% mindshare, up 0.6% since last year.
Data Preparation Tools
Data Integration
 

Featured Reviews

LS
Transformed document processing has become foolproof with seamless data extraction
Altair Monarch ( /products/altair-monarch-reviews ) is valuable because it allows a one-time setup for data extraction, making the process extremely easy with just a few clicks to get the output. It is foolproof and ensures perfect extraction as long as the models and templates remain standard, providing a seamless and error-free experience.
Aqeel UR Rehman - PeerSpot reviewer
Transform data efficiently with rich features but there's challenges with large datasets
Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

Quotes from Members

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

Pros

"Altair Monarch is valuable because it allows a one-time setup for data extraction, making the process extremely easy with just a few clicks to get the output."
"Monarch lets you quickly extract in your preferred format."
"It's my understanding that the product can scale."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"It has improved our data integration capabilities​."
"It is easy to use, install, and start working with."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"The solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."
"It's very simple compared to other products out there."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
 

Cons

"I rate Altair Monarch seven out of 10 for affordability. Recently, the pricing model changed from end-user licensing to a concurrent licensing model."
"The product needs more plugins."
"The testing and quality could really improve. Every time that there is a major release, we are very nervous about what is going to get broken. We have had a lot of experience with that, as even the latest one was broken. Some basic things get broken. That doesn't look good for Hitachi at all. If there is one place I would advise them to spend some money and do some effort, it is with the quality. It is not that hard to start putting in some unit tests so basic things don't get broken when they do a new release. That just looks horrible, especially for an organization like Hitachi."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"Larger data jobs take more time to execute."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"If you develop it on MacBook, it'll be quite a hassle."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
 

Pricing and Cost Advice

Information not available
"I mostly used the open-source version. I didn't work with a license."
"I think Lumada's price is fair compared to some of the others, like BusinessObjects, which is was the other thing that I used at my previous job. BusinessObject's price was more reasonable before SAP acquired it. They jacked the price up significantly. Oracle's OBIEE tool was also prohibitively expensive."
"I believe the pricing of the solution is more affordable than the competitors"
"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."
"There is a good open source option (Community Edition)​."
"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."
"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."
"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."
report
Use our free recommendation engine to learn which Data Preparation Tools solutions are best for your needs.
853,823 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Retailer
14%
Manufacturing Company
12%
Government
8%
Financial Services Firm
22%
Computer Software Company
14%
Government
7%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for Altair Monarch?
I was not involved in pricing, but I did not encounter any issues with renewals, and the process was always smooth and straightforward.
What is your primary use case for Altair Monarch?
The primary use case of Altair Monarch ( /products/altair-monarch-reviews ) was data extraction. I used it to process a lot of documents and data from Notepad and PDFs, converting those into struct...
What advice do you have for others considering Altair Monarch?
The support team is diligent, following up thoroughly and setting up calls promptly when a ticket is raised. It is beneficial for any assistance needed. The overall rating for Altair Monarch is ten...
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

Monarch Data Pump
Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration
 

Overview

 

Sample Customers

MasterCard
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
Find out what your peers are saying about Alteryx, SAS, Bright Data and others in Data Preparation Tools. Updated: May 2025.
853,823 professionals have used our research since 2012.