1. Mailing Lists
  2. Contributors
  3. Re: AW: BI and reporting tools

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Re: BI and reporting tools

AW: BI and reporting tools

Avatar

Re: AW: BI and reporting tools

by
Open2Bizz, Thomas Pot
- 16/04/2025 12:17:16

We also Use Metabase for some of our projects, which works nicely.

We do a daily replication of the database, to not disturb operations, and provide end users with pre defined models for the Odoo database.


Op 16-04-2025 om 10:47 schreef David Brühlmeier:
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.
--
Met vriendelijke groet - Kind Regards - Mit freundlichen Grüßen,

Thomas Pot

Open2Bizz B.V. dé Odoo specialist

https://www.open2bizz.nl
https://care-software.com

Mauritslaan 56 | 6161 HW | Geleen (NL)

Maak meteen een afspraak voor een online demo van Odoo / Care-Software:
klik hier

LinkedIn Connectie maken

Reference