Compare Pentaho Data Integration vs. Talend Cloud Integration

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: June 2021.
511,307 professionals have used our research since 2012.
Quotes From Members

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

Pros
"The solution has a free to use community version.""The amount of data that it loads and processes is good.""Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."

More Pentaho Data Integration 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."

More Talend Cloud Integration Pros »

Cons
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers.""I would like to see improvements made for real-time data processing.""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."

More Pentaho Data Integration Cons »

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

More Talend Cloud Integration Cons »

Pricing and Cost Advice
"The price of the regular version is not reasonable and it should be lower.""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."

More Pentaho Data Integration Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
511,307 professionals have used our research since 2012.
Answers from the Community
RajneeshShukla
author avatarAThiré
User

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 tools
* ERWIN has a nice one ,

author avatarKaroly Krokovay
User

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-hitachi-overview.pdf

And a short description of the community edition: https://www.predictiveanalyticstoday.com/pentaho-community-edition/

And the download link: https://community.hitachivantara.com/s/article/downloads

You can ask more from the great community: https://forums.pentaho.com/

Regards
Károly

author avatarKaroly Krokovay
User

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.

author avatarStefan Schäfer
User

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

author avatarPhil Wilkins (Capgemini)
Consultant

Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution.


The other question is how up to date do you want your OLAP DB to be? Goldengate is a good answer if you're looking to minimize latency, but it can be expensive. ODI is less expensive but better suited to bulkier data sets.  If an Oracle product wasn't the option I'd probably consider something like Informatica.

author avatarRajneeshShukla
Real User

Hi Karoly, Thanks for your input. community: https://forums.pentaho.com/ is not allowing new registrations for new users. I guess they accept queries from customers only and not from any one. Do you know any other forum, community, SMEs contacts who can help on queries?

author avatarRajneeshShukla
Real User

Hi Karoly,

Thanks for your response !!!
Is Pentaho Data Integrator available as freeware/open source tool? Does it come in basic, standard and enterprise editions flavors?

It integrates data from various heterogeneous systems like multiple variety of databases (SQL server, Oracle, DB2 etc), files (XML, XLS, CSV, text etc)? Targets can be any type of DB , file etc.?

What all flavors available like Basic, Standard, Enterprise editions? All editions are free/ open source?

Thanks,
Rajneesh

author avatarRajneeshShukla
Real User

Hi AThire ,
Thanks for your response, I am looking for open source tools.

Regards,
Rajneesh

Questions from the Community
Top Answer: Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition :… more »
Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution. The other question is how up to date do you want your… more »
Top Answer: Pentaho Data Integration is quite simple to learn, and there is a lot of information available online.
Top Answer: 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… more »
Top Answer: In terms of pricing, they have the concept of tokens. They give you a certain number of tokens per license. If you have less tokens, then you will have less servers for execution, and that also ties… more »
Top Answer: In terms of what could be improved, there is not much. It's a basic server setup. It all depends upon what kind of software you want to put on that server. With the remote engine you are building an… more »
Ranking
16th
Views
9,383
Comparisons
7,675
Reviews
3
Average Words per Review
652
Rating
7.7
Views
96
Comparisons
60
Reviews
1
Average Words per Review
1,243
Rating
8.0
Popular Comparisons
Also Known As
Kettle
Talend Integration Cloud, Talend Cloud Remote Engine for AWS
Learn More
Overview

Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.

Talend Integration Cloud (TIC) is a fully-managed cloud option. It provides the great data integration, data quality, and Big Data features from Talend in a cloud environment that is managed, monitored, maintained, and secured by Talend.

Offer
Learn more about Pentaho Data Integration
Learn more about Talend Cloud Integration
Sample Customers
66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute
ACCOR, ADR, L'OREAL, AstraZeneca
Top Industries
REVIEWERS
Government15%
Comms Service Provider15%
Healthcare Company15%
Financial Services Firm15%
VISITORS READING REVIEWS
Computer Software Company28%
Comms Service Provider20%
Financial Services Firm8%
Government7%
No Data Available
Company Size
REVIEWERS
Small Business25%
Midsize Enterprise25%
Large Enterprise50%
No Data Available
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: June 2021.
511,307 professionals have used our research since 2012.

Pentaho Data Integration is ranked 16th in Data Integration Tools with 3 reviews while Talend Cloud Integration is ranked 9th in Integration Platform as a Service (iPaaS) with 1 review. Pentaho Data Integration is rated 7.6, while Talend Cloud Integration is rated 8.0. The top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". On the other hand, the top reviewer of Talend Cloud Integration writes "Very affordable and on par with much more expensive solutions". Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and IBM InfoSphere DataStage, whereas Talend Cloud Integration is most compared with AWS Database Migration Service.

See our list of .

We monitor all Data Integration Tools 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.