Create a basic dashboard in Tableau using MySQL
Prerequisites
- Tableau server installation
- A MySQL server that hosts the database that you want to connect to Tableau
- Credentials of the MySQL server
- Basic schema to execute initial SQL statements
- MySQL drivers installed on the Tableau server
- The license of MySQL driver on the Tableau server
Steps to connect MySQL database
- Create new workbook
After logging into the Tableau server you will find an option to create a new project or workbook. You can select the option as per your requirements. If you create a new project, you will also need to create a new workbook in it.
2. Select Data Connector
Data Connectors in Tableau are basically different sources of data with which you can connect. You can find the different data connectors available on Tableau Server in the below image. For every data connector, we need to have the connector drivers installed on the server. To use any of the data connectors we also need to have the license for it. The license keys can be activated on the server from the Tableau Services Manager which is configured during the server installation.
3. Set up and connect to the database
After selecting the MySQL option from the connectors page, you will see a pop-up to enter your server credentials to connect to the server as shown below.
Read more: https://tudip.com/blog-post/create-a-basic-dashboard-in-tableau-using-mysql/
