> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MindsDB and Tableau

Tableau lets you visualize your data easily and intuitively. Now that MindsDB
supports the MySQL binary protocol, you can connect it to Tableau and see the
forecasts.

## How to Connect

Follow the steps below to connect your MindsDB to Tableau.

First, create a new workbook in Tableau and open the *Connectors* tab in the
*Connect to Data* window.

<p align="center">
  <img src="https://mintcdn.com/mindsdb/tkxKy44mj_2VlYcf/assets/connect_tableau.png?fit=max&auto=format&n=tkxKy44mj_2VlYcf&q=85&s=f63b96ce2d485d4d263183a70f06b321" width="1412" height="752" data-path="assets/connect_tableau.png" />
</p>

Next, choose *MySQL* and provide the details of your MindsDB connection, such as
the IP, port, and database name. Optionally, you can provide a username and
password. Then, click *Sign In*.

<p align="center">
  <img src="https://mintcdn.com/mindsdb/tkxKy44mj_2VlYcf/assets/connect_tableau_2.png?fit=max&auto=format&n=tkxKy44mj_2VlYcf&q=85&s=e32ba274a537b4e5e030e6067760f9f6" width="1004" height="580" data-path="assets/connect_tableau_2.png" />
</p>

Here are the connection parameters:

```text theme={null}
Host: `localhost`
Port: `47335`
Database name: `mindsdb`
Username: `mindsdb`
Password: *leave it empty*
```

<Tip>
  You can [set up the authetication with user and password in the config file](/setup/custom-config#auth).
</Tip>

Now you're connected!

## Overview of MindsDB in Tableau

The content of your MindsDB is visible in the right-side pane.

<p align="center">
  <img src="https://mintcdn.com/mindsdb/U8_C23ppbMIBDBSs/assets/connect_tableau_3.png?fit=max&auto=format&n=U8_C23ppbMIBDBSs&q=85&s=f30b8d8907b70f9cc82c02c0fc9e1182" width="788" height="735" data-path="assets/connect_tableau_3.png" />
</p>

All the predictors are listed under the *Table* section. You can also switch
between the integrations, such as *mindsdb* or *files*, in the *Database*
section using the drop-down.

<p align="center">
  <img src="https://mintcdn.com/mindsdb/U8_C23ppbMIBDBSs/assets/connect_tableau_4.png?fit=max&auto=format&n=U8_C23ppbMIBDBSs&q=85&s=f75cb5fa999a93f5eccc6ff8c84dca48" width="243" height="620" data-path="assets/connect_tableau_4.png" />
</p>

Now, let's run some examples!

## Examples

### Example 1

Previewing one of the tables from the *mysql* integration:

<p align="center">
  <img src="https://mintcdn.com/mindsdb/U8_C23ppbMIBDBSs/assets/connect_tableau_5.png?fit=max&auto=format&n=U8_C23ppbMIBDBSs&q=85&s=72fcf93c55143bcad032dd880881ef90" width="1412" height="738" data-path="assets/connect_tableau_5.png" />
</p>

### Example 2

There is one technical limitation. Namely, we cannot join tables from different
databases/integrations in Tableau. To overcome this challenge, you can use
either views or custom SQL queries.

* Previewing a view that joins a data table with a predictor table:

<p align="center">
  <img src="https://mintcdn.com/mindsdb/U8_C23ppbMIBDBSs/assets/connect_tableau_6.png?fit=max&auto=format&n=U8_C23ppbMIBDBSs&q=85&s=931b15d05dbc4da9fe14801e60793d50" width="1407" height="735" data-path="assets/connect_tableau_6.png" />
</p>

* Using a custom SQL query by clicking the *New Custom SQL* button in the
  right-side pane:

<p align="center">
  <img src="https://mintcdn.com/mindsdb/U8_C23ppbMIBDBSs/assets/connect_tableau_7.png?fit=max&auto=format&n=U8_C23ppbMIBDBSs&q=85&s=a43c34ab3b66a94976ef97cd09434e1f" width="1410" height="734" data-path="assets/connect_tableau_7.png" />
</p>

## What's Next?

Now that you are all set, we recommend you check out our **Tutorials** and
**Community Tutorials** sections, where you'll find various examples of
regression, classification, and time series predictions with MindsDB.

To learn more about MindsDB itself, follow the guide on
[MindsDB database structure](/sql/table-structure/). Also, don't miss out on the
remaining pages from the **SQL API** section, as they explain a common SQL
syntax with examples.

<Tip>
  **From Our Community**

  Check out the articles and video guides created by our community:

  * Article on [Predicting & Visualizing Hourly Electricity Demand in the US with MindsDB and Tableau](https://teslimodus.medium.com/predicting-visualizing-hourly-electricity-demand-in-the-us-with-mindsdb-and-tableau-126d1c74d860)
    by [Teslim Odumuyiwa](https://teslimodus.medium.com/)

  * Article on [Predicting & Visualizing Petroleum Production with MindsDB and Tableau](https://dev.to/tesprogram/predicting-visualizing-petroleum-production-with-mindsdb-and-tableau-373f)
    by [Teslim Odumuyiwa](https://github.com/Tes-program)

  * Article on [Predicting & Visualizing Gas Prices with MindsDB and Tableau](https://dev.to/tesprogram/predicting-visualizing-gas-prices-with-mindsdb-and-tableau-d1p)
    by [Teslim Odumuyiwa](https://github.com/Tes-program)

  * Article on [How To Visualize MindsDB Predictions with Tableau](https://dev.to/ephraimx/how-to-visualize-mindsdb-predictions-with-tableau-2bpd)
    by [Ephraimx](https://dev.to/ephraimx)

  * Video guide on [Connecting MindsDB to Tableau](https://www.youtube.com/watch?v=eUiBVrm85v4)
    by [Alissa Troiano](https://github.com/alissatroiano)

  * Video guide on [Visualizing prediction result in Tableau](https://youtu.be/4aio-8kNbOo) by
    [Teslim Odumuyiwa](https://github.com/Tes-program)
</Tip>

Have fun!