Try ERPNext Buy Support Partners Foundation Foundation Members

Integration with Google Data Studio

Is it possible for ERPNext to integrate with Google Data Studio? If yes, then how?

What do you mean by “integrate”? If you wish to use Google Data Studio, you will need to connect MySQL (MariaDB) as a source to your data studio. Depending on where you host your DB, you might need to open the ports, get the ip address and provide it to GDS and then query what you need to do there…

I hope this helps.

1 Like

Hi Tariq,

Google Data Studio can connect to ERPNext database.

Here is my suggestion :

  1. Create a new user in ERPNext Database specific to Google Data Studio
  2. On your ERPNext server, allow inbound access to Google Data Studio ip addresses (see below)
  3. On Google Data Studio, create a new datasource type MySQL
  4. Enjoy

Here is the ip address range you should allow for inbound access to your ERPNext server :

64.18.0.0/20
64.233.160.0/19
66.102.0.0/20
66.249.80.0/20
72.14.192.0/18
74.125.0.0/16
108.177.8.0/21
173.194.0.0/16
207.126.144.0/20
209.85.128.0/17
216.58.192.0/19
216.239.32.0/19

2 Likes

https://support.google.com/datastudio/answer/7088031?hl=en

1 Like

Thank you so much Saxoprane. You will be my Guru if this works.
Cheers!

1 Like

Thank you.

1 Like