Integration with Google Data Studio

Integration
1

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

2

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
3

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
4
1 Like
5

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

1 Like
6

Thank you.

1 Like
7

Were you able to @Tariq151

8

Has somebody tried it for restAPI based integration?