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:
- MySql can't make column auto_increment
- Insert auto increment primary key to existing table
- 3 mysql table join but not getting expected result that i want
- MySQL insert_id returning null even though there was an insert
- mysql select query within a serialized array
- MySQL: Large VARCHAR vs. TEXT?
- php_network_getaddresses: getaddrinfo failed error in Docker's adminer
- Correlated queries - In derived tables, can I have many nesting levels?
- Is there a MySQL option/feature to track history of changes to records?
- When is a database called as an Embedded database?
- Multiple foreign keys from one table to same field in another table in Laravel
- Datetime-value's time inserted incorrectly in one column but not in another MYSQL
- Syntax diagrams for MySQL
- Converting currency symbols '$' '£' to html code $ £?
- Create Index in mysql not working
- Incorrect string value: '\xEF\xBF\xBD' for column
- Understanding inner join in recursive CTE (MySQL)
- Update MySQL table with rank number of duplicates by name
- Mysql query for 3 tables & user meta
- Setting up new instance of MySQL what is Current Root Password?
- How to change the CHARACTER SET (and COLLATION) throughout a database?
- How to resolve circular foreign key constraints with NOT NULL in Hibernate
- mysql join to record first one which is not matched before
- Conditional statement in migration doesn't work laravel
- Mysql ERROR at line 1153: Unknown command '\'
- How do I find the command causing a replication error in MySQL
- Wordpress Meta Value (Serialized) Filter
- Can you access the auto increment value in MySQL within one statement?
- Can't connect to RDS instance from EC2 instance
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)