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:
Get your read/write API key for data.world. It is found on your profile settings. Additional help is available here.
Open Tableau Desktop.
Under Connect scroll down to To a Server and click More….
Search for ODBC, and then select Other Databases (ODBC).
In the prompt, select the following options.
Driver:
PostgreSQL Unicode
server:
postgres.data.world
for private instances and multi-tenant customers. For single-tenant customers, usepostgres.<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: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:
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.Click Sign In.
In Tableau you should now be able to see the files from your dataset:



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