Try ERPNext Buy Support Partners Foundation

Metabase integration for Frappe and ERPNext

Hi,

I’ve created Metabase integration apps for Frappe and ERPNext.

Frappe does have Dashboard tools but it’s quite limited in terms of customization, creation and filtering. Metabase is an open-source dashboard tools which offer a lot of functionality.

This app offers an easy way to integrate Metabase into Frappe page.

Feature

  • Integrate Metabase into Frappe page using iFrame
  • Resize iFrame using Metabase resizer
  • Metabase link will expired based on pre-config time

Prerequisite

Repository


Any feedback or suggestions are welcome. :smile:


I’ve also created Plotly Dash integration for Frappe and ERPNext.
It’s suitable for developer who want more customization with their dashboard and data processing.

25 Likes

Awesome work Pipech! Definitely gonna use this, definitely!

However, can we go with your Docker image for ERPNext and integrate this? :slight_smile:

I have already integrated metabase. I’m eager to try this! :slight_smile:

Wow this is very good. Can wait to try. can this work with version 10? Am still running version 10.

I haven’t tried but it should works with version 10, 11, 12.

You could install Metabase Integration app like you could install any custom apps.

The easiest way is just create new Dockerfile and build from my image.

FROM pipech/erpnext-docker-debian:v12-py3-latest

### set workdir
# These variable has been set from base image
# $systemUser, $benchFolderName
USER $systemUser
WORKDIR /home/$systemUser/$benchFolderName

RUN bench get-app metabase_integration https://github.com/pipech/frappe-metabase.git

Or you could follow this guild to set-up CI/CD using GitHub and GitLab which you could use to install Metabase Integration apps or your custom private apps.

But I don’t think I’ll include this apps in Docker image by default because I believe the majority of people won’t use this apps and I don’t want the image to be bloated.

How ever I’ll consider creating a new image tags such as v12-py3-w_metabase-latest

Cheers! :nerd_face:

1 Like

Cheers! Thanks a lot for your work Pipech!

Great Work!

Dis you managed to make it work with SSL? I can’t figure how to make metabase work with the let’s encrypt created from frappe / erpnext.

So if the ERPNEXt/ frappe site is with SSL It seems it doesn’t work with metabase being without SSL. Any idea? Thanks!

I got message:

Failed to load resource: net::ERR_SSL_PROTOCOL_ERROR
desk:1 Uncaught ReferenceError: iFrameResize is not defined
at HTMLIFrameElement.onload (desk:1)

Kind Regards,

Rubén