CODEWITHSUNDEEP
mysqllooker-studioazure-mysql-database
G Srikar eddy
G Srikar eddy

Reputation: 3

Can we connect to Azure MySQL database from Google Data Studio

Is there a way to create a data source to Azure MySQL database in Google Data Studio? What is the public IP of Google Data studio that I can give access to in my Azure MySQL database?

Thanks in advance!

couldnt connect to Azure MySQL database from google data studio.

Upvotes: 0

Views: 94

Answers (1)

Bhavani
Bhavani

Reputation: 5317

To connect to an Azure MySQL database in Looker Studio, follow the procedure below:

  1. According to this add 142.251.74.0/23, i.e., start IP 142.251.74.0 and end IP 142.251.75.255, to the Azure MySQL server firewall rule as shown below:

enter image description here

  1. Select the MySQL DataSource option while creating a data source in Looker Studio, enter the required database details, download the SSL certificate from the network tab of the server, check "Enable SSL," and upload the downloaded certificate to connect as shown below:

enter image description here

  1. Click on "Authenticate." It will connect successfully, as shown below:

enter image description here

Upvotes: 0

Related Questions