Sep 09, 2021
We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.
Pentaho Data Integration and Analytics and Qlik Talend Cloud are competitors in the data integration and analytics sector. Pentaho has the edge due to its cost-effectiveness and ease of use, while Qlik Talend Cloud excels in integration flexibility and data quality features.
Features: Pentaho Data Integration and Analytics is recognized for its intuitive drag-and-drop interface, extensive support for big data technologies, and the ability to perform rapid prototyping. The open-source nature provides broad connectivity and versatility for various data sources. Qlik Talend Cloud offers robust data quality tools and a wide array of connectors that facilitate extensive integration possibilities. The platform is built on Java, allowing for customization and complex data processing capabilities.
Room for Improvement: Pentaho needs to enhance its native connectors for popular cloud platforms and improve debugging capabilities. There is also a need for better performance management on extensive datasets and improved support for complex data environments. Users of Qlik Talend Cloud suggest the need for reduced licensing costs, more comprehensive dashboarding options, and enhanced real-time processing capabilities.
Ease of Deployment and Customer Service: Pentaho supports flexible deployment in hybrid and on-premises environments, though its support services receive mixed reviews. A proactive community backs the community edition. Qlik Talend Cloud can be deployed in multi-cloud settings but often faces criticism regarding pricing and setup. Service and support focus on flexibility and innovation but receive mixed feedback, particularly about response times.
Pricing and ROI: Pentaho Data Integration and Analytics is particularly appreciated for its affordability and open-source model, offering excellent ROI with low-cost implementations. In contrast, Qlik Talend Cloud is considered more expensive but provides significant integration capabilities and advanced features, justifying its cost for businesses prioritizing integration and data quality.
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.
It has helped us save a lot of time by automating repetitive data processes and reducing manual interventions.
We achieved around 20% to 30% time savings in the ETL process, reduced operational errors, and improved pipeline stability.
We actually achieved the first 18 months worth of work in the first six months.
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 support team is responsive when we raise issues, and they usually provide clear guidance or solutions.
I would rate the technical support from Talend Data Quality as an 8 or 9.
The customer support for Talend Data Integration is very good; whenever I raise a ticket in the customer portal, I immediately receive an email, and follow-up communication is prompt.
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.
By using features like job parallelization and modular design, we can expand our data flows without having to rebuild everything.
Its scalability is good, as Qlik Talend Cloud can handle large amounts of data and grow as needed, especially in cloud environments.
We've set up alerts, so if we have an increasing volume and so on, it's up to us to increase CPU, increase RAM, and all those details.
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.
We have not encountered many issues with remote engines, and the interfaces are properly developed.
Once the jobs are properly designed and deployed, they run reliably without major issues.
It was not as stable when we were using TAC and on-premise systems, but currently, with Qlik Talend Cloud version 8.3 or 8.1, it is stable.
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.
On the flip side, that is one of its amazing strengths, as you are not locked into a very rigid way of doing something.
Better cost and resource visibility would help teams optimize their workloads.
It would be great to have more ready-to-use connectors for modern cloud and SaaS platforms.
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.
The setup cost is very expensive.
My experience with Talend Data Integration's pricing, setup cost, and licensing is that it is a bit higher compared to other tools, making it not very affordable.
The license cost has increased significantly, leading many companies to seek more profitable options in the market.
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.
By automating daily data loading processes, we reduced manual effort by around three or four hours per day, which saved roughly 60 to 80 hours per month.
We perform profiling prior to data quality and post-data quality, and based on that, we determine how much it has improved to measure the efficiency of Talend Data Quality cleaning tools.
The feature that has made the biggest difference for me in Qlik Talend Cloud is the scheduling and automation, which helps me run ETL jobs automatically without manual work.
| Product | Mindshare (%) |
|---|---|
| Qlik Talend Cloud | 2.4% |
| Pentaho Data Integration and Analytics | 1.7% |
| Other | 95.9% |
| Company Size | Count |
|---|---|
| Small Business | 18 |
| Midsize Enterprise | 17 |
| Large Enterprise | 32 |
| Company Size | Count |
|---|---|
| Small Business | 21 |
| Midsize Enterprise | 12 |
| Large Enterprise | 20 |
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.
Qlik Talend Cloud provides robust data integration tools tailored for efficient management of large volumes, offering real-time data access, Java integration, and custom code capabilities for developers.
Qlik Talend Cloud is known for its extensive connectivity options, enabling seamless integration across different platforms, such as S3, Redshift, Oracle, and SQL Server. The central repository facilitates consistent metadata access throughout organizations, enhancing collaboration. Despite its strengths in advanced monitoring, automation, and user-friendly drag-and-drop interfaces, users face challenges with installation stability, technical support, documentation inconsistencies, and complexities in learning. Performance concerns also include multitasking limitations and excessive memory usage. The platform's licensing costs can be prohibitive for smaller companies, while demands for improved data governance and intuitive code management continue. Its applications in healthcare data parsing, ETL task automation, and diverse data platform integration demonstrate its utility, although there's a constant demand for better scalability and efficient transformations.
What are the key features?In specialized industries like healthcare, users leverage Qlik Talend Cloud for data integration and transformation, aiding in compliance and analytics. Compatibility with cloud and on-premises systems ensures adaptability to complex data tasks, facilitating business application development. Organizations focus on enhanced data ingestion and quality checks for comprehensive solutions.
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.
