Pentaho Data Integration and Analytics vs Talend Data Integration comparison

Pentaho Data Integration and Analytics vs. Talend Data Integration

Download the complete report

Helped 850,028 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (22nd)

Talend Data Integration

Average Rating

8.6

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Cloud Data Integration (17th), Integration Platform as a Service (iPaaS) (13th)

Q&A Highlights

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Sep 09, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

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.

Low-code makes development faster than with Python, but there were caching issues

Featured Reviews

Ryan Ferdon

Senior Data Engineer at Burgiss

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 was kind of buggy sometimes. And when we ran the flow, it didn't go from a perceived start to end, node by node. Everything kicked off at once. That meant there were times when it would get ahead of itself and a job would fail. That was not because the job was wrong, but because Pentaho decided to go at everything at once, and something would process before it was supposed to. There were nodes you could add to make sure that, before this node kicks off, all these others have processed, but it was a bit tedious. There were also caching issues, and we had to write code to clear the cache every time we opened the program, because the cache would fill up and it wouldn't run. I don't know how hard that would be for them to fix, or if it was fixed in version 10. Also, the UI is a bit outdated, but I'm more of a fan of function over how something looks. One other thing that would have helped with Pentaho was documentation and support on the internet: how to do things, how to set up. I think there are some sites on how to install it, and Pentaho does have a help repository, but it wasn't always the most useful.

Read full review

AntonioFonseca

Superintendente de TI (CIO) at a insurance company with 201-500 employees

Easy-to-use product with the ability to generate code efficiently

Talend's most valuable feature is its ability to generate code and packages efficiently. This feature streamlines the integration process, saving developers time and effort. Additionally, the stability of the generated code is noteworthy, as it ensures reliability over time. Despite not always producing the most aesthetically pleasing code, it eliminates critical errors, reducing the burden on developers. This stability is particularly crucial in complex integration scenarios, where errors can have significant consequences.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."

"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."

"The solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."

"The product is user-friendly and intuitive"

"I find the drag and drop feature in Pentaho Data Integration very useful for integration."

"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."

"The abstraction is quite good."

"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."

More Pentaho Data Integration and Analytics pros

"I'm very passionate about this solution because if you look at any other tool that costs around $200 - $300,000, like Delphix which costs you a million dollars, Talend is very cheap and is almost is at par with what others can do. There is one thing which Delphix does which Talend cannot do, but overall, I would say apart from that, if you're looking for a solution, you should give it a try."

"We have multiple use cases for this solution. We integrate with Salesforce, SAP and Oracle databases to build business logic and provide reporting."

"The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets."

"Talend's most valuable feature is its ability to generate code and packages efficiently."

"Talend Data integration has a wide library of connectors."

Cons

"One thing that I don't like, just a little, is the backward compatibility."

"If you develop it on MacBook, it'll be quite a hassle."

"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."

"A big problem after deploying something that we do in Lumada is with Git. You get a binary file to do a code review. So, if you need to do a review, you have to take pictures of the screen to show each step. That is the biggest bug if you are using Git."

"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."

"I would like to see more improvements with AS400 DB2."

"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."

"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."

More Pentaho Data Integration and Analytics cons

"The tool's technical support needs to be better. It doesn't have a local data center but pushes everything to the cloud. They need to check in with customers to see if they're happy and how well the solutions work. They need to assign a customer success manager for the accounts they sell."

"Due to using the open-source version of Talend Data Integration, which lacks a scheduler, our current approach involves developing jobs in Talend, exporting them as Java packages, and utilizing an external scheduler, such as Windows Scheduler, to manage the scheduling process."

"The product's setup process could be simpler."

"There are no concurrent licenses, they only have seat licenses on cloud. That's the whole challenge. For example, if in any project your headcount increases or decreases, you do not have that concurrence and you have a seat license, you run into challenges because you have to procure a few more licenses for getting the job done."

"Sometimes there are bugs which are unidentified and we have to follow-up with the Talend team to resolve them. In a critical situation, it takes time for them to update patches."

Pricing and Cost Advice

"The price of the regular version is not reasonable and it should be lower."

