What users are saying about
100 Ratings
100 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101
39 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Add comparison

Likelihood to Recommend

Pentaho

Overall as an OEM vendor of analytics, I would say it was about average. They did help us get to market sooner than if we developed everything in-house, but I felt the dashboards were pretty ugly and I wouldn't say I was super impressed. I found the Analyzer OLAP tool to be very useful and that part would have been harder to develop in-house, but I would skip the dashboards next time and go straight to developing those in-house, which is what we ended up with in the end
No photo available

Talend Open Studio

If you need to design the data flow architecture while working with big data tools, Talend Open Studio is a great way to do so. This is also true for designing data quality checks and monitoring real time data flow. On the other hand, I would not recommend using Talend for handling less volume of data or for performing trivial or fewer data operations.
No photo available

Feature Rating Comparison

BI Standard Reporting

Pentaho
7.0
Talend Open Studio
Pixel Perfect reports
Pentaho
6.8
Talend Open Studio
Customizable dashboards
Pentaho
7.2
Talend Open Studio
Report Formatting Templates
Pentaho
7.0
Talend Open Studio

Ad-hoc Reporting

Pentaho
6.3
Talend Open Studio
Drill-down analysis
Pentaho
7.1
Talend Open Studio
Formatting capabilities
Pentaho
6.7
Talend Open Studio
Integration with R or other statistical packages
Pentaho
6.3
Talend Open Studio
Report sharing and collaboration
Pentaho
5.0
Talend Open Studio

Report Output and Scheduling

Pentaho
6.7
Talend Open Studio
Publish to Web
Pentaho
6.2
Talend Open Studio
Publish to PDF
Pentaho
7.6
Talend Open Studio
Report Versioning
Pentaho
6.6
Talend Open Studio
Report Delivery Scheduling
Pentaho
7.0
Talend Open Studio
Delivery to Remote Servers
Pentaho
6.2
Talend Open Studio

Data Discovery and Visualization

Pentaho
6.2
Talend Open Studio
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.2
Talend Open Studio
Location Analytics / Geographic Visualization
Pentaho
6.6
Talend Open Studio
Predictive Analytics
Pentaho
5.9
Talend Open Studio

Access Control and Security

Pentaho
7.4
Talend Open Studio
Multi-User Support (named login)
Pentaho
7.6
Talend Open Studio
Role-Based Security Model
Pentaho
7.3
Talend Open Studio
Multiple Access Permission Levels (Create, Read, Delete)
Pentaho
7.4
Talend Open Studio
Single Sign-On (SSO)
Pentaho
7.1
Talend Open Studio

Mobile Capabilities

Pentaho
6.2
Talend Open Studio
Responsive Design for Web Access
Pentaho
5.7
Talend Open Studio
Dedicated iOS Application
Pentaho
6.5
Talend Open Studio
Dedicated Android Application
Pentaho
6.5
Talend Open Studio
Dashboard / Report / Visualization Interactivity on Mobile
Pentaho
6.1
Talend Open Studio

Application Program Interfaces (APIs) / Embedding

Pentaho
6.1
Talend Open Studio
REST API
Pentaho
6.8
Talend Open Studio
Javascript API
Pentaho
6.4
Talend Open Studio
iFrames
Pentaho
5.2
Talend Open Studio
Java API
Pentaho
6.0
Talend Open Studio
Themeable User Interface (UI)
Pentaho
5.6
Talend Open Studio
Customizable Platform (Open Source)
Pentaho
6.4
Talend Open Studio

Data Source Connection

Pentaho
Talend Open Studio
9.9
Connect to traditional data sources
Pentaho
Talend Open Studio
10.0
Connecto to Big Data and NoSQL
Pentaho
Talend Open Studio
9.9

Data Transformations

Pentaho
Talend Open Studio
9.5
Simple transformations
Pentaho
Talend Open Studio
10.0
Complex transformations
Pentaho
Talend Open Studio
9.0

Data Modeling

