Pentaho

Vorteile

Data Integration allows the build of such a complex ETL projects in a quick way, it's very powerful. Being an open source software allows the user to always find hints over the web

Nachteile

Issue log reports not really clear the error/s occurring and the troubleshooting results sometimes difficult.
Scheduling

In Betracht gezogene Alternativen

Gründe für den Wechsel zu Pentaho

Vorteile

Excellent Data Integration across all the databases , User friendly and amazing for report designing using PRD tool(Pentaho Report Designer). Loving it!!

Nachteile

Takes longer time for fetching the data in report, technical limitations in report designing and bug solving are not easy.

Vorteile

Many features.
I like to use the reporting PRD, I think that it is the best.
I use Spoon/Kettle that is a ETL tool to process data.

Nachteile

Many bugs. Maybe is because of Community Edition.
We have many difficult to install in cloud.
The layout of some report that run in developing, don't run in production.

Vorteile

Excellent Data Integration, affordable price model and high user friendly.

Nachteile

Slow in loading huge data, technical limitation in reporting and resolving of ticket could have been improved a bit.

Vorteile

Ease of use and abundant features to get things done. Helps a lot in filling the various gaps in data sources.

Nachteile

Not so user friendly, takes sometime for new user to get around the application and figure out the various tricks and tools available

Vorteile

This tool can be installed on any operating system. It has a simple interface, so it takes less time to learn.

Nachteile

The design of the software is pretty old! Needs lot of improvement when compared to its competitors.

Vorteile

Penatho brings a visual interface to processes which would traditionally only be accomplished by many, many lines of code (which it can also do). Many powerful inputs from servers, software, and CRM systems. It also has very detailed error handling, which makes it easy to troubleshoot.

Nachteile

Support is mostly wiki/community based, with instructions for particular steps being lacking, outdated, or missing completely. Outputs could be simplified as well, with even a basic CSV output being slightly more complex than it should be, compared to other steps.

Vorteile

This software is wonderful, with it you can obtain performance and scalability. As well as manage and schedule reports. It is very efficient which means that you save a lot in daily reports...

Nachteile

This software is potentially amazing. Has it all! Your free trial is as complete as the paid version. It's very complete.

Vorteile

-Automate the steps for execution
- It has a friendly graphic environment
- Easy to use
- Wide range of tools

Nachteile

-High basic requirements for execution.
- lack of detailed comments in error messages.
-It does not have documentation in Spanish language.

Vorteile

Data in Pentaho can be easily import from nearly any type of source including .csv, excel etc to create single report.

Nachteile

Pentaho itself is too much resource hungry as compared to other BI softwares. Configuration after installation is required that will be difficult for non-techies.

Vorteile

Suite d'outils open-source de Business Intelligence (BI)
Facilité d'intégration avec plusieurs systèmes de gestion de bases de données, outils de big data
Large communauté et documentation

Nachteile

Fonctionnalités limitées dans la version communautaire gratuite
Manque de support technique officiel sur la version open-source

Vorteile

Il grande vantaggio della Suite Pentaho è lo strumento di ETL (Pentaho Data Integration o Kettle), strumento estremamente potente e performante che consente di comporre visivamente qualsiasi flusso di trasformazione del dato.

Nachteile

Gli strumenti di Analisi del dato non sono al passo con lo standard attuale.

Vorteile

Pentaho allows for great flexibility in report writing. It provides access to data tables with limited restrictions. It is highly customizable.

Nachteile

While the system does offer Wizard tools this is not a product for beginner level report writers. It is best used by someone with at least basic SQL training.

Vorteile

主に、ETLとレポートデザイナーを利用して、会社内のレポートを作成しています。
担当者が手作業で作成していたレポートを自動で作成するように切り替えたり、
手作業では作成が困難だったレポートを自動作成したりしてきました。
最初の数年は、クライアントPC上でサーバーを稼働させて、お試しで運用しました。
その次は、性能の高めのクライアントPC上で、本格的な運用を開始して、
近年は、その有用性を社内で認められ、本格的なサーバー導入に至りました。
このような段階的な運用が可能だったのは、この製品に Community Edition が存在していて、フル機能を無償で試すことができる点が大きいです。

