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.
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
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
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”.
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.