2015-08-28T12:15:00Z

Which one is best for ETL - Pentaho or Jaspersoft?

it_user301281 - PeerSpot reviewer
  • 91
  • 312
PeerSpot user
46

46 Answers

it_user210156 - PeerSpot reviewer
Vendor
2015-09-15T13:18:05Z
Sep 15, 2015

I personally use Talend for Data Integration and ETL on a daily basis. It is versatile and Jaspersoft uses it in their 3rd-party product for ETL called JaspersoftETL.

There are free versions of Talend products, called "Open Studio," as well as Enterprise versions. Talend Open Studio is their ETL tool and Talend Data Quality is their cleansing data product. What is really nice about the Open Studio products are the many data connecting components and the ease of use in doing data integration.

https://www.talend.com/products/talend-open-studio

Hope this helps.

Thank you,
Christopher Hafer

Search for a product comparison in BI (Business Intelligence) Tools
it_user9345 - PeerSpot reviewer
Consultant
2015-09-16T08:23:15Z
Sep 16, 2015

Hi,

As already mentioned by others Jaspersoft uses a version of Talend and call it Jaspersoft ETL. The version is an older version normally than is available from Talend itself. I would suggest using the latest version of Talend itself.

There are two versions, TOS (Talend Open Studio) and the Commercial versions.

TOS is free and also in different versions like DI (Data Integration) and MDM (Meta Data Management). The last one includes the possibilities of DI (ETL) but also Data Profiling where you can monitor the quality of your data.

Talend has several versions and the Commercial versions have as benefit the integration and sharing between the versions and also scheduling and monitoring of jobs included which is real neat.

So for starting the best is to take TOS MDM get to know it and how to use it. If you are going for real professional use in production I would suggest to take the commercial versions because it save you a lot on management and development on scheduling and monitoring of jobs.

I am currently working with TOS MDM, and also have worked with TOS DI in combination with Jaspersoft Server, because we already have the management and monitoring arranged in another way and is out of my scope.

Kind regards,
Patrick

it_user6978 - PeerSpot reviewer
Consultant
2015-09-15T13:27:28Z
Sep 15, 2015

Jaspersoft is having tieup with talend. With jaspersoft commercial version they provide talend. Hence if you plan to use jaspersoft it would be more recommended to use talend rather than kettle.

it_user196212 - PeerSpot reviewer
Vendor
2015-09-15T11:58:42Z
Sep 15, 2015

I have limited knowledge of Jaspersoft, from my research it is primarily a visualization tool and it does not have the back end cleansing capabilities that Pentaho offers. If you need to clean up your data, I think Pentaho is the better of these options.

it_user172275 - PeerSpot reviewer
Consultant
2015-09-21T21:17:23Z
Sep 21, 2015

Hi,
I've used all tools that other persons have spoken above, but if you really want an integrated open source tool, you have to use pentaho. Infact with it you can:
- read data
- clean data
- present it, in olap analisys or flat mode
so without try to integrate different software (talend, jasper and so on) you can choose a already integrated platform with 0 integration cost

it_user93840 - PeerSpot reviewer
Vendor
2015-09-17T17:22:40Z
Sep 17, 2015

In general, Jaspersoft has more of a focus on reporting and analysis and Pentaho is much better at data integration, ETL and workflow. My experience with Jaspersoft is that it uses Talend whereas Pentaho uses Pentaho Data Integrator (Kettle). Kettle was developed by Pentaho. Jaspersoft uses Talend Open Studio but has some missing functionality.

Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools. Updated: March 2024.
765,386 professionals have used our research since 2012.
it_user313905 - PeerSpot reviewer
Vendor
2015-09-17T12:13:42Z
Sep 17, 2015

Pentaho definitely offers stronger data cleansing \ preparation when compared to Jaspersoft, but then you've got the frustration of having to get both Pentaho and Jasper iReport to speak the same language every time you add an additional dataset. Neither of these possibilities is a good solution for really messy data.

Are you limited only to those two tools? I have had some good experience with Sisense's cube features for data preparation, and then you have all the visualization and dashboard features in the same platform. Otherwise I would look into DW as suggested by others.

