

Pentaho Data Integration and Analytics and Alteryx compete in the data integration and analytics category. Despite both offering robust solutions, Alteryx has an upper hand in usability due to its intuitive design and comprehensive customer support.
Features: Pentaho is known for its versatility, a wide range of plugins, and a low-code environment, allowing for seamless integration of various data sets and custom steps. Alteryx excels with its simple drag-and-drop functionality, robust scheduling capabilities, and connectivity to numerous data sources, making it accessible even for non-technical users.
Room for Improvement: Pentaho needs to enhance its performance with large datasets and support for new cloud-native sources. Alteryx could improve its visualization tools, offer a more inclusive pricing structure, enhance server stability, and upgrade its collaboration features.
Ease of Deployment and Customer Service: Pentaho offers flexible deployment from on-premises to cloud but lacks depth in customer support during complex situations. Alteryx provides similar deployment options, exceptional customer service, prompt responses, and a robust community, though it comes with higher costs.
Pricing and ROI: Pentaho’s open-source Community Edition is cost-effective, particularly for small to medium enterprises, offering substantial functionality at minimal expense. In contrast, Alteryx is pricier but offers simplified processes that lead to faster development and higher ROI due to efficient implementation and scalability. However, its high cost may hinder adoption by smaller organizations compared to Pentaho.
Tasks that earlier took hours in Excel or SQL are now completed in minutes.
From a time-saving perspective, we saved 60 to 75 percent of the human workforce needed and eliminated other disparate ETL tools, ultimately saving us over 600,000 dollars.
Alteryx helps familiarize managers with artificial intelligence-driven possibilities.
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.
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.
I have noticed a return on investment with Pentaho Data Integration and Analytics in terms of time savings and staff reduction.
Customer support from Alteryx has been amazing.
they do have a website for resolving doubts and accessing helpful resources, including various tools and filters.
I contacted customer support once or twice, and they were quick to respond.
24/7 assistance is available for the Enterprise Edition.
take the time to understand our business requirements, offering appropriate recommendations.
Communication with the vendor is challenging
Alteryx is scalable for most enterprise analytics and data preparation workloads.
Suggestions for improvements in Alteryx include areas for increasing efficiency, particularly in processing telemetry data, which involves dealing with large volumes of unstructured data.
Alteryx is scalable, and I would give it eight out of ten.
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.
Its ability to scale horizontally in cloud-native architectures or for massive real-time processing is limited.
Pentaho Data Integration handles larger datasets better.
I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
I have not encountered any lagging, crashing, or instability in the system during these three months of usage.
Alteryx is a reliable tool, but it is also very heavy, requiring good laptop configurations, a minimum of 8GB RAM, and a recent processor such as i10.
Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.
I find that version 3.1 is the most stable version I have ever used.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections.
The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system.
The additional features that Alteryx needs to work on to make it more competitive include better collaboration and easier integration through API.
We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.
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.
Pentaho Data Integration and Analytics could have real-time processing and automatic alerting, having alerts or automatic notifications when a job fails or when certain data doesn't meet certain rules.
The price is very high, with licensing typically starting around five thousand dollars plus user per year.
We found excellent use cases for automation through Alteryx, which provided the means to reduce operational costs and streamline the build of ETL pipelines without extensive coding.
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.
The setup cost was minimal, and the pricing experience was pretty good.
The company covered it and they had no problem paying for it because they saw that it was cost-effective in terms of performance afterwards.
Alteryx not only represents data but also supports decision-making by suggesting the next steps.
Analysts who do not have any coding experience can still work on the transformation and preparation of data, which is quite useful.
Alteryx includes built-in tools such as drive time analysis and linear regression, which are much harder to achieve in standard BI tools such as Power BI or Tableau.
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.
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.
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.
| Product | Mindshare (%) |
|---|---|
| Pentaho Data Integration and Analytics | 1.8% |
| Alteryx | 1.2% |
| Other | 97.0% |


| Company Size | Count |
|---|---|
| Small Business | 46 |
| Midsize Enterprise | 20 |
| Large Enterprise | 73 |
| Company Size | Count |
|---|---|
| Small Business | 18 |
| Midsize Enterprise | 17 |
| Large Enterprise | 32 |
Alteryx enhances efficiency by automating data preparation and transformation through a user-friendly drag-and-drop interface, catering to non-technical users and business professionals. It supports data blending, predictive analytics, and diverse data integration capabilities.
Alteryx streamlines data manipulation and complex transformations, benefiting industries such as finance and marketing with its ability to connect to multiple data sources and automate workflows. The platform supports analytics and machine learning model building, reducing manual efforts in ETL processes. Despite its capabilities, improvements are needed in database connectivity, pricing flexibility, and cloud service integration. Users desire enhancements in reporting features, visualization, and technical support to optimize its full potential. Machine learning and predictive analytics features require advancements to improve user experience and broaden accessibility through better connectors and reduced licensing costs.
What are Alteryx's key features?
What benefits and ROI should be looked for in reviews?
In finance and marketing, organizations leverage Alteryx to automate data tasks, connect diverse sources, and generate analytics models and dashboards efficiently. Its no-code approach aids in rapid data preparation, cleansing, and analysis, empowering business users to engage in predictive and prescriptive analytics effectively.
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?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.
We monitor all Data Integration 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.