Metabase Integration with ERP

ERPNext
1

Team,

We are planning to use Metabase for creating executive dashboards. Would like to hear about how metabase is deployed and used in current ERP Deployments.

  1. Should Metabase connect directly to the ERP Database or to any replica DB?

  2. Will there be any performance bottleneck if Metabase is accessing ERP Master DB directly? If so, how to mitigate that

  3. Do we need to deploy Metabase in a Separate Server or in same server as ERP?

Thanks,
Saravana

1 Like
2

Team, any inputs on dashboard options?

We are facing deadlock timeout issues randomly in our production db . Hence contemplating to have Metabase in separate server and accessing the data from the Replica DB

3

Hi @saravana,

  1. Should Metabase connect directly to the ERP Database or to any replica DB?

This is completely your choice as your can always connect directly with the production database or even to a staging / dev database if you have the environment setup accordingly.

  1. Will there be any performance bottleneck if Metabase is accessing ERP Master DB directly? If so, how to mitigate that

This shouldn’t be an issue if the server hardware is of good configuration. Also it depends a lot on the complexity of the dashboard you’re going to create. If you’re going to write custom multi-level queries then it might create certain performance issues. This cannot be ascertained without a proper breakdown of the dashboard requirement.

  1. Do we need to deploy Metabase in a Separate Server or in same server as ERP?

Again, it’s your choice completely. You can deploy it on the same server as ERPNext or even on a remote server. Depends on what you’re trying to achieve.

Refer the link below to understand how you can install and setup Metabase on the same server as ERPNext :point_down:

Thanks

4

We are facing deadlock timeout issues randomly in our production db . Hence contemplating to have Metabase in separate server and accessing the data from the Replica DB

  1. Can you share your server config (CPU / RAM) and it’s average load?
  2. Also, on a level of 1 to 10, what is the level of complexity of your Metabase dashboards?
5

Thanks @shashank_shirke for your inputs.