Apps › Reports and dashboards

Metabase BI Connector

Metabase's databases, questions and dashboards come into Odoo as a catalog, and with signed embedding on, a dashboard or a question opens live in its Odoo form.

Open the live demo Read the manual

Odoo 16Odoo 17Odoo 18Odoo 19Odoo 20

Runs onOdoo 16 to 20Community or Enterprise, self-hosted or Odoo.sh
NeedsOdoo onlyno Enterprise module
Price89 EURone-time, per series, on the Odoo Apps Store
Demodemo20.bambooforge.devlogin page already filled in
Supportsupport@bambooforge.devfirst reply within one business day
Version20.0.1.0.14bambooforge_metabase_connector

123 automated checks run before every release of this app, the same suite on every series it ships for. The complete list is in the source you receive; run it yourself with --test-enable.

How you use it

Four flows, in the order you will meet them

Flow 01

Connect: one instance per Metabase server, dry-run first

Test Connection proves the address and the key, and the first import writes nothing.

  1. In Odoo: Metabase Connector > Configuration > Instances > New. Enter the server's address and an API key.
  2. Press Test Connection. The state turns Connected.
  3. On the Import tab press Queue Database Import, Queue Question Import and Queue Dashboard Import.
  4. Read Operations > Logs, untick Dry Run Mode and import again, databases first.
The Questions list of the catalog, with chart types and databases
Flow 02

The catalog: databases, questions, dashboards

Odoo's copy of Metabase's names, ids and collections, searchable and grouped.

  1. Catalog > Databases lists each data source with its engine.
  2. Catalog > Questions lists each saved question with its chart type, collection and database.
  3. Catalog > Dashboards lists each dashboard with its collection.
The Questions list grouped by database and chart type
Flow 03

A dashboard, live in Odoo

Signed embedding, switched on per instance by an administrator.

  1. On the instance's Embedding tab tick Signed Embedding and paste Metabase's embedding secret key.
  2. In Metabase, switch static embedding on and publish the dashboards to embed.
  3. Open a dashboard of the catalog: its Live View tab shows it; Refresh Live View signs a new token.
Flow 04

A failed job lands in a list, not in silence

Every job is retried, set aside after its last try, and shown with its error.

  1. Open the Control Tower: one card per instance with its backlog, dead letters and conflicts.
  2. Open Dead-letter, fix the cause the error names, select the jobs and use Requeue Jobs.

Price and where to buy

89 EUR, one payment per Odoo series, on the Odoo Apps Store. Pick your series:

Twelve months of support by the people who wrote the code; bug fixes and improvements within the series free for as long as it is published. Report a bug within two months of purchase and, if it is not resolved within fifteen days, you get a full refund. Full source under OPL-1, no licence key, no phone-home. The whole promise.