Pentaho
Talend Open Studio
8.7
Data model creation
Pentaho
Talend Open Studio
8.5
Metadata management
Pentaho
Talend Open Studio
9.0
Business rules and workflow
Pentaho
Talend Open Studio
9.3
Collaboration
Pentaho
Talend Open Studio
8.6
Testing and debugging
Pentaho
Talend Open Studio
8.0

Data Governance

Pentaho
Talend Open Studio
9.2
Integration with data quality tools
Pentaho
Talend Open Studio
10.0
Integration with MDM tools
Pentaho
Talend Open Studio
8.4

Pros

  • First thing what I have experienced about Pentaho is that it is user friendly. The best thing about Pentaho is Pentaho Data Integration. I have never used more user friendlier ETL tool like PDI. All the jobs and transformation steps are easy to understand. And I like the sample transformations and jobs that are provided with the package. It is so user friendly that, even if you don't know SQL, it will generate it for you. If you don't want to write scripts, that's fine, you can do it in PDI.
  • I have found that Pentaho can be integrated with any technology or framework. I have easily and successfully integrated it with HDFS, EMR, S3, CouchDB, many different RDBMSs. I would consider it as a strength of Pentaho. Also if you are stuck or you find any error, the type of logging will have an answer for you. I found the logging mechanism very effective.
  • I have mostly used Pentaho Analyzer and Schema Workbench at the BI side. It is user friendly too and we have a very few users who come to the developers to help them understanding the UI of PUC.
Nikhil Karkare profile photo
  • Talend provides pre-built widgets to integrate with databases, web services, and FTP for example, which saves time and quality issues in building basic functionalities that are needed to create a full workflow.
  • Using any tool, such as Talend, encourages a consistent mindset and approach for processing steps, rather than being 100% free-form logic based on the mood of the developer. This makes it easier to understand the workflow that is implemented, even if you are working with many different processes.
  • Using Talend allowed me to work on a project to the point where the client needed to review it, pause development for a week or even 3 weeks if key people were very busy, and to resume work without much trouble at all. If I had been developing without such a tool, my custom code base would have been much larger, and I would have had more difficulty resuming work after such a break.
Mike Blizman profile photo

Cons

  • Most of the companies use star schema in their Data Warehouses but they are not the pure star schemas. There are the bridge tables, group tables but when using Schema Workbench to design a cube, it gets very painful for the developers to accommodate such schema in it. To do this, I have to go to the XML file and add the new elements. I would love to see the feature where Schema Workbench can accommodate the bridge tables as they are the part of star schema too.
  • When it comes to ETL, I have found PDI to be the best tool, but at the report side, it is not as good as the other tools available in the market. Especially the users always complain about the graphs in the Pentaho Analyzer. I think. the UI needs a lot of improvement.
  • PDI is slow reading the JSON files. There is a fast JSON input step available in the marketplace but I think I would be great if Pentaho can make the JSON reading even faster.
  • When I export the repository, I see the files names are encoded with UTF-8 encoding. It would be great, if the spaces and the special characters can be preserved while exporting a BA repository.
Nikhil Karkare profile photo
  • Standard source control practices do not work the way you would expect them to when using Talend. The intermediate items that Talend creates in the workspace are not simply a set of .java files, so you must take extra care of managing your workspace directory. This means you must backup your entire workspace directory prior to upgrading the version of Talend you are using for active development. Granted, we should do this even when upgrading a basic Eclipse environment, but it is far easier to get back where you started if Eclipse gets messed up, than if Talend gets corrupted somehow. This is a key concern for developers, and gaining comfort with this is a matter of time committment to a single tool, which developers are hesitant to commit. There are options to help this in the team and enterprise versions of the tool, but those have their own barriers to adoption, money and agreement across a development team.
  • It could take 2-3 weeks for an seasoned Java developer to gain comfort in how to best implement processes using Talend. It is worth it if you have a lot of projects that start, go on back-burner, then resume, or if you are switching between integration processes and wanting a standard way to build your programs
