Skip to main content

Connect to Tableau using Postgres Proxy

Note

The Tableau web app is not supported at this time. These instructions are written using the Tableau Desktop Client for Mac.

The following steps will walk you though connecting to Tableau using Postgres Proxy:

  1. Get your read/write API key for data.world. It is found on your profile settings. Additional help is available here.

    api_token.png
  2. Open Tableau Desktop.

  3. Under Connect scroll down to To a Server and click More….

    connect_to_Tableau_server.png
  4. Search for ODBC, and then select Other Databases (ODBC).

    Postgres_Proxy_ODBC.png
  5. In the prompt, select the following options.

    Driver: PostgreSQL Unicode

    postgres_proxy_driver.png

    server: postgres.data.world for private instances and multi-tenant customers. For single-tenant customers, use postgres.<your_customer_name>.data.world.

    port: 5432

    database: The owner and name of the dataset in the format owner/name. You can find this information in the url for the dataset:

    dataset_id.png

    username: Your username for data.world. you must use your username and not the name of your organization regardless of who owns the dataset you use because the username is associated with the API token. Your username is shown in your profile information:

    agentid.png

    password: LEAVE THIS FIELD BLANK

    string extras: Enter password=<your api key from your settings page>

    Note

    Do not put quotes around the value in the String Extras field.

    ODBC_configuration.png
  6. Click Sign In.

In Tableau you should now be able to see the files from your dataset:

Tableau_1.png
Tableau_2.png
Tableau_3.png

Additional information on ODBC connections with Tableau desktop is available here.