Pentaho vs Talend Open Studio

Likelihood to Recommend

Pentaho is well suited to small - mid size firms that have specific reporting needs. It is less likely to benefit firms that already have data analytics capabilities built into multiple platforms as Pentaho is not easy to integrate with other analytics platforms. There isn't enough documentation available online, however, customer support is easy to reach.

Read full review

Verified User

Consultant in Information Technology

Accounting Company, 10,001+ employees

View all 24 answers on this topic

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.

Read full review

Verified User

Engineer in Information Technology

Information Technology and Services Company, 5001-10,000 employees

View all 10 answers on this topic

Feature Rating Comparison

Pentaho

7.6

Talend Open Studio

—

Pixel Perfect reports

7.6

—

Customizable dashboards

8.0

—

Report Formatting Templates

7.3

—

Pentaho

6.5

Talend Open Studio

—

Drill-down analysis

7.2

—

Formatting capabilities

7.1

—

Integration with R or other statistical packages

6.3

—

Report sharing and collaboration

5.3

—

Pentaho

6.8

Talend Open Studio

—

Publish to Web

6.2

—

Publish to PDF

7.7

—

Report Versioning

6.8

—

Report Delivery Scheduling

7.1

—

Delivery to Remote Servers

6.2

—

Pentaho

6.3

Talend Open Studio

—

Pre-built visualization formats (heatmaps, scatter plots etc.)

6.3

—

Location Analytics / Geographic Visualization

6.7

—

Predictive Analytics

5.8

—

Pentaho

7.2

Talend Open Studio

—

Multi-User Support (named login)

7.5

—

Role-Based Security Model

7.2

—

Multiple Access Permission Levels (Create, Read, Delete)

7.2

—

Single Sign-On (SSO)

6.9

—

Pentaho

6.4

Talend Open Studio

—

Responsive Design for Web Access

6.2

—

Dedicated iOS Application

6.4

—

Dedicated Android Application

6.4

—

Dashboard / Report / Visualization Interactivity on Mobile

6.6

—

Pentaho

6.2

Talend Open Studio

—

REST API

7.2

—

Javascript API

6.7

—

iFrames

5.6

—

Java API

6.2

—

Themeable User Interface (UI)

5.5

—

Customizable Platform (Open Source)

6.3

—

Pentaho

—

Talend Open Studio

7.6

Connect to traditional data sources

—

9.0

Connecto to Big Data and NoSQL

—

6.1

Pentaho

—

Talend Open Studio

7.0

Simple transformations

—

7.4

Complex transformations

—

6.7

Pentaho

—

Talend Open Studio

6.5

Data model creation

—

6.5

Metadata management

—

6.4

Business rules and workflow

—

5.2

Collaboration

—

8.8

Testing and debugging

—

5.7

Pentaho

—

Talend Open Studio

9.2

Integration with data quality tools

—

10.0

Integration with MDM tools

—

8.4

Pros

User friendly interface
Easy and quick report generation
Great report customizing features

Read full review

Verified User

Consultant in Information Technology

Accounting Company, 10,001+ employees

View all 24 answers on this topic

Integrating with Big Data tools
Handling multiple data sources
Monitoring real time data flow
Developing jobs quickly using predefined components

Read full review

Verified User

Engineer in Information Technology

Information Technology and Services Company, 5001-10,000 employees

View all 10 answers on this topic

Cons

pentaho's analyzer tool/front-end. This doesn't come close to competing with products like Tableau.
Pentaho Report Designer, this looks like something that was built in the early 90's and is extremely clunky to use for new-users
Schema Workbench, would be nice to see better support for snowflake type schemas

Read full review

Ivan Miller

Business Intelligence Engineer

ExperticityMarketing and Advertising, 51-200 employees

View all 24 answers on this topic

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

Read full review

Mike Blizman

Consultant

PrivateOil & Energy, 5001-10,000 employees

View all 10 answers on this topic

Likelihood to Renew

Pentaho 8.8

Based on 11 answers

Basically, the cost is very affordable, if you have already done everything and the project is working then you don't want to replace it because that means making a whole new project. Also I think its very good and the competitor will not overcome the functionality. So you will find your self spending a lot of time and money to get to the same place.

Read full review

Itamar Steinberg

CEO

Inflow Systems LTDComputer Software, 11-50 employees

View all 11 answers on this topic