"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."

"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."

"I mostly used the open-source version. I didn't work with a license."

"There is a good open source option (Community Edition)."

"There was a cost analysis done and Pentaho did favorably in terms of cost."

"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

More Pentaho Data Integration and Analytics pricing and cost advice

"The product pricing is considered very good, especially compared to other data integration tools in the market."

"I have been using the open-source version."

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

850,028 professionals have used our research since 2012.

Answers from the Community

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Sep 9, 2021

Which ETL tool would you recommend to populate data from OLTP to OLAP?

There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cubes . price approx 40K$, works with tables . Attunity (Bought by Qlik) : technology agnostic , nice web interface , expensive > 100K€. Works with transaction logs There are many other pure ETL ...

2 out of 12 answers

Stefan Schäfer

CEO / Owner with 51-200 employees

Apr 6, 2020

We usually use Talend. Look here: https://community.talend.com/t5/Design-and-Development/The-way-from-OLTP-to-OLAP/td-p/116719

Read full answer

RajneeshShukla

Solution Architect at a tech vendor with 10,001+ employees

Apr 7, 2020

Thanks Stefan !!! May I know if Talend is opensource /free ? It is available in all 3 editions - basic , standard end enterprise? it is capable to read data from all heterogeneous system like various types of data bases and files etc..?

Read full answer

See all 12 answers

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

15%

Government

Manufacturing Company

Computer Software Company

13%

Financial Services Firm

12%

Manufacturing Company

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

What do you like most about Talend Data integration?

The product's integration with PostgreSQL and Jira has been helpful for us. Its performance is good. However, we do not use it for large data sets.

What is your experience regarding pricing and costs for Talend Data integration?

The product pricing is considered very good, especially compared to other data integration tools in the market.

What needs improvement with Talend Data integration?

The product's setup process could be simpler.

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Comparisons

Compared 18% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 13% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 11% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 9% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 7% of the time

More Pentaho Data Integration and Analytics Competitors

SSIS vs Talend Data Integration

Compared 24% of the time

Talend Open Studio vs Talend Data Integration

Compared 24% of the time

SAP Cloud Platform vs Talend Data Integration

Compared 17% of the time

Palantir Foundry vs Talend Data Integration

Compared 11% of the time

Oracle Data Integrator (ODI) vs Talend Data Integration

Compared 10% of the time

More Talend Data Integration Competitors

Product Reports

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics report

Integration Platform as a Service (iPaaS)

Download Talend Data Integration product report

Also Known As

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Talend Cloud Integration, Talend Integration Cloud, Talend Cloud Remote Engine for AWS

Overview

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Talend Data Integration efficiently handles data transformation and integration with ease, supporting complex business needs. It enables seamless data management across all sources.

Talend Data Integration offers a robust platform for managing and transforming data. It connects disparate systems, enabling data flow across various environments. Users benefit from its ability to streamline processes and improve data accuracy. Its user-friendly interface and flexibility make it a preferred choice for data integration experts.

What are the key features of Talend Data Integration?

Data Transformation: Easily transforms diverse data formats to meet specific demands.
Real-time Data Integration: Facilitates immediate data flow for timely decision-making.
Scalability: Supports growing data volumes without compromising performance.
Data Quality Tools: Ensures high-quality data through built-in cleansing and profiling tools.

What benefits should be considered when evaluating Talend Data Integration?

Improved Efficiency: Streamline data processes, reducing time and resource expenditure.
Cost Savings: Minimize manual data handling and associated costs.
Enhanced Accuracy: Benefit from precise data insights due to robust data quality measures.
Flexibility: Cater to diverse data management needs, ensuring future adaptability.

In finance, Talend Data Integration enhances transaction data processing and compliance reporting. In healthcare, it ensures accurate patient data management, while in retail, it optimizes inventory and customer data analysis. Its adaptability makes it valuable across multiple sectors, addressing specific industry requirements.

Talend

Sample Customers

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

ACCOR, ADR, L'OREAL, AstraZeneca

Pentaho Data Integration and Analytics vs. Talend Data Integration