Connect to Tableau for Windows using Postgres-Proxy
Note
This page walks you through the Postgres Proxy setup for Tableau for Windows. For Tableau for Mac, refer to Connect to Tableau using Postgres Proxy.
Create an ODBC data source
Before you connect Tableau Desktop for Windows to data.world with Postgres Proxy, you will first need to create an OBDC Data source.
Follow these steps to create the data source:
In your Windows search bar, search for ODBC Data Sources and select ODBC Data Sources (64-bit).
Windows opens the ODBC Data Source Administrator modal. Navigate to the User DSN tab.
From the User DSN tab, select Add. Windows opens a new Create New Data Source window.
In the Create New Data Source window, select a PostgreSQL ODBC drive option, then click Finish.
Windows opens the PostgreSQL {ANSI/Unicode/Other} ODBC Driver (psqlODBC) Setup window. You can select any option, though data.world recommends a Unicode option to prevent issues with international characters.
On the ODBC driver setup window, you'll need to enter values for Data Source, Database, Server, User Name, SSL mode, and Port. The following table lists all values in the setup window:
Table 1.Item
Required
Details
Data Source
Yes
A descriptive name for the Data Source.
Database
Yes
The data.world Owner and Dataset that will be the source of data for this connection in the format owner/dataset.
The Owner may be an Organization or Individual user. You can retrieve the value from the dataset's URL.
Server
Yes
The data.world server to establish the connection with.
For Multi-tenant users, the value will be
postgres.data.world
.For Private Instance users, the value will be
postgres.data.world
.For Single-tenant or VPC users, the value will be
postgres.{organization-site}.data.world
.Replace {organization-site} with the subdomain value of your data.world URL, <https://{organization-site}.data.world>.
User Name
Yes
The data.world username for the user credentials establishing the connection. Enter the username for the data.world account with access to the dataset listed in Database, likely your own or that of a service account.
SSL Mode
Yes
The SSL connection type. Set to Allow.
Port
Yes
Set to 5432. This is the port used in the connection to the host server.
Description
No
An optional description of the ODBC Data Source being created.
Password
No
Leave this field blank.
Once you've completed all fields, select Datasource. A new Advanced Options window appears. Select Page 3.
On Page 3, enter
password=<api-token>
, entering your API token after password=. Click Connection test.When the Connection successful message appears, select OK. Ignore the MSDTC error, if it appears.
Windows returns you to the Advanced Options window. Click OK.
Windows returns you to the PostgreSQL ODBC Driver Setup page. Finishing configuring any remaining values, then click Save, followed by Test.
You should now see the new ODBC Data source listed on the User DSN tab.
Connect Tableau Desktop to your data.world dataset
Now that you've finished setting up an ODBC Data source, follow these steps to connect Tableau to your targeted dataset.
In Tableau Desktop, find Connect to a server > Other Databases (ODBC).
The Other Databases (ODBC) modal window appears. Choose the PostgreSQL ODBC User Data Source you just created, then click Connect.
Tableau processes the connection and populates the Connection Attributes section with values. Leave the values unchanged, then click Sign In.
Tableau then connects you to the data.world dataset.