Talend Open Studio 10.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.

Read full review

Verified User

Employee in Corporate

Chemicals Company, 10,001+ employees

View all 1 answers on this topic

Usability

Pentaho 5.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.

Read full review

Deepak Paramanand

Technical Lead

Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees

View all 1 answers on this topic

Talend Open Studio 3.0

Based on 1 answer

Talend Open Studio is based on Eclipse and is full of redundant procedures to do one thing, like when installing libraries. Sometimes I cannot manually download the libraries that it can't find.

Read full review

federico nastasi

Big Data Engineer

Data Reply ITInformation Technology and Services, 51-200 employees

View all 1 answers on this topic

Performance

No score

No answers yet

No answers on this topic

Ask the community to sound off

Talend Open Studio 4.0

Based on 1 answer

Many times, Talend freezes. When you give a cancel command, it takes several minutes to stop. It also takes a great toll on our PC with 16 GB of ram and I7 CPU, even in idle status. If you are downloading Maven Jar/Libraries, you cannot do anything and have to wait until the task is finished.

Read full review

federico nastasi

Big Data Engineer

Data Reply ITInformation Technology and Services, 51-200 employees

View all 1 answers on this topic

Support

Pentaho 9.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.

Read full review

Deepak Paramanand

Technical Lead

Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees

View all 2 answers on this topic

Talend Open Studio 3.0

Based on 2 answers

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.

Read full review

Verified User

Employee in Corporate

Chemicals Company, 10,001+ employees

View all 2 answers on this topic

Online Training

Pentaho 9.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

Read full review

Stephanie Dozier

Business Data Analyst

Centex Systems Support ServicesInformation Technology and Services, 51-200 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Implementation

Pentaho 5.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.

Read full review

Deepak Paramanand

Technical Lead

Razorsight Software Pvt. Ltd.Information Technology and Services, 51-200 employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Ask the community to sound off

Alternatives Considered

In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that it provides 95% of the data integration functionality that these other tools do without having to spend a fortune to do so.

Read full review

Ivan Miller

Business Intelligence Engineer

ExperticityMarketing and Advertising, 51-200 employees

View all 24 answers on this topic

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.

Read full review

Mike Blizman

Consultant

PrivateOil & Energy, 5001-10,000 employees

View all 10 answers on this topic

Return on Investment

Good client feedback - caters to specific requirements
Low learning curve for new staff
Good community backup

Read full review

Verified User

Consultant in Information Technology

Accounting Company, 10,001+ employees

View all 24 answers on this topic

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.

Read full review

Mike Blizman

Consultant

PrivateOil & Energy, 5001-10,000 employees

View all 10 answers on this topic

Likelihood to Recommend

Pentaho

Talend Open Studio

Feature Rating Comparison

Pixel Perfect reports

Customizable dashboards

Report Formatting Templates

Drill-down analysis

Formatting capabilities

Integration with R or other statistical packages

Report sharing and collaboration

Publish to Web

Publish to PDF

Report Versioning

Report Delivery Scheduling

Delivery to Remote Servers

Pre-built visualization formats (heatmaps, scatter plots etc.)

Location Analytics / Geographic Visualization

Predictive Analytics

Multi-User Support (named login)

Role-Based Security Model

Multiple Access Permission Levels (Create, Read, Delete)

Single Sign-On (SSO)

Responsive Design for Web Access

Dedicated iOS Application

Dedicated Android Application

Dashboard / Report / Visualization Interactivity on Mobile

REST API

Javascript API

iFrames

Java API

Themeable User Interface (UI)

Customizable Platform (Open Source)

Connect to traditional data sources

Connecto to Big Data and NoSQL

Simple transformations

Complex transformations

Data model creation

Metadata management

Business rules and workflow

Collaboration

Testing and debugging

Integration with data quality tools

Integration with MDM tools

Pros

Pentaho

Talend Open Studio

Cons

Pentaho

Talend Open Studio

Likelihood to Renew

Pentaho

Talend Open Studio

Usability

Pentaho

Talend Open Studio

Performance

Pentaho

Talend Open Studio

Support

Pentaho

Talend Open Studio

Online Training

Pentaho

Talend Open Studio

Implementation

Pentaho

Talend Open Studio

Alternatives Considered

Pentaho

Talend Open Studio

Return on Investment

Pentaho

Talend Open Studio

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?