Hello, I am using ERP in Frappe Cloud (Note: it is not a separate server, I am using the cloud version). I have been trying to connect LookerStudio to the MySql DB of ERP using the MySql connectors available in Looker Studio. I keep getting error which don’t provide any information. Has anyone solved this issue?
I was able to solve this with help from frappe support. After much of trial and error, and with help from Frappe support, I got the correct SSL certificate which is the full chain version of the certificate. I used the MySql connector from Google with this certificate and I was able to finally connect to the MariaDB in my cloud instance!
Point to note: I saved the SSL certificate string provided by frappe support team member Balamurali into a file with extension .pem. I uploaded this file in the MySql connector configuration while setting up the DB connection parameters.
The MariaDB connector available in community connectors is paid version and they couldn’t provide the correct support.