Pentaho Software

having this kind of tools is very great for business intelligence developer like me.

Pros

open source software so you can explore deeply, i use the pentaho report designer for extracting data from of sql server that helps our team for gathering exact information.

Cons

for the version of 5 and above it slows the application and fetching of data. ( i dont know if the specs of computer can affect this but on version 3 it was smooth and fast)

Pros

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.

Cons

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.

Best product for reporting and analyzing.

Pros

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

Cons

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

Pros

"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"

Cons

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

Pros

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.

Cons

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

Pros

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.

Cons

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

personally I think it is a very powerful tool, powerful, very robust and also free

Pros

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

Cons

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

Pros

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.

Cons

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

It's a great platform, congratulations ...
is the only one compatible with the bank I use, only a more robust documentation is missing.

Pros

The only BI software that is compatible with Firebird SQL, I have not found any other compatible BI.

Cons

Particularly I found it difficult to start learning, the documentation regarding the data integration (spoon) is scarce.

One of the best opensource BI tool, also well integrated with existing platforms. It will be interesting to see how will it get integrated with fast evolving Big data technologies. Pentaho 7.1 is step in right direction.

Pros

- 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

Cons

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

Pros

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.

Cons

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.

Pros

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.

Cons

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.

Pentaho features pixel-perfect reporting, subreports, parameterized reports, and OLAP. The OLAP tools let you perform ad-hoc views, reports, and views through MDX queries. Pentaho puts more effort into data integration, ETL, and workflow automation.

Pros

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

Cons

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

Likes Best

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

Likes Least

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

Recommendations

It is very easy to learn and has good support service.

Likes Best

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

Likes Least

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

Recommendations

I would definitely recommend this product to other students specially if they are working on big data related projects. Really useful features in product and easy to use for new user.

Likes Best

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

Likes Least

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

Recommendations

Use it for real-time business analytics. All your data can be analyzed properly.

Likes Best

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

Likes Least

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

Recommendations

Services they provide and the results are astonishing !

Likes Best

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

Likes Least

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

Recommendations

Must use for business analytics related operations. Good and very helpful tool for analytics related to operations.

Likes Best

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.

Likes Least

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

Recommendations

Very useful for enterprises, since Pentaho provides active support in case of software issues.

Likes Best

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.

Likes Least

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

Recommendations

It is easier to learn from examples. Pentaho has examples with the installation.