Altair Monarch vs Pentaho Data Integration and Analytics comparison

The compared Altair and Hitachi Vantara solutions aren't in the same category. Altair is ranked #4 in DPT , with an average rating of 10.0, and holds a 10.3% mindshare in the category. Hitachi Vantara is ranked #19 in DI , with an average rating of 7.7, and holds a 1.8% mindshare. Additionally, 100% of Altair users are willing to recommend the solution, compared to 94% of Hitachi Vantara users who would recommend it.

Altair Monarch

Read 2 Altair Monarch reviews

397 Views
242 Comparison Views

100% willing to recommend

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,542 Views
1,932 Comparison Views

94% willing to recommend

Altair Monarch

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Altair Monarch and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.

Find out what your peers are saying about Alteryx, Bright Data, SAS and others in Data Preparation Tools.

To learn more, read our detailed Data Preparation Tools Report (Updated: June 2025).

Buyer's Guide

Data Preparation Tools

June 2025

Download the complete report

Helped 862,289 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:

Categories and Ranking

Altair Monarch

Average Rating

9.6

Reviews Sentiment

8.4

Number of Reviews

Ranking in other categories

Data Preparation Tools (4th)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (19th)

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.3%, up 9.5% compared to last year.
Pentaho Data Integration and Analytics, on the other hand, focuses on Data Integration, holds 1.8% mindshare, up 0.8% since last year.

Data Preparation Tools

Data Integration

Featured Reviews

Leo Sundararaj

Account Manager at JegaSure

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.

Read full review

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

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…

Read full review

Quotes from Members

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

Pros

"Monarch lets you quickly extract in your preferred format."

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

"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 is easy to use, install, and start working with."

"We use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."

"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."

"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."

"I find the drag and drop feature in Pentaho Data Integration very useful for integration."

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

More Pentaho Data Integration and Analytics pros

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

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

"I would like to see more improvements with AS400 DB2."

"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."

"I experience difficulties when handling millions of rows, as the data movement from one source to another becomes challenging."

"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."

"The reporting definitely needs improvement. There are a lot of general, basic features that it doesn't have. A simple feature you would expect a reporting tool to have is the ability to search the repository for a report. It doesn't even have that capability. That's been a feature that we've been asking for since the beginning and it hasn't been implemented yet."

"If you develop it on MacBook, it'll be quite a hassle."

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

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

Information not available

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

"There was a cost analysis done and Pentaho did favorably in terms of cost."

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

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"The price of the regular version is not reasonable and it should be lower."

"The cost of these types of solutions are expensive. So, we really appreciate what we get for our money. Though, we don't think of the solution as a top-of-the-line solution or anything like that."

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

More Pentaho Data Integration and Analytics pricing and cost advice

See which vendors are best for you

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

See recommendations

862,289 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Manufacturing Company

12%

Retailer

11%

Healthcare Company

10%

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

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.

See all answers

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

See all answers

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

See all answers

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

See all answers

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

See all answers

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

See all answers

Comparisons

Alteryx vs Altair Monarch

Compared 48% of the time

SAS Enterprise Guide vs Altair Monarch

Compared 33% of the time

ETL Solutions Transformation Manager vs Altair Monarch

Compared 18% of the time

More Altair Monarch Competitors

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

Compared 15% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 9% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 7% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Data Preparation Tools

June 2025

Download Altair Monarch product report

Buyer's Guide

Pentaho Data Integration and Analytics

June 2025

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

Monarch Data Pump

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

Datawatch Monarch is an application that runs on your Windows desktop and as soon as you drop a file or web page onto the canvas it automatically begins to extract into analytics-ready rows and columns. You can also connect to all major relational, big data, and over 30 other sources, but often the most important information you need is locked away in existing reports or difficult sources that seem impossible to use without re-keying the data.

Altair

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

MasterCard

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

Buyer's Guide

Data Preparation Tools

June 2025

Download Free Report

Find out what your peers are saying about Alteryx, Bright Data, SAS and others in Data Preparation Tools. Updated: June 2025.

DOWNLOAD NOW

862,289 professionals have used our research since 2012.

We monitor all Data Preparation Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.