Mysql Question posted in
The official MySQL documentation can be found here.

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.

Tags:

2

Answers


  1. 0

    I see if currently the following data sources are supported by google data studio.

    I however do not see connection between Google Data Studio and Azure MySQL Db at the moment.

    Connect to your data
    With Looker Studio, you can easily report on data from a wide variety of sources, without programing. In just a few moments, you can connect to data sets such as:

    Databases, including BigQuery, MySQL, and PostgreSQL
    Google Marketing Platform products, including Google Ads, Analytics, Display & Video 360, Search Ads 360
    Google consumer products, such as Sheets, YouTube, and Search Console
    Flat files via CSV file upload and Google Cloud Storage
    Social media platforms such as Facebook, Reddit, and Twitter
    Blended data from any combination of related sources

    Ref: https://support.google.com/looker-studio/answer/6283323?hl=en

    In the connector gallery I do not see a connector for Azure MySQL Database. Ref : https://lookerstudio.google.com/data

    Login or Signup to reply.
  2. 0

    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

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search