Database connections (SQL Server, PostgreSQL) in Tableau - Step-by-Step Guide

Introduction

This feature helps you connect Tableau to databases like SQL Server and PostgreSQL. It lets you bring your data into Tableau so you can create reports and dashboards easily.

When you want to analyze sales data stored in a SQL Server database.

When your marketing data is in PostgreSQL and you need to build visual reports.

When you want to combine data from your company database with other sources in Tableau.

When you need live data updates from your database in your Tableau dashboards.

When you want to explore data without exporting it manually from your database.

Steps

Step 1: Open Tableau Desktop

- Start page

You see options to connect to data sources including databases

Step 2: Click 'More' under 'To a Server' section

- Connect pane on the left

A list of database connectors appears

Step 3: Select 'Microsoft SQL Server' or 'PostgreSQL' from the list

- Database connectors list

Connection dialog box for the selected database opens

Step 4: Type the server name or IP address in the 'Server' field

- Connection dialog box

Server field is filled with your database location

Step 5: Enter your database username and password

- Authentication section of the connection dialog

Credentials are set for database access

Step 6: Click 'Sign In' or 'Connect'

- Connection dialog box

Tableau connects to the database and shows available tables

Step 7: Drag a table to the canvas to start building your data source

- Data source page

Table data preview appears and you can start creating visualizations

Before vs After

Before

Tableau shows only sample data sources and no connection to your company database

After

Tableau shows tables from your SQL Server or PostgreSQL database ready for analysis

Settings Reference

Server

📍 Connection dialog box

Specifies the database server to connect to

Authentication

📍 Connection dialog box

Defines how Tableau logs into the database

Default: Username and Password

Database

📍 Connection dialog box after server connection

Selects which database to use on the server

Default: Default database for user

Port

📍 Connection dialog box (optional)

Specifies the network port for the database connection

Default: 1433 for SQL Server, 5432 for PostgreSQL

Common Mistakes

Entering incorrect server name or IP address

Tableau cannot find the database server and connection fails

Verify the exact server name or IP address with your database administrator before entering

Using wrong username or password

Authentication fails and Tableau cannot access data

Use valid credentials provided by your database admin and check for case sensitivity

Not specifying the correct port when the database uses a non-default port

Connection attempts time out or fail

Ask your admin for the correct port and enter it in the connection settings

Summary

You can connect Tableau directly to SQL Server and PostgreSQL databases to use live data.

Enter the server, credentials, and database details carefully to establish the connection.

Once connected, you can drag tables into Tableau to start creating reports and dashboards.

Practice

1. What is the main purpose of connecting Tableau to a database like SQL Server or PostgreSQL?

easy

A. To access and visualize live data directly from the database

B. To create new tables inside the database

C. To backup the database automatically

D. To write SQL code inside Tableau

Solution

1. Step 1: Understand Tableau's connection role

   Tableau connects to databases to fetch data for analysis and visualization.

2. Step 2: Identify the main use of connection

   The connection allows Tableau to access live data, not to modify or backup it.

3. Final Answer:

   To access and visualize live data directly from the database -> Option A

4. Quick Check:

   Database connection = live data access [OK]

Hint: Think: Tableau reads data, not changes it [OK]

Common Mistakes:

• Confusing data access with data modification
• Assuming Tableau creates or backs up database tables
• Believing Tableau writes SQL code inside itself

2. Which of the following is the correct way to specify the server name when connecting Tableau to a PostgreSQL database?

easy

A. port=localhost;server=5432

B. server=5432;port=localhost

C. server=localhost;port=5432

D. localhost=server;5432=port

Solution

1. Step 1: Identify correct server and port syntax

   Server name is usually a hostname or IP, port is a number; for PostgreSQL default port is 5432.

2. Step 2: Match correct key-value pairs

   Correct format is server=localhost;port=5432, meaning server is localhost and port is 5432.

3. Final Answer:

   server=localhost;port=5432 -> Option C

4. Quick Check:

   Server=host; Port=number [OK]

Hint: Server is name, port is number; order matters [OK]

Common Mistakes:

• Swapping server and port values
• Using port as a hostname
• Incorrect key-value syntax

3. Given the following Tableau connection details to SQL Server:
Server: sqlserver.company.com
Database: SalesDB
User: analyst
Password: correct_password
What will happen if the password is incorrect?

medium

A. Tableau will show an authentication error and fail to connect

B. Tableau will connect but show empty data

C. Tableau will connect but only show partial data

D. Tableau will connect and ignore the password

Solution

1. Step 1: Understand authentication in database connections

   Tableau requires correct credentials to connect; wrong password blocks access.

2. Step 2: Identify expected behavior on wrong password

   Connection fails with an authentication error; no data is retrieved.

3. Final Answer:

   Tableau will show an authentication error and fail to connect -> Option A

4. Quick Check:

   Wrong password = connection error [OK]

Hint: Wrong password stops connection, no data shown [OK]

Common Mistakes:

• Assuming connection succeeds with wrong password
• Thinking Tableau shows partial or empty data
• Ignoring authentication errors

4. You try to connect Tableau to a PostgreSQL database but get an error: Could not connect to server: Connection refused. What is the most likely cause?

medium

A. The database name is misspelled

B. The password is incorrect

C. Tableau does not support PostgreSQL connections

D. The server name or IP address is incorrect or unreachable

Solution

1. Step 1: Analyze the error message

   "Connection refused" means Tableau cannot reach the server at the network level.

2. Step 2: Identify common network causes

   Incorrect server name or unreachable IP causes connection refusal before authentication.

3. Final Answer:

   The server name or IP address is incorrect or unreachable -> Option D

4. Quick Check:

   Connection refused = server unreachable [OK]

Hint: Connection refused means server not reachable [OK]

Common Mistakes:

• Assuming wrong password causes connection refused
• Thinking misspelled database name causes connection refused
• Believing Tableau cannot connect to PostgreSQL

5. You want to create a live connection in Tableau to a SQL Server database named FinanceDB hosted on finance.company.com using Windows Authentication. Which steps should you follow to set this up correctly?

hard

A. Select PostgreSQL connector, enter finance.company.com as server, use SQL Authentication, then connect

B. Select SQL Server connector, enter server as finance.company.com, database as FinanceDB, choose Windows Authentication, then connect

C. Select SQL Server connector, enter FinanceDB as server, leave database blank, use Windows Authentication, then connect

D. Select SQL Server connector, enter finance.company.com as server, database as FinanceDB, use SQL Authentication with blank password, then connect

Solution

1. Step 1: Choose correct connector and enter server details

   Use SQL Server connector and enter the server name as finance.company.com.

2. Step 2: Specify the database and authentication method

   Enter database name FinanceDB and select Windows Authentication for login.

3. Step 3: Connect to establish live connection

   Click connect to access live data from FinanceDB using Windows credentials.

4. Final Answer:

   Select SQL Server connector, enter server as finance.company.com, database as FinanceDB, choose Windows Authentication, then connect -> Option B

5. Quick Check:

   Correct connector + server + database + auth = successful connection [OK]

Hint: Match connector and auth type to server and database [OK]

Common Mistakes:

• Using wrong connector for SQL Server
• Mixing authentication types incorrectly
• Entering database name as server