Metabase with ERPNext

Integration
2

Just some basic test, it’s very easy to add your own columns and use formulas. Like I’ve added Days Old column to the invoice table.

Capture.JPG1629×390 38.8 KB

3

@iadr3805 how about a step-by-step how-to-guide ?

4

@iadr3805 that was exactly what i was looking for thank you so much!! it works great!

5

Its straight forward to run Metabase and connect to ERPNext DB.
I’m still struggling to get an ER diagram for ERPNext to make report writing easier but haven’t been able to with workbench.

http://www.metabase.com/docs/v0.12.0/operations-guide/start

6

We dont have ER Diagram as such at present as per my knowledge. But you can use MySQL workbench and other such schema browsing tools to get started.

We also have this (might be outdated due to version 8 changes):

1 Like
7

For those who are interested in an installed software and a familiar office product feel. Install Microsoft Power BI desktop edition.

Data Visualization | Microsoft Power BI

8

Metabase is awesome!!!

9

Is it possible to integrate this INSIDE ERPnext? Like an extra tab, menu or iframe etc? This looks like a MUST HAVE. Thanks for the share.

10

Would love to know where we are on this - Im looking into this as well as @tmatteson and I working on a dashboard builder.

Need a walkthrough on gaining access to DB I assume i have to do a port forwarding thing since my install is on Google cloud?

11

Metabase is awesome. I make some views on database and allow Metabase to access those views. Now staffs can make their own report based on that view while keep some confidential information.

However, integrating Metabase into ERPNext is somehow not bring so many value. At the end of day, Metabase help you to make SQL query for easily. I prefer for frequent report in Metabase, we can copy the SQL code into ERPNext custom report.

12

Good Morning, i am having few challenges installing Metabase on my Bench…
Any help Please

13

I’m not sure how you do it but Metabase is seperated application running on Java. How can you use it with Bench?

14

I saw a thread Metabase with ERPNext which i am trying to achieve.

15

Any help installing this?
i have some issues
There are some required field thats not just working for me

16

I think it’s very basic of setting up Metabase and how to connect database. You can find out on Metabase website. There are tons of material there and you can research to do by yourself

17

Thank You

18

Hello @iadr3805 the link shared is not valid. Please do you have the updated link as i need to be able to connect this to my ERP Next DB

19

I expect the next iteration of the Frappe Report Builder to have similar features… hopefully. Generating reports from single tables without charts is currently one of the biggest drawbacks in the Frappe/ERPNext product… especially when hosting in the ERPNext cloud

Kind regards,

20

refer,

21

metabase works and then web interface keep crashing after few minutes. Status says it’s active and running but not working. Any ideas? Running version 40
metabase.service - Metabase Application
Loaded: loaded (/etc/systemd/system/metabase.service; enabled; vendor preset: enabled)
Active: active (running) since Tue 2021-11-09 03:58:49 UTC; 5min ago
Docs: Metabase documentation
Main PID: 9206 (java)
Tasks: 25 (limit: 4702)
CGroup: /system.slice/metabase.service
└─9206 /usr/bin/java -Xms128m -Xmx256m -jar metabase.jar

1 Like