Pentaho Data Integration and Analytics vs SAS Viya Platform comparison

Pentaho Data Integration and Analytics vs. SAS Viya Platform

Download the complete report

Helped 894,738 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

Pentaho Data Integration an...

Ranking in Data Integration

7th

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

No ranking in other categories

SAS Viya Platform

Ranking in Data Integration

46th

Average Rating

8.4

Reviews Sentiment

5.4

Number of Reviews

Ranking in other categories

Data Quality (21st), Data Governance (30th), Data Management Platforms (DMP) (8th)

Mindshare comparison

As of May 2026, in the Data Integration category, the mindshare of Pentaho Data Integration and Analytics is 1.7%, up from 1.6% compared to the previous year. The mindshare of SAS Viya Platform is 0.3%. It is calculated based on PeerSpot user engagement data.

Data Integration Mindshare Distribution
Product	Mindshare (%)
Pentaho Data Integration and Analytics	1.7%
SAS Viya Platform	0.3%
Other	98.0%

Data Integration

Featured Reviews

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

Khushal Jdai

Assistant Manager Data Analytics (WFM) at Johari Digital Healthcare Limited

Modern analytics has transformed large data into faster insights and streamlined reporting

There are some areas of improvement I would mention regarding SAS Viya Platform. New users may find it complex initially, as its learning curve can be steep. Understanding CAS and different components is very challenging for a new user. The cost is also quite high; SAS Viya Platform via SaaS can be expensive compared to some open-source or other cloud alternatives. There are also some limitations in Visual Analytics. While it is easy to use, it could be more flexible compared to Power BI or Tableau. These are the main improvement areas where SAS Viya Platform should focus. I would add some additional pointers about needed improvements in SAS Viya Platform. Regarding customer support, it is good, but the response time for complex issues can sometimes be slower than expected. The documentation and learning resources are not very beginner-friendly, making it challenging for beginners to navigate. Regarding integration, it could be smoother with Databricks, Snowflake, and Power BI, but it is more complex than it should be. Since updates are automatic, users are sometimes not fully aware of changes or new features that are being updated, as compared to Power BI, which publishes updates on its website. SAS Viya Platform should work on these aspects.

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

"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."

"Pentaho Data Integration and Analytics positively impacted my organization by organizing data that was scattered across many different databases and APIs, reducing a lot of manual work and centralizing it into one data warehouse."

"When we get a question from our CEO that needs a response and that requires a little bit of legwork of pulling in from various market data, our own in-house repositories, and everything else, it allows me to arrive at the solutions much faster than having to do it through scripting in Python, coding, or anything else."

"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."

"We've seen a 50 percent reduction in our ETL development time using the free version of Pentaho, saving about 1,000 euros per week and at least 50,000 euros annually."

"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."

"When I started doing it and did the migration so that all that ETL process would be done in Pentaho Data Integration and Analytics, I reduced the processing time from two and a half hours per run to seven minutes."

"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."

More Pentaho Data Integration and Analytics pros

"SAS Viya Platform has positively impacted my organization, as previously I was using SAS 9.4, and after migrating to SAS Viya Platform, we are able to present the data in useful ways that save our time and give sponsors a new opportunity to look at the data, which is a very good thing."

"Since starting to work with SAS Viya Platform, the positive impact we have seen includes improvements in distributing data sets for better analytics and machine learning."

"Using SAS Viya Platform, I saw approximately a thirty to forty percent reduction in data processing time due to CAS in-memory computing, and I also reduced manual reporting efforts by approximately forty to fifty percent through automation and self-service dashboards, which definitely saved resources for my organization."

"Eliminating the need for separate visualization tools has greatly affected my team's workflow because it is just one integrated tool, one integrated platform."

"SAS Viya Platform is a great tool for our data analytics purpose, particularly how data profiling stands out compared to other tools impressed me."

"In my experience, the best feature of SAS Viya Platform is that it is very quick in doing the analysis, does the job very quickly and very well without any issues, and I was able to do multiple analyses at the same time."

"SAS Viya Platform is a very advanced platform at the current time, and I recommend using SAS Viya Platform for all data visualization, data analysis, and statistical analysis."

"Using SAS Viya Platform allows my organization to conduct advanced statistical tests, present data in better ways with efficient and good graphical representation, and this helps my company grow more."

More SAS Viya Platform pros

Cons

"One thing that I don't like, just a little, is the backward compatibility."

"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 price of the regular version is not reasonable and it should be lower."

"Some old plugins, after a long time, still doesn’t work properly enough."

"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."

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

"In terms of improvements, while creating on a remote service, we face challenges related to limited memory, which calls for optimization."

"There some steps that should perform better like the json input, but because of the flexibility we at inflow, override it by using scripting steps."

More Pentaho Data Integration and Analytics cons

"I have one complaint about SAS Viya Platform: it offers so many options in each application that someone new who is not familiar with SAS functionality might have trouble, as the learning curve can be very hard for a new learner."

"SAS Viya Platform has a bit of a learning curve. It was not easy to start with."

"I think SAS Viya Platform could be improved as it is a little bit limited; for instance, you have to purchase specific features such as charts and quality control, so it is not a full analytics product."

"On the SAS compute server, the platform sometimes gets stuck or lags, which could be improved in SAS Viya Platform."

"The cost is also quite high; SAS Viya Platform via SaaS can be expensive compared to some open-source or other cloud alternatives."

