Review: "Pentaho Report Designer Integated with Odoo v7!"https://www.trustradius.com/business-intelligence-biPentahoUnspecified7.51001012014-09-16T16:57:40.605Z
Overall Satisfaction with Pentaho
We integrate Pentaho with Odoo for complex, custom reports that allow us to query data from PostgreSQL database across multiple data models in Odoo. I have used it to connect to Odoo via JDBC as well as directly to the web client for an object-based report. I have found the report designer client to be a bit difficult to use and buggy on my WIndows 7 machine but I have seen it working well on a Windows 8 machine. We use version 3.9.1.
- Connect via JDBC
- Integrates with Odoo (formerly OpenERP)
- Grouping, summing seem to work well even though they are not intuitive as far as set up goes.
- The multiple report output types are great (PDF, CSV, Excel, Word, Text, etc)
- Connect via the web client of Odoo
- Easy to build in parameters for filtering in the report
- Report designer seems to be buggy on Windows 7
- The interface for the report designer is out dated and difficult to navigate or use.
- I would like to see a tool tip when hovering over options
Pentaho is more powerful than any other reporting tool that is commonly integrated with Odoo. The standard reports are in RML (report modeling language) but Webkit is also available. Both are good for particular types of reports. However, if you want to design a custom report that would involve grouping, summing, complex queries that will JOIN data across multiple data models, Pentaho is your tool. It isn't super easy to integrate and impossible for the average, non-techie type. However, it isn't difficult with a good set of instructions and a decent amount of technical knowledge.
I will use Pentaho until I find a better tool with a better, easier to use report designer client. For now, Pentaho has been the most powerful reporting tool for our clients because of its ability to connect to Odoo, integrate in Odoo (reports are accessible in Odoo) and the flexibility in report design and parameter integration.
We have about 15 clients using reports that are designed in Pentaho and integrated with Odoo. We have 2 employees that do the design and development of reports using Pentaho. We are both advanced users of the report designer and can set up Pentaho to run on Ubuntu after installing Tomcat7 and Java JDK.
Pentaho is very flexible in terms of data sources. The connection to Odoo works well and the direct, object-based connection works well and is quite powerful for generating reports as well. I can see using Pentaho to generate reports for ecommerce sites by creating a JDBC connection to a MySQL database and although integration within an ecommerce platform is not currently available, it would still be useful to run Pentaho reports in the designer.
I use the Pentaho report designer on my local, generate a .prpt file and integrate that to make the report available in our client's Odoo instances. I haven't used any access control, data sharing or securities features that are available in Pentaho but I am looking forward to using them as I need them.
I don't use Pentaho much in the way of charts and graphs or geospatial data because I generate text based reports. I have found the report designer-generated reports to be very visually attractive and I can insert logos, background images, and format my text with fonts, colors, justification and other common formatting.
Pentaho is great for companies that don't have huge budgets but want a powerful reporting tool that they can get and use for free. It is great for developers that know SQL and can learn to use a non-intuitive interface and are motivated to work through a very outdated interface.