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.
Google Data Studio can connect to ERPNext database.
Here is my suggestion :
- Create a new user in ERPNext Database specific to Google Data Studio
- On your ERPNext server, allow inbound access to Google Data Studio ip addresses (see below)
- On Google Data Studio, create a new datasource type MySQL
Here is the ip address range you should allow for inbound access to your ERPNext server :
Thank you so much Saxoprane. You will be my Guru if this works.