Connecting MySQL to Looker Studio

Before we delve into the step-by-step process, let's briefly dive into the world of MySQL and Looker Studio, two amazing tools that have transformed the way we interact with and extract value from data, and explore the reasons why you might want to integrate them.

Click here to access the tutorial showing the ways to share reports in Looker Studio.

MySQL is an open-source relational database management system, known for its speed and reliability. It is used by developers, analysts, and organizations around the world to store, organize, and retrieve data efficiently.

Looker Studio , on the other hand, is a modern and intuitive data analysis platform that allows you to explore, analyze, and share data insights in a visual and interactive way. With it, you can turn your raw data into valuable information, driving strategic decision-making in your organization.

Now that we have a clear understanding of what each platform offers, let's move on to the step-by-step guide!

Centralizing Data in MySQL with Kondado

1. Registering Your SQL Server as a Destination in Kondado: First, you need to login to Kondado and register your database as a destination to receive data from your tools. To register your MySQL as a destination, follow the step-by-step shown in our documentation.

2. Creating Your Data Sources: Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit our wiki and follow the respective step-by-step instructions.

3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps.

Connecting MySQL to Looker Studio

Entering Looker Studio: To connect MySQL, which has already received data from Kondado, to Looker Studio, go to https://lookerstudio.google.com/navigation/reporting .

Click “Create” in the top left corner and select “Data Source”:

Next, choose “MySQL”:

Click “Authorize” to grant access to MySQL:

Choose a Google account to use Looker Studio with MySQL:

Fill in the necessary information, such as host name, database name, user, and password, and then click “Authenticate”.

In the “BASIC” option, fill in your MySQL database information and click “Authenticate”. If your database is protected by a firewall, you need to grant access to the IPs listed by Google on this page under “Observations”.

Select the table you want to connect to Looker Studio (1), name your data source (2), and then click “Connect”.

With the MySQL database connected, you can start exploring your data and create custom dashboards and reports, applying filters, aggregations, and visualizations as needed.

Done! Your MySQL database is now integrated with Looker Studio, allowing you to explore, analyze, and visualize your data more efficiently and intuitively.

Connect MySQL to Looker Studio

Centralize data in MySQL with Kondado and connect it to Looker Studio to build dashboards.

Register MySQL as a destination in Kondado

Create the data sources you want to replicate

Configure your sources — ads, CRM, e-commerce, ERPs — so Kondado knows what to extract.

Build pipelines into MySQL

Create a pipeline from each source to MySQL and set the replication schedule that fits your needs (the frequency you choose).

Allow Looker Studio IPs in your MySQL firewall

Add the Looker Studio IP ranges (listed in Google's documentation) to the firewall or security group of your MySQL host so Looker Studio can connect.

Create the MySQL data source in Looker Studio

In Looker Studio, click Create > Data Source, choose MySQL, enter host, database, user, and password, and click Authenticate.

Pick a table and build your report

Select the table Kondado is populating, click Connect, and start dragging fields into charts and tables to build your dashboard.

Frequently asked questions

What is MySQL and why is it commonly used for data storage?▼

MySQL is an open-source relational database management system known for its speed and reliability. It is used by developers, analysts, and organizations worldwide to store, organize, and retrieve data efficiently, making it a solid foundation for data integration initiatives.

What is Looker Studio and how does it help with data analysis?▼

Looker Studio is a modern and intuitive data analysis platform that allows you to explore, analyze, and share data insights in a visual and interactive way. You can turn raw data into valuable information, driving strategic decision-making in your organization through data visualization.

How do I register MySQL as a destination in Kondado?▼

First, you need to login to Kondado and register your database as a destination to receive data from your tools. Follow the step-by-step shown in Kondado's documentation to register your MySQL as a destination.

What are data sources in Kondado and how do I create them?▼

Data sources are the sources or tools from which you want to extract data to centralize in your data repository. To register your data sources in Kondado, visit the wiki and follow the respective step-by-step instructions for each tool you want to connect.

How do I connect MySQL to Looker Studio after centralizing data with Kondado?▼

Go to Looker Studio, click "Create" and select "Data Source", then choose "MySQL". Authorize access, fill in your database information (host name, database name, user, and password), authenticate, select your table, name your data source, and click "Connect". You can then explore your data and create custom dashboards.

What should I do if my MySQL database is protected by a firewall when connecting to Looker Studio?▼

If your database is protected by a firewall, you need to grant access to the IPs listed by Google on the Looker Studio connection page under "Observations". This ensures Looker Studio can securely connect to your MySQL database.

Written by

Thassyo Pereira·Published 2023-11-10·Updated 2026-04-26