Mike Blizman profile photo

Likelihood to Renew

Pentaho8.8
Based on 11 answers
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration
Adam O'Connor profile photo
Talend Open Studio10.0
Based on 1 answer
There is no licence requirement for Talend Open Studio. So, this is not relevant question. However, if you are asking whether we will use Talend in future. Yes. We will continue to use it. It's very powerful free tool which caters to all our extra, transform, load capabilities. We just love Talend for it's great functionality and ease of use.
No photo available

Usability

Pentaho5.0
Based on 1 answer
I would have liked some hands on help in trying to match what Customers were already used to. Plus having a team of Java/BI folks was difficult to assemble since what required to be done in an object oriented fashion could have easily been done via a SQL construct. This hash of technologies was difficult to manage.
Deepak Paramanand profile photo
No score
No answers yet
No answers on this topic

Support

Pentaho9.9
Based on 2 answers
They were responsive to our questions when we raised issues.They gave us workarounds when required.They were quite knowledgeable when it came to issue analysis and providing fixes.They were forthright in informing us if a bug was not due for release soon.
Deepak Paramanand profile photo
Talend Open Studio5.0
Based on 1 answer
Talend Open Studio is free and we are not using the enterprise version which comes with licence and support. So, mostly depend on the open source community for any issues that we face. The document is good and we didn't have to use any support so far. We did evaluate the enterprise version and so far sticking to the free version.
No photo available

Online Training

Pentaho9.5
Based on 2 answers
Course Taken: DI1000 Pentaho Data Integration FundamentalsSetup A week before your class started, the instructor will start sending out class material and lab setup instructions. This is helpful so that you understand how the environment is laid out and can start reviewing the content. Ultimately it saved about a 1/2 day trying to setup with 10 other people online which was great! The CourseThe 3-day course was laid out like many other technical classes with 15-30 minutes instruction and 15-60 minutes of lab exercises. The instructor was very knowledgeable with the functionality from version to version and answered questions as we went along. I was amazed at some of the functionality that was available that I was not using at the time and quickly implemented changes to many existing transformations and jobs. The novice users seemed to catch on quickly and more experienced users explained how some of the functionality was used in their home environments. Towards the end there was enough time so that we were able to ask very directed questions about our own environments. Overall, I really found the class to be informative and deliver enough information to be dangerous. My skills improved and I was able to design better and efficient transformations for the HIE. Course Description: https://training.pentaho.com/instructor-led-training/pentaho-data-integration-fundamentals-di1000
Stephanie Dozier profile photo
No score
No answers yet
No answers on this topic

Implementation

Pentaho5.0
Based on 1 answer
Get the right people in before starting implementation. Start small and build as you go approach is time consuming and involves lot of rework.Evangalize within the organization the capabilities and limitations equally so that correct delivery expectations are set.Set expectations with the Customer that the tool cannot replace proprietary software in terms of stability/usability and that timelines could change given the new ness of the product.
Deepak Paramanand profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

In a past life I have used Business Objects which is a great product but requires an army of people to support. Pentaho can be managed by a smaller team of developers because you don't have to have expertise in Universe design, Report design and ETL. Pentaho's interfaces allow for a quick ramp up of the software and support all three areas pretty easily
Stephanie Dozier profile photo
It solved my specific problem of needing a standard way to integrate with databases, web services and file transfers. The price is right (free). And the tool has been very stable in my experience.
Mike Blizman profile photo

Return on Investment

  • Good client feedback - caters to specific requirements
  • Low learning curve for new staff
  • Good community backup
No photo available
  • I delivered projects the client did not believe were possible, and I provided intermediate value by providing visibility to hidden data problems in their systems they could not detect before.
  • I was able to work 3 projects at a time, pausing gracefully in one while switching to the other, with minimal effort.
Mike Blizman profile photo

Pricing Details

Pentaho

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Talend Open Studio

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details