Nachteile

良くない点はあまりありません。
強いてあげるならば、とっかかりで Community Edition を運用するにあたっては、やはり「情報を自分でかき集めて来る」必要があるので、万人にお勧めできない点でしょうか。
社内リソースや当人に不安があるならば、技術的な点を補うためには、外部の協力者に有償でサポートを受けた方が確実ですし、安心です。
Web上に情報が無いわけではないですが、フルスタックの知識を要求される面が多く、素人に毛が生えた程度の技術者では太刀打ちできません。
利用ユーザーの裾野を広げるためには、この点は改善されて欲しいと思います。

Vorteile

Excellent data integration across various data nodes, high user friendly which means easy to learn and cheaper cost compared to current market standards.

Nachteile

Limitation in integration with JDBC connector, reporting designer features needs to be enhanced a bit and slow in fetching huge data.

Vorteile

"higher visual interface to processes, has a good number of functions (and very easy to understand) for data reporting, integration, data mining and ETL.. very simple but effective Big data transform

You can build many dimensional model and load the results of the transformation into a database to develop any report whit low margin of error through a dimensional model and load the results of the transformation into a database to develop specialized reports , low margin of error-Automate the steps for execution"

Nachteile

Its a great tool to use, nothing to dislike about the product. Nothing to dislike, everything is good. All the features are really good.

Vorteile

- We mature DI (Data integration) module
- Easy to learn design console (Spoon)
- wide community support
- Very well integrated with different platforms
- Innovating fast in Big data world specially Pentaho 7.1

Nachteile

- Not very well documented for latest releases one of the reasons is many innovation are happening very fast

Vorteile

Easy to use, compatible in many database such as mysql, ms sql server, different type of output to choose such as excel, html, richtext, etc.

Nachteile

Some version are slow on initializing and fetching data such as Pentaho report designer version 5 and above. Unlike version 3 which has smooth process, that was base on my experience.

Vorteile

Pentaho has nice schema browsing features whereby one not need know anything about the underlying schema in order to design a transformation. Automatic multi-threading by default.

Nachteile

When outputting to a table, Talend has an option to Drop if exists, and create. Pentaho has a Truncate [prior to load], but no option create the table as part of the data flow nor an option to drop an existing table.

Vorteile

Drag and drop functionality makes it easy to create transformations. Able to analyse data from multiple sources quickly and efficiently. Jobs can be scheduled in order to run specific tasks and transformations at a certain time.

Nachteile

Can take some time to figure out how to use it as there are lots of components involved. Can be a bit slow or run into out of memory issues for bigger queries but upping the virtual memory in the configuration can fix this issue.

Vorteile

Once you understand the basics of this program it is easy to use. The bonus with this program is that if someone write a report, they can share the script with you. The updated 6.1 version is definitely an improvement.

Nachteile

If you are not at all familiar with writing script, this program can be very challenging. No real user manuals are included.

Vorteile

Pentaho makes it really easy to generate some complex data driven visualizations.

Nachteile

Pentaho doesn't have a lot of options for pulling data from public APIs.

Vorteile

Very easy to learn, provides efficient report designing tool and integration with different datasource is too good.

Nachteile

It has limitations in customized templates, user community is not so high compared to other BI tools and compatibility issue with JDBC connector is definite area of improvement.

Vorteile

Very good tools for visualisation of data. Dashboards are very easy to develop. Easy to integrate with third-party tools.

Nachteile

Takes some time to understand how it works. Interface is not intuitive. If you want to solve the problem by yourself there is no much information how to do that even with a very small problems.

Vorteile

Best reporting tool.Features like data reporting, integration, data mining and ETL.
Provides easy and good insights of business.
Provides intuitive interface for most advanced users

Nachteile

Sometimes Pentaho Spoon(GUI) crashes.sharing and collaboration capabilities need to be enhanced Other all features are really good.

