What users are saying about

Pentaho

100 Ratings

Pentaho

100 Ratings
Score 7.5 out of 101

Talend Open Studio

38 Ratings
Score 8.4 out of 101

Add comparison

Likelihood to Recommend

Pentaho

Pentaho will work great to embed analytic content with full features of Machine Learning capabilities. It supports many machine-learning frameworks and can be easily integrated. So, you also can connect with many data sources and have no worries about it. In our case, we are using it to help us create many day-to-day jobs and transformations that our internal users need. But to achieve this, we need to train our team to be able to understand the main concepts of how this software works.
Ilham AB profile photo

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
6.7
Talend Open Studio
Pixel Perfect reports
Pentaho
6.5
Talend Open Studio
Customizable dashboards
Pentaho
6.9
Talend Open Studio
Report Formatting Templates
Pentaho
6.8
Talend Open Studio

Ad-hoc Reporting

Pentaho
6.2
Talend Open Studio
Drill-down analysis
Pentaho
7.1
Talend Open Studio
Formatting capabilities
Pentaho
6.6
Talend Open Studio
Integration with R or other statistical packages
Pentaho
6.2
Talend Open Studio
Report sharing and collaboration
Pentaho
4.9
Talend Open Studio

Report Output and Scheduling

Pentaho
6.6
Talend Open Studio
Publish to Web
Pentaho
6.2
Talend Open Studio
Publish to PDF
Pentaho
7.4
Talend Open Studio
Report Versioning
Pentaho
6.5
Talend Open Studio
Report Delivery Scheduling
Pentaho
6.9
Talend Open Studio
Delivery to Remote Servers
Pentaho
6.1
Talend Open Studio

Data Discovery and Visualization

Pentaho
6.1
Talend Open Studio
Pre-built visualization formats (heatmaps, scatter plots etc.)
Pentaho
6.1
Talend Open Studio
Location Analytics / Geographic Visualization
Pentaho
6.4
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.5
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.2
Talend Open Studio

Mobile Capabilities

Pentaho
6.1
Talend Open Studio
Responsive Design for Web Access
Pentaho
5.4
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
5.9
Talend Open Studio

Application Program Interfaces (APIs) / Embedding

Pentaho
6.0
Talend Open Studio
REST API
Pentaho
6.7
Talend Open Studio
Javascript API
Pentaho
6.3
Talend Open Studio
iFrames
Pentaho
5.0
Talend Open Studio
Java API
Pentaho
5.9
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
9.9
Connecto to Big Data and NoSQL
Pentaho
Talend Open Studio
9.8

Data Transformations

Pentaho
Talend Open Studio
9.7
Simple transformations
Pentaho
Talend Open Studio
10.0
Complex transformations
Pentaho
Talend Open Studio
9.4

Data Modeling

Pentaho
Talend Open Studio
8.8
Data model creation
Pentaho
Talend Open Studio
8.6
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.5

Data Governance

Pentaho
Talend Open Studio
9.3
Integration with data quality tools
Pentaho
Talend Open Studio
10.0
Integration with MDM tools
Pentaho
Talend Open Studio
8.6

Pros

  • Being able to use the OLAP Analyzer tool saved our organization a lot of time in not needing to develop an OLAP tool on our own.
  • The ability to customize the tool and integrate all the internationalization we required was pretty straightforward.
No photo available
  • Integrating with Big Data tools
  • Handling multiple data sources
  • Monitoring real time data flow
  • Developing jobs quickly using predefined components
No photo available

Cons

  • Lack of support. Unlike many Microsoft products, there is not a great wealth of support out there for Pentaho on the web. It is much harder to track down solutions.
  • Non-intuitive. There is a learning curve, and there are subtle nuances to Pentaho that even experienced ETL developers will take a while to get used to.
  • Less reputable. Despite all of Pentaho's benefits, it just hasn't gotten to that critical mass in the marketplace. Thus it does not garner as much respect as Microsoft or Oracle, which in turn makes it harder to find online support. It's a vicious cycle.
No photo available
  • Community support could be better.
  • Adding a custom component to the palette is not very straightforward.
  • Interface could be improved to make it easier to use.
No photo available

Likelihood to Renew

Pentaho8.8
Based on 11 answers
Although the security piece is a major game changer in our shop, Pentaho is a great tool overall. I have known other shops to work out their security issues with Pentaho and do great things so we'll need to get through this growing pain point as well and make Pentaho our positive game changer. I am excited to see the improvements in Pentaho 5 and look forward to evangelizing it's benefits over the more high priced solutions out there
Stephanie Dozier profile photo
No score
No answers yet
No answers on this topic

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
No score
No answers yet
No answers on this topic

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

Breadth of Deployment

Typically system analysts, business analysts and departmental managers were our target audience. 10-15 users was the most we could reach before we decided to go with another suite of Products. But who ever used it did appreciate the end to end flow of data that they could see as opposed to the data obfuscation they noticed before.
Deepak Paramanand profile photo
No answers on this topic

Alternatives Considered

Did not have any other products similar to what Pentaho offers out-of-the box for free. The closest was to write some scripts manually so in our case PDI has beat Python scripts.
No photo available
Oracle JDeveloper for BPEL is a very nice tool, but way to expensive. It has a tight integration with Oracle DB and more advanced features.
JBoss ESB Developer studio is very, very close in terms of functionality, but again, expensive.
Jose Miguel Siu Navarro profile photo

Collaboration and Sharing

Pentaho7.3
Based on 14 answers
Did not use this feature. The reason was to use it required a user to install/run bi server, but we are not comfortable with the design bi server brings. We would prefer to use some self-contained functionalities of what can we get from Pentaho like reporting, or a PDI, and implement access control.
No photo available
No score
No answers yet
No answers on this topic

Data Integration

Pentaho7.3
Based on 14 answers
The most powerful feature and reason we use this software. As I already wrote - it can handle most of the possible data out of the box. From sql sources, to no-sql, and read from HDFS etc.
No photo available
No score
No answers yet
No answers on this topic

Return on Investment

  • Pentaho has improved our overall business process.
  • Pentaho has helped the Managers and Directors to analyze the numbers going up and down from time to time.
  • We have a started a big project using Pentaho that is going to include all the business processes in the organization.
Nikhil Karkare profile photo
  • Talend Studio has increased developer productivity and opened up new ways of thinking about solutions.
Eugene LaRoche 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