it_user237879 - PeerSpot reviewer
Real User
2015-09-16T15:09:27Z
Sep 16, 2015

Both JasperETL and Pentaho Kettle can help you clean and prepare your data for reporting. Since you plan on using Jaspersoft for creating the reports you'd be better off using JasperETL. Two reasons for that; if later on you decide to upgrade to a commercial version of Jaspersoft you'd simply import the ETL jobs into the enterprise edition and take advantage of the additional features. Additionally there are plug-ins for JasperETL that can be helpful for reporting. One last tip: try Jaspersoft Studio it has replaced iReport with a lot more functionality while backwards compatible with iReport created jrxmls.

it_user312993 - PeerSpot reviewer
Vendor
2015-09-16T11:41:08Z
Sep 16, 2015

according to my view Pentaho is good for data integration or etl

it_user198027 - PeerSpot reviewer
Vendor
2015-09-16T05:54:43Z
Sep 16, 2015

Dear Ariel,

Hello.

We had not used Jaspersoft or Pentaho before. However based on brief reading on Gartner BI magic quadrant report, it sounds like Pentaho could better.

Again it is much dependent on which part of the data needs to be cleaned (e.g. misspelling of name vs. dates), and the nature of data cleaning process (names formatting vs date formatting) needs to be done.

Alternatively your colleague can also try QlikView, which has basic ETL functionalities and QlikView is a magic quadrant leader.

A perpetually free QlikView personal edition for desktop license can be downloaded and used from http://www.qlik.com/us/explore/products/free-download?ga-link=hero

Warm regards,

Teoh Sin Hin

it_user279618 - PeerSpot reviewer
Real User
2015-09-16T05:45:16Z
Sep 16, 2015

I recommend to use Talend Open Studio as it is tied up with Jaspersoft.

it_user241098 - PeerSpot reviewer
Consultant
2015-09-16T04:19:43Z
Sep 16, 2015

I have not used Jaspersoft to comment on it.

Pentaho Kettle is a good ETL tool and open source too. Learning curve is
small and has a GUI IDE. Kettle is written in Java.

At a generic level, for ETL selection
a. What is the volume of data?
b. Complexity of the transformation needed?
c. Performance of the overall system
d. Format of data (Pentaho Kettle is good to support all the 4 pretty
well)

Hope this helps.

Good luck

Prashanth

it_user125031 - PeerSpot reviewer
Consultant
2015-09-16T00:57:07Z
Sep 16, 2015

Hi there,

I have no experience on Jaspersoft, but with Pentaho Spoon I can have my job done. With a couple of hours learning, I can start to author my own transformation. If your job is staight-forward and relatively simple, you can definitely use Pentaho. I am not sure about more complex jobs. FYI.

Jerry

it_user2226 - PeerSpot reviewer
Vendor
2015-09-16T00:13:11Z
Sep 16, 2015

The data cleansing capability of the two products is very comparable. But it really depends on the volume of data and the time allowed to clean and load the data.. I would not suggest either product for large data volumes

it_user176847 - PeerSpot reviewer
Consultant
2015-09-15T19:59:30Z
Sep 15, 2015

It is better to use Pentaho for unstructured big data ETLs but both tool should be sufficient for data cleanup.

it_user70458 - PeerSpot reviewer
Vendor
2015-09-15T18:46:48Z
Sep 15, 2015

Neither really specialize in data cleansing. Data cleansing is as much a process as it is a technology. Depending on the size of your dataset, Excel can be a powerful tool in the identification of the "unclean" data. From there you will want to set up a process around making sure your data either conforms to your cleanliness standard from the source (fix it before it is a problem) or make filtering out unclean data part of an ETL process that is invoked on it's way to your reports.
I would venture that Pentaho (Kettle) would have a more mature set of tools that could assist you in your quest. Either way, you will need a detailed understanding of your source data.

it_user224418 - PeerSpot reviewer
Consultant
2015-09-15T18:36:50Z
Sep 15, 2015

My vote goes to Jaspersoft. Here are my thoughts.