Vorteile

Ease of install I suppose; that and its ease of uploading reports into our EHR.

Nachteile

Flexibility is limited. Other report designers will offer time saving features that are missing here. Having to manually create queries instead of having a UI do it for you ( a la Crystal Reports) is a huge time sink. Using the Report Designer locks you into appearance constraints and removing them is a pain.

Vorteile

We use Pentaho to do SLA reporting to our customers. Reports can be customised in various ways which is a great thing.

Nachteile

Because there are so many things Pentaho can be used, the user interface could be more intuitive to use.

Vorteile

- Free PDI tool....its free so no discussions with finance
- PDI is actually very effective ETL application with a easy to understand flow
- Community is actually helpful

Nachteile

- Free BI tool is just slightly easier than building a website from scratch but a lot harder than using any other BI tool.
- You need to know how to hack java to use.
- The paid version does not have competitive pricing for the incremental value.

Vorteile

I like its ease of use; it is very easy to build an ETL pipeline after the initial learning curve. I also like the variety of modules. There are a lot of powerful modules, and you will mostly find the module you want. User-defined code is very flexible; it's possible and very easy to plug in user-defined Java code. When there is no module implemented for desired function, this feature comes handy. Multithreading is also easy. The transformation can be set to run multiple copies in parallel.

Nachteile

Occasionally, Pentaho Spoon (GUI) crashes, and a restart is required.

Vorteile

It provided an intuitive interface for most advanced users.

Vorteile

Pentaho BI Solution is nomilly a BI Open Source solution that can compete with the most important players of this area.
Pentaho is easy to manage and has a powerfull ETL inside that can be managed itself as a product.

Nachteile

The "Open Source Philosophy" is not away true.... I mean that if you want a full support from Pentaho it will be not-so-cheap

Vorteile

Really helps to solve complex business solutions with its cool features and like their contribution to open source.

Nachteile

Its a great tool to use, nothing to dislike about the product.

Vorteile

Fetures like data reporting, integration, data mining and ETL capabilities

Nachteile

nothing to dislike, everything is good. All the features are really good.

Vorteile

Simply the best BI on the market and still for free, perfect

Nachteile

I have not reported any issues with my use

Vorteile

A very well designed platform, of great cost benefit, as well as the integration and reports, even better than when we analyze the costs,
Pentaho is a free tool, incredibly, because when you work on it, you realize the robustness by handling a lot of information in just seconds

Nachteile

In addition to its great design, the learning curve is quite high, and its platform is not very intuitive

Vorteile

· Very powerful integrated tools
· Better user interface
· Best report design wizard
· Fastest growth and improvement
· Better dashboard capabilities

Nachteile

· Doesn’t seem to have a wizard for creating charts
· Weaker support community

Vorteile

Pentaho Data Integration has lot of functions to fulfill the requirements. Functions dealing with running shell script to creating and reading from Excel spreadsheets were quite useful for creating an ETL flow.

Nachteile

Requires the training to actually understand the product. It is hard to figure out several aspects like declaring variables (global) within the product.

Vorteile

It is intuitive for beginners, what makes it easy and quick to learn. Also, it's a free platform, and it has one large community.

Nachteile

The bugs are usually not so easy to solve, and the errors shown sometimes don't give you a clue of what is wrong.

Vorteile

This product has good features including data mining, integration. This product also has features for data reporting. Learning curve for the product is less.

Nachteile

Not Really. I don't think there is anything I dislike. This product has all good features.

Vorteile

Great analytics and results are very useful. Provides good insight of the business.

Nachteile

Nothing much to dislike, in fact haven't seen so many applications supported by a single software

Vorteile

Features like data reporting, integration, data mining and ETL capabilities

Nachteile

Nothing, Everything looks good to me. All features meet expectations.

Vorteile

we can create reports very easily and its very easy to manage. we can provide information in more informational way to our customers.

Nachteile

This is easy to use but hard to integrate ,use is limited in many cases and not for every application.