Overall Satisfaction with Pentaho
We are currently using this application for all the companies. We have managed to develop a lot of reports and dashboards and also bursting reports. Until now we have been able to meet the requirements of reporting in the company in all departments. Pentaho is a good BI solution to also provide the option of creating many operational reports if you don't have a good option in your ERP.
- SQL query + scripting will help you design different objects, tables, pivots, dashboards, linked t other reports.
- Organizing in which way you want, synchronizing with AD is very helpful to set security/folder/group of users/single users.
- By using Eclipse you can set another layer of security by filtering information users's need to access.
- Sending reports y email also can be set up by security, by groups or list of users.
- Design seems pretty secure, from time to time can fail when there is too much design.
- Would like to have a format copy for different objects, tables, cross-tabs, grids, it would make design much more easier. Of course, we use template and CSS design for these objects, from time to time we design something different and it makes it much harder to do this manually for each similar object.
- Possibility to use multiple DB in the .xaction.
- direct query in excel
In comparison with Excel, that can also work with queries pivots and dashboards, Pentaho offers much more stability from a database point of view, more security options and provides a more stable table, pivots and dashboard designs. We are also completing the business intelligence experience for our users with Kyubit.