Community support is more in Jaspersoft as compared to Pentaho. Also, the
community members are more active of Jaspersoft community, hence if you are
using CE, the chances of problem resolution is much more.

Jaspesoft uses R. R is more advanced and more capable in Predictive
analysis.

Jaspersoft scores higher than Pentaho in Mobile BI compatibility. They have
BI for iOS, Android platforms. Functionality wise and user interface wise
Jaspersoft mobile BI is better. They even have an opensouce Apple iphone
application. Pentaho users have to often rely on third party tools to
enhance mobile BI experience.

Summarizing Jasper has a heavy focus on reporting and analysis. It has a
better web 2.0 user interface than Pentaho and is generally easier to use.
It benefits from better marketing, informational web sites, and
documentation. Overall, it makes researching and finding what users need
easier than Pentaho. Whereas Pentaho focuses on data integration, ETL, and
workflow automation. It has a user interface that is more difficult for
business users than is Jasper’s.

Hope this helps.

For any additional information, revert to me please.

Thanks
Gary

it_user271512 - PeerSpot reviewer
Consultant
2015-09-15T18:03:57Z
Sep 15, 2015

Hello,

For cleaning the data the ETL of pentaho works like a charm, this is the better way to go.

As we are using Pentaho (community edition) for ETL jobs, we used this also for building reports.

Jasper reports is easier to integrate in an other software from a developpers point, But the pentaho report it self

are OK and easy to use.

Regards,

Eric Smets

it_user79230 - PeerSpot reviewer
Vendor
2015-09-15T16:51:36Z
Sep 15, 2015

Pentaho is going to be much better for ETL especially if dealing with any sort of big data. Their Pentaho Data Integration (PDI) tool is solid. They also have a reporting tool.

it_user312354 - PeerSpot reviewer
Consultant
2015-09-15T16:06:09Z
Sep 15, 2015

I don't use any of them. I use Microsoft SSIS. Regards

it_user128742 - PeerSpot reviewer
Vendor
2015-09-15T15:15:11Z
Sep 15, 2015

If it's just a matter of cleaning up data to output (regardless of the
reporting system), then it mainly depends on whether you are comparing the
community version or subscription version. I think Pentaho is stronger in
the community version while Jaspersoft is stronger is the subscription
version.

Since you are looking to design reports using iReport (Jaspersoft), I would
lean towards using Jaspersoft to clean the data. The outputs of the cleanup
process will line up nicely with the inputs for iReport.

Ben Inkster

it_user145740 - PeerSpot reviewer
Real User
2015-09-15T14:36:29Z
Sep 15, 2015

Only have background in Pentaho usage so can’t speak to how easy Jaspersoft is to use, however, I have to say Pentaho DI is excellent and is one of the most straightforward ETL tools I’ve seen in 15 years of working in BI. It is an extremely user friendly interface and has an impressive and passionate user community who can help you if you get stuck, as well as excellent documentation on how to do things. I’d thoroughly recommend using Pentaho DI

Gareth P Crawshaw | BIS Technical Analyst | Equifax UK

it_user134691 - PeerSpot reviewer
Consultant
2015-09-15T14:27:20Z
Sep 15, 2015

You report design and generation tools are not generally ideally
suited for ETL purpose. Depending on the complexity of data and
volume, you can choose one of the leading ETL tools in the market.
There are some Open Source system based ETL tools are also available.
Please check it under Eclipse platform. Otherwise I would recommend
one of these tools: Informatica MDM / Power Center, MS SQL Data
Extractor, SAP Data Integrator or Oracle Warehouse Builder. You may
also choose to write your own script and PL/SQL if the cleansing does
not have much challenges and straightforward.

it_user244644 - PeerSpot reviewer
Real User
2015-09-15T14:05:39Z
Sep 15, 2015

Here you go..

Jaspersoft has moved on now and the latest version of iReport is called
Jaspersoft Studio, an IDE based on Eclipse. Jaspersoft ETL is not a bolt-on
ETL tool likes Pentaho's, it is an OEM of the Talend Data Integration
Product. Talend is an all-encompassing ETL tool which not only allows you
to bring data from virtually anywhere (including Google Analytics,
Salesforce, SAP etc) but the intuitive workflow designer makes it easy to
get up and running. The deployment of completed workflows can only be
described as a breeze and its worth downloading and having a play ..
"Seeing is Believing".

