Contributors mailing list archives
contributors@odoo-community.org
Browse archives
Re: AW: BI and reporting tools
byThank you for your replies, I will have a look at Metabase.
Thank you also for the tips about foreign data wrapper and
Metabase models. Real time reporting is indeed an important
feature.
Have a nice day,
Victor Champonnois - Coop IT Easy
Hi Victor,
We are using Metabase (self-hosted) and are very happy with it so far. The main advantage IMHO is the possibility to connect data from Odoo with data from other data sources. The main disadvantage is the potential complexity of the Odoo data model. To address this, we are providing Models in Metabase for all the main business objects or our end users.
In terms of architecture we have decided to use Metabase without an ETL layer. Metabase connects only to one database (because it's currently not possible to make joins in Metabase from different databases). This database is a dedicated Postgres instance, which uses FDW (Foreign Data Wrapper) to connect to the source databases, such as Odoo. This approach has the advantage of realtime reporting and also reducing complexity because we don't need an ETL process. In terms of performance, it's good enough so far. Should we run into issues, we might add a read-replica as a secondary database for our source applications.
Hope this helps!Dave
Von: Victor Champonnois <notifications@odoo-community.org>
Gesendet: Mittwoch, 16. April 2025 10:32
An: Contributors <contributors@odoo-community.org>
Betreff: BI and reporting toolsHi,
I am researching different ways to do BI (business intelligence) and reporting with Odoo.
I am wondering whether it's worth it to invest on an external BI tool connected to the Odoo database.
On the community version I have the impression that the standard BI tools (standard pivot and graphs reports in Odoo) are sometimes limited in terms of performance (it's slow for wide and long pivot tables), data visualization (standard charts are not very useful) and flexibility (hard to make computations).
I know of the bi_view_editor and bi_sql_editor modules. Both are very useful and greatly extends the standard reports. But the limits listed above remains. But it seems it's hard to use it as is, in my case I always have to export manually the tables to build the table or chart I want with excel.
I also know of the spreadsheet and dashboard modules, although I don't have a great experience with it. Maybe it provides the lacking flexibility mentioned above ?
The last option is to connect a BI tool (Tableau, PowerBI, Apache superset, Metabase...) to the database. The main advantage is to connect it to other sources of data. But I am wondering if it's still worth it even connected only to the Odoo database.
Do you use an external BI tools ? If yes, which one seems to work well with Odoo (and preferably open source) ?
If no, how do you deal with BI and reporting for your clients ? Are you also confronted to performance issues, lack of flexibility and poor library of charts ?
Thank you for your inputs !
-- Victor Champonnois - Coop IT Easy_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