"I rate it a nine because for a fresher, the platform might not be entirely intuitive."

"I sometimes experienced downtime with SAS Viya Platform, but the SAS support team helped."

"I would advise others looking into using SAS Viya Platform to go ahead if their budget allows."

Pricing and Cost Advice

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

"I primarily work on the Community Version, which is available to use free of charge."

"I mostly used the open-source version. I didn't work with a license."

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

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

"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."

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

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

More Pentaho Data Integration and Analytics pricing and cost advice

Information not available

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

894,738 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

15%

Educational Organization

Government

Manufacturing Company

Construction Company

31%

Manufacturing Company

11%

Healthcare Company

11%

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	31

By reviewers
Company Size	Count
Small Business	2
Midsize Enterprise	5
Large Enterprise	3

Questions from the Community

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

What is your experience regarding pricing and costs for SAS Viya Platform?

My experience with pricing, setup cost, and licensing for SAS Viya Platform was smooth. I did not have any hiccups, and I do not have a say on the pricing.

What needs improvement with SAS Viya Platform?

What is your primary use case for SAS Viya Platform?

My main use cases are data analytics, reporting, and data transformation. It helps in handling large data sets efficiently using CAS, which is an in-memory processing engine. My primary use case is...

Airbyte Cloud vs Pentaho Data Integration and Analytics

Comparisons

Compared 12% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

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

Compared 7% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 6% of the time

StreamSets vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

Informatica Intelligent Data Management Cloud (IDMC) vs SAS Viya Platform

Compared 26% of the time

Palantir Foundry vs SAS Viya Platform

Compared 18% of the time

Microsoft Fabric vs SAS Viya Platform

Compared 14% of the time

SAP Data Services vs SAS Viya Platform

Compared 11% of the time

ASCENDING DevOps Services vs SAS Viya Platform

Compared 11% of the time

More SAS Viya Platform Competitors

Product Reports

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Data Management Platforms (DMP)

Download SAS Viya Platform product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

No data available

Overview

Pentaho Data Integration and Analytics offers an intuitive platform for data workflows, enabling users to easily manage ETL processes across diverse data formats, ensuring seamless automation and development.

With its drag-and-drop interface, Pentaho allows for efficient ETL workflows without extensive coding. It supports a multitude of data formats and sources such as SQL, NoSQL, Hadoop, CSV, and JSON. Advanced features like metadata injection and API integration enable seamless automation. However, improvements in big data performance, better cloud service integration, and enhanced real-time processing capabilities can enhance user experience. Additional connectors and improved documentation are sought after by many. Providing support for more programming languages and optimizing memory usage also presents opportunities for enhancement.

What are the key features of Pentaho Data Integration and Analytics?

Drag-and-Drop Interface: Simplifies building workflows without coding.
Broad Data Support: Accommodates SQL, NoSQL, Hadoop, CSV, and JSON.
Advanced Automation: Leverages metadata injection and API integration.
Cost-Effectiveness: Offers value with comprehensive big data support.

What benefits should be evaluated in Pentaho reviews?

Versatility: Supports both on-premises and cloud solutions.
Data Integration: Facilitates seamless connection of disparate data sources.
Transparency: Enhances data management and reporting.
Scalability: Adapts to the growing data needs of organizations.

Pentaho is employed across finance, healthcare, and retail industries for ETL processes. It's instrumental in integrating data from ERP, SAP systems, Excel, and APIs to develop comprehensive reports and data models. Companies rely on its capabilities for both on-premises and cloud deployments, improving data transparency and management.

Hitachi Vantara

SAS Viya Platform is an advanced data management and analytics tool designed to deliver powerful insights and foster collaboration across teams. It provides flexible and scalable solutions for data analysis, perfect for tech-savvy professionals seeking robust analytics capabilities.

SAS Viya Platform enhances data-driven decisions with its cloud-enabled analytics capabilities. By supporting open-source integration and visual data manipulation, it caters to a diverse range of analytical needs. Its innovative approach to machine learning and AI streamlines operations, helping companies achieve efficient data utilization strategies across departments. Offering robust technical support, it facilitates seamless implementation and rapid adoption, making it ideal for informed analytics exploration.

What are the key features of SAS Viya Platform?

Open Integration: Easily integrates with open-source tools, enhancing adaptability and flexibility.
Scalable Architecture: Designed for easy scalability to accommodate growing data needs.
Machine Learning Capabilities: Offers innovative machine learning tools for enhanced predictive analytics.
Visual Data Exploration: Provides intuitive visual interfaces for comprehensive data analysis.
Robust Security: Ensures data protection with advanced security measures.

What benefits or ROI should users look for in reviews?

Enhanced Efficiency: Increases operational efficiency with streamlined data processes and workflows.
Cost-Effective Scalability: Lowers costs by offering flexible and scalable solutions.
Comprehensive Support: Offers extensive technical support for smooth adoption and use.
Improved Decision-Making: Provides deep insights that inform strategic decisions.
Data-Driven Innovation: Encourages innovative approaches in analytics through powerful tools.

SAS Viya Platform is widely adopted across industries like banking, healthcare, and retail, offering tailored analytics solutions to address industry-specific challenges. In healthcare, for instance, it streamlines patient data insights, while in banking, it optimizes fraud detection processes. In retail, it enhances customer experience analytics, demonstrating its versatile application.

SAS

Sample Customers

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

Information Not Available

Pentaho Data Integration and Analytics vs. SAS Viya Platform