We performed a comparison between Pentaho Data Integration and Analytics and Talend Open Studio based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"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."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"The graphical nature of the development interface is most useful because we've got people with quite mixed skills in the team. We've got some very junior, apprentice-level people, and we've got support analysts who don't have an IT background. It allows us to have quite complicated data flows and embed logic in them. Rather than having to troll through lines and lines of code and try and work out what it's doing, you get a visual representation, which makes it quite easy for people with mixed skills to support and maintain the product. That's one side of it."
"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."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"It's very simple compared to other products out there."
"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The most interesting aspect of the solution for us is that Talend Open Studio has a good balance between the features and the cost of the data management platform."
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"The most valuable feature for me when it comes to this solution is that it's easy to use."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"The most valuable features are definitely data integration, data preparation, and data stewardship."
"The most valuable features of Talend Open Studio are customization and integration."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"Although it is a low-code solution with a graphical interface, often the error messages that you get are of the type that a developer would be happy with. You get a big stack of red text and Java errors displayed on the screen, and less technical people can get intimidated by that. It can be a bit intimidating to get a wall of red error messages displayed. Other graphical tools that are focused at the power user level provide a much more user-friendly experience in dealing with your exceptions and guiding the user into where they've made the mistake."
"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."
"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."
"It could be better integrated with programming languages, like Python and R. Right now, if I want to run a Python code on one of my ETLs, it is a bit difficult to do. It would be great if we have some modules where we could code directly in a Python language. We don't really have a way to run Python code natively."
"If you develop it on MacBook, it'll be quite a hassle."
"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."
"It is complicated to understand the configuration process for email components."
"The high price of the solution is an area of concern where improvements are required."
"The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"The server-side should be completely revamped."
"I rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM."
"I think my biggest problem with the tool is that the errors are very hard to debug."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews while Talend Open Studio is ranked 5th in Data Integration with 47 reviews. Pentaho Data Integration and Analytics is rated 8.0, while Talend Open Studio is rated 8.0. The top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". On the other hand, the top reviewer of Talend Open Studio writes "An open-source ETL tool, when deployed on-premises, requiring an easy installation phase". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Oracle Data Integrator (ODI), AWS Glue and SAP Data Services, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, AWS Glue and Talend Data Management Platform. See our Pentaho Data Integration and Analytics vs. Talend Open Studio report.
See our list of best Data Integration vendors.
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.