

Pentaho Data Integration and SnapLogic both compete in the data integration and ETL (Extract, Transform, Load) tools category, offering unique features to facilitate data processing. SnapLogic seems to have the upper hand for users seeking rapid connectivity and low-code functionality, while Pentaho shines with its versatility and cost-effectiveness through its Community Edition.
Features: Pentaho Data Integration offers a drag-and-drop functionality that simplifies complex ETL processes, appealing to users with limited programming knowledge. It supports big data technologies and offers numerous integration options. SnapLogic provides a low-code environment with a wide array of connectors, delivering flexible and fast development, along with the ability to quickly create and deploy reusable pipelines.
Room for Improvement: Pentaho could improve by expanding its plugin ecosystem and enhancing support for native data connectors, along with better feedback for debugging and scalability for large datasets. SnapLogic users would benefit from refined debugging and performance optimization for handling large datasets, along with an improved interface that offers better error messaging and comprehensive documentation.
Ease of Deployment and Customer Service: Pentaho provides robust deployment options across both cloud and on-premises environments and is supported by a strong community, though direct customer service for complex issues may fall short. SnapLogic offers flexibility in deployment across cloud and hybrid environments. However, users desire more streamlined customer service and better integration support to maximize resource use.
Pricing and ROI: Pentaho is well-regarded for its cost-effectiveness, especially with the free Community Edition, which aids in significantly lowering development time and costs. SnapLogic delivers value with its scalable and flexible offerings, yet showcases higher initial costs, particularly when extensive functionality or high data throughput is required. Both tools are praised for enhancing ROI by streamlining data processing, thus saving valuable time and effort.
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.
SnapLogic is really helpful and processes in very little time, so it doesn't take much time compared to any legacy tool.
The reports and pipelines run, leading to cost savings that reduce manual effort and save 50,000 to 150,000 USD annually.
It improved our productivity by fifteen percent and shifted work from IT to business users.
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
The responsiveness, technical expertise, knowledge base and documentation, support channels, and continuous improvement were impeccable.
They are providing the best customer support to the organization and the vendors.
I have been very impressed with how responsive they are and how well they take feedback and they value my team's experience.
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.
After implementing SnapLogic, pipelines that processed one to two million records per week can now handle five to 10 million records without additional infrastructure.
That means you can connect any system or application anytime, whether day or night, scheduled or dynamic, and anywhere, whether it is cloud or on-premises.
It supports enterprise-wide integration and has a cloud-native architecture.
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.
I would rate the stability of SnapLogic as nearly ten out of ten.
But recently, in a year, I haven't found many performance issues in SnapLogic.
However, sometimes we see that SnapLogic is unstable during patch releases or Snap Pack releases.
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.
We require a data pipeline that can be read without latency and without any delay.
Having more granular control and deeper insights into execution performance would really help.
IP whitelisting is the area that SnapLogic definitely has to improve.
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.
In terms of setup cost, it is relatively low compared to traditional on-premises tools.
I feel SnapLogic is very expensive compared to others.
There would be only one point of improvement if the price could be lower.
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.
I also like the whole child-parent pipeline feature; it allows me to break up a process into smaller pieces and then have one big pipeline that controls these smaller pipelines.
SnapLogic provides inbuilt Snaplets, such as creating and closing an audit ID, removing duplicates, joining tables, writing to Oracle, files, XML, SF, SMTP connections, and more.
SnapLogic excels in data transformations, monitoring, and observability, providing scalability controls for the pipelines.
| Product | Mindshare (%) |
|---|---|
| Pentaho Data Integration and Analytics | 1.7% |
| SnapLogic | 1.2% |
| Other | 97.1% |

| Company Size | Count |
|---|---|
| Small Business | 18 |
| Midsize Enterprise | 17 |
| Large Enterprise | 32 |
| Company Size | Count |
|---|---|
| Small Business | 12 |
| Midsize Enterprise | 7 |
| Large Enterprise | 18 |
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.
SnapLogic offers a flexible, low-code environment for data integration and automation, utilizing an intuitive drag-and-drop interface with pre-built components to streamline the integration of multiple systems like Salesforce, SAP, and Workday, optimizing workflow automation.
SnapLogic provides robust ETL capabilities and broad connectivity options, enabling custom script implementation. Its visual design supports seamless deployment and efficient error management. Users benefit from automating data flows and enhancing data consistency through API integrations while managing both synchronous and asynchronous processes. However, areas needing improvement include user-friendly integrations, API management, and dashboard functionalities, as well as better transparency and error debugging. There is a call for improved handling of large datasets, enhanced connectivity, and advanced monitoring, DevOps integration, and AI functionalities. Customer support and documentation could be more comprehensive, especially for intricate operations.
What are SnapLogic's key features?In industries like finance, healthcare, and logistics, SnapLogic is extensively implemented for ETL processes, data migration, and automating complex workflows to improve data accuracy and enhance operational efficiency. These capabilities allow organizations to streamline operations and focus on strategic initiatives.
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.