# Connect Tableau to Mitto

[Tableau](https://www.tableau.com/products/what-is-tableau) is a powerful data
visualization software. You can take the different sets of data you have
staged in Mitto and use Tableau to analyze that data in a uniform way.


You will need the following information to connect Tableau to Mitto:

- **Connection**: PostgreSQL 9.5 (Mitto 2) PostgreSQL 13.1 (Mitto 3)
- **Host**: (instance name).zuarbase.net
- **Port**: 5432
- **Name**: analytics

This information is available in Mitto.

First, go to Settings by clicking on **Database** on left-hand side of
page. The information is displayed under the header **Database Connectivity**.

.. image:: assets/connect-tableau-to-mitto__database.png
   :alt: Mitto database info

## Now you are ready to connect Tableau to Mitto.

1. Open Tableau Desktop.
1. Under the **Connect: To a Server**, select **More**. Click on **PostgreSQL**.

.. NOTE::

  You are connecting to the PostgreSQL server because this is the database
  with which Mitto is associated.
    
1. Fill out the prompt with the information from above. Username and password
   are the ones you used to login to your Mitto Instance and check "Require
   SSL". Click **Sign In**. Once you are signed in, you will see all the tables
   that exist in this database.

   .. image:: assets/connect-tableau-to-mitto__signin.png
      :alt: Tableau Sign In Window

1. Drag and drop any `<schema name>.<table name>` table over to the right hand side of the screen.
1. Select **Update Now**
1. Select **Sheet 1** and begin building your visualization.