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.

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.