mysqllooker-studioazure-mysql-database
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.
Solution
To connect to an Azure MySQL database in Looker Studio, follow the procedure below:
- 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:
- 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:
- Click on "Authenticate." It will connect successfully, as shown below:
- how to get lib_mysqludf_sys.dll file on windows
- Qt5 MYSQL driver not loaded error
- How can I add machines to data already been sharded in SQL database?
- Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
- how to save marital relationship in a database
- store posts + comments in mysql dbs
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Does using ASCII/Latin Charset speed up the database?
- utf-8 vs latin1
- Looking to build myself a tiny, free VMWare image for PHP+MySQL Development
- What difference does WITH GRANT OPTION make?
- In MySQL, which is more efficient: IFNULL or NULLIF?
- Replace null with 0 in MySQL
- MySql Query Replace NULL with Empty String in Select
- What does # mean in SQL?
- Trying to understand why my search is not yielding results
- How to set the column order of a composite primary key using JPA/Hibernate
- Renaming foreign-key columns in MySQL
- MySQL query next sequence number for MYSQL auto-incremented field
- How can I suppress column header output for a single SQL statement?
- How do I execute PHP that is stored in a MySQL database?
- Splitting huge sql dump file in smallest chunks possible
- Altering table to add column before specific column
- What is the difference between latin1_general_ci and utf8_bin in MySQL
- count with load Laravel
- MySQL: How to convert seconds to mm:ss format?
- Get mySQL MONTH() to use leading zeros?
- Enable password and unix_socket authentication for MariaDB root user?
- sequelize error: missing index for constraint
- How can I access ddev's database with external database browsers or similar tools?