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."The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."
"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."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"The most valuable features are the ETL tools."
"The data integration aspect of the solution is excellent."
"Talend can connect to multiple data sources, including relational data sources, ERP, CRM, and others."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"Talend Studio has the ability to use it to ensure data quality."
"The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
"The most valuable features of Talend Open Studio are customization and integration."
"The standout feature for me is the user-friendly nature of the components."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"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."
"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."
"The product needs more plugins."
"One thing that I don't like, just a little, is the backward compatibility."
"I would like to see more improvements with AS400 DB2."
"The performance could be improved. If they could have analytics perform well on large volumes, that would be a big deal for our products."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"We need more components to be more efficient. We use a lot of components, such as Salesforce, and it's not easy to use. There's are minor bugs and it's not easy to use some of the features."
"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."
"If I compare Open Studion to other solutions, their interface is robust but not so fancy looking. This is an area that could use improvement. I would like to see an updated interface."
"In the next release, Open Studio should include cloud storage as an input."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
"Inter-version compatibility is a problem, and migration projects between versions are required."
"It is not as visually appealing as some of the other tools."
"The product could be more intuitive."
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.