Pentaho, on the other hand, primarily (I think) is a BI Company and
therefore as a consequence its ETL tool does not stack up to the Jaspersoft
Offering. But like all these things the proof is in the pudding ..

I hope that helps!

Will

it_user248349 - PeerSpot reviewer
Consultant
2015-09-15T13:55:55Z
Sep 15, 2015

Ideally, you use an ETL tool like Talend or SSIS (SQL Server Integration Services), because they are specialized tools for data processing. But between the two tools mentioned, the Pentaho is simpler than the Jaspersoft.

AM
Real User
2015-09-15T13:42:51Z
Sep 15, 2015

Hello Ariel!
Sorry. Not familiar enough with those tools.
Have a nice day!

On 15/09/15 06:46, Ariel Lindenfeld - Community Manager at IT Central

it_user92601 - PeerSpot reviewer
Vendor
2015-09-15T13:38:29Z
Sep 15, 2015

JasperSoft unlike Pentaho does not have its own ETL tool. It bundles Talend
Studio.
As for Talend vs Pentaho ETL (Kettle), Kettle is more intuitive (easier to
start), but less feature-rich. Kettle is better integrated with Pentaho
than Talend with JasperSoft.
One can find a lot of comparisons like this:
http://www.robertomarchetto.com/talend_studio_vs_kettle_pentao_pdi_comparison

it_user183696 - PeerSpot reviewer
Vendor
2015-09-15T13:18:03Z
Sep 15, 2015

Dear Sir,

You can use Crystal Reports for Java. It have reach UI and more options as Drill Down, Hyperlink etc.

Thanks

it_user222765 - PeerSpot reviewer
Consultant
2015-09-15T13:17:24Z
Sep 15, 2015

Pentaho is good
It open source but it needs trining
Kind Regards
Dr. Saudi A. Baset
IT Advisor
Tel +2010-1621778

--------------------------------------------

it_user268902 - PeerSpot reviewer
Vendor
2015-09-15T13:13:22Z
Sep 15, 2015

I had used Talend and is quite easy to learn and to make complex process with files or data, Even Big Data. if you wanna start to develop I recommened Talend because learning curve. it´s faster to understand.

it_user216504 - PeerSpot reviewer
Vendor
2015-09-15T13:10:55Z
Sep 15, 2015

Hi,
Actually we have been using Pentaho ETL and we are quite satisfied with this. We wouldn’t have the minimum hesitation to use in even in complex projects.
As per Jasper, even if we are aware of it we haven’t used it yet; however, if the front end is from Jasper as well, I would consider using it first.
I hope I as kind of helpful.

it_user72435 - PeerSpot reviewer
Real User
2015-09-15T13:00:24Z
Sep 15, 2015

I have never worked with nor seen Pentaho, but Jaspersoft is for embedding analytics/reports within applications predominantly in a Java application framework. I don't believe it has any "clean the data first" capabilities, which is more of a data quality/ETL requirement.

it_user75312 - PeerSpot reviewer
Vendor
2015-09-15T12:56:18Z
Sep 15, 2015

I would rather use Pentaho, but I may be biased because I have been using
it for such a long time now.

it_user307752 - PeerSpot reviewer
Consultant
2015-09-15T12:54:41Z
Sep 15, 2015

If i would start a new Integration/ETL project today with an open source tool, I will use Talend DI, for sure.

it_user217470 - PeerSpot reviewer
Vendor
2015-09-15T12:48:51Z
Sep 15, 2015

Jaspersoft is strict reporting tool, has no ETL capability. Pentaho has some ETL capabilities, but out of my experience I Will always use Talend DI.

it_user307752 - PeerSpot reviewer
Consultant
2015-09-15T12:40:12Z
Sep 15, 2015

Hello,
Like Bruce said, Jaspersoft is a visualization tool, I does not apply for cleasing and transformation. If your need is to clean and transform your data first and you need an open source solution, two ETL tools there are very used are Talend and Pentaho, in my experience I recommend you the first one.

it_user194127 - PeerSpot reviewer
Consultant
2015-09-15T12:39:31Z
Sep 15, 2015

use Jaspersoft , easy integration and reporting is also easy.if you are going for datawarehouse and needs faster execution go for Netezza DB , ETL Data stage / Informatica(MDM serves your purpose of data cleaning, clensing). for reporting can use MSTR/Cognos/Tableau.SSRS/SSIS also serves your purpose.

it_user8199 - PeerSpot reviewer
Real User
2015-09-15T12:27:48Z
Sep 15, 2015

I would prefer Jaspersoft over pentaho for reporting.

I prefer pentaho over jaspersoft for creating dashboards..

Both the tools are community not enterprise.

Thanks,
Sadakar

it_user111504 - PeerSpot reviewer
Vendor
2015-09-15T12:19:38Z
Sep 15, 2015

Makes no difference really from a design and report point of view.

They both are created from the Kettle codebase however Pentaho with its
latest release is revamping its data ingestion solutions so its ahead of
the curve against Jasper ETL.

If you already paid for the full Jasper licences then its a no brainer to
use Jasper toolkit.

REgards

it_user68871 - PeerSpot reviewer
Consultant
2015-09-15T12:15:07Z
Sep 15, 2015

Pentaho. Performance wise and adaptability to existing architecture. Datacleaning is easy

Vendor
2015-09-15T12:08:24Z
Sep 15, 2015

Hello Ariel,

Pentaho is a more complete suite.

it_user146334 - PeerSpot reviewer
Vendor
2015-09-15T12:06:06Z
Sep 15, 2015

Hi,

using Pentaho Spoon for ETL, easy to use with a lot of features for clean
and transform your data from source to target.

Regards,

Yusuf Fachruddin

it_user252963 - PeerSpot reviewer
Vendor
2015-09-15T12:02:13Z
Sep 15, 2015

I've used Talend ETL in the past (Which is what's included in Jaspersoft
package as an ETL tool). Attempted pentaho in the past but for a few
reasons it didn't work out. Talend is buggy at times but handles small to
medium volumes well.

it_user221295 - PeerSpot reviewer
Consultant
2015-09-15T11:57:15Z
Sep 15, 2015

Pentaho has more data integration and analytics options, however it also depends what budget you have for your task in hand.

Regards,

Haroon Sarfraz Janjua

Project Manager

it_user268125 - PeerSpot reviewer
Vendor
2015-09-15T11:48:14Z
Sep 15, 2015

Hello,

For ETL, I would suggest using Pentaho as it does have some advantages over Jaspersoft.

Regards,

Mohammad Aamer

BI Functional Consultant

it_user271512 - PeerSpot reviewer
Consultant
2015-09-15T11:42:16Z
Sep 15, 2015

Hello,

For cleaning the data the ETL of pentaho works like a charm, this is the
better way to go.

As we are using Pentaho (community edition) for ETL jobs, we used this also
for building reports.

Jasper reports is easier to integrate in an other software from a
developpers point, But the pentaho report it self

are OK and easy to use.

Regards,

Eric Smets

BI (Business Intelligence) Tools
Business intelligence (BI) successfully combines business history and software to interpret data to analyze a business’s footprint and create action plans for success in the future. Business intelligence will look at the effects of various business decisions and summarize those effects in easy-to-understand reports, graphs, charts, and summaries.
Download BI (Business Intelligence) Tools ReportRead more

Related Q&As

BI (Business Intelligence) Tools experts

Mir Gulzar Ahmed - PeerSpot reviewer
Syed Fahad Anwar - PeerSpot reviewer
Joyee Sen - PeerSpot reviewer
ChristopherOrilogbon - PeerSpot reviewer
Kishor Lamdande - PeerSpot reviewer
Kevin McAllister - PeerSpot reviewer
AhmedHaridy - PeerSpot reviewer
Yogesh Kumar Mali - PeerSpot reviewer