# Connect Tableau to Zuar Runner

[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 Zuar Runner and use Tableau to analyze that data in a uniform way.


You will need the following information to connect Tableau to Zuar Runner:

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

This information is available in Zuar Runner.

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: Zuar Runner database info

## Now you are ready to connect Tableau to Zuar Runner.

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 Zuar Runner is associated.
    
1. Fill out the prompt with the information from above. Username and password
   are the ones you used to login to your Zuar Runner 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.