Bird
Raised Fist0
Tableaubi_tool~5 mins

Database connections (SQL Server, PostgreSQL) in Tableau - Cheat Sheet & Quick Revision

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Recall & Review
beginner
What is the first step to connect Tableau to a SQL Server database?
Open Tableau, select 'Connect to Data', then choose 'Microsoft SQL Server' from the list of connectors. Enter the server name and authentication details.
Click to reveal answer
beginner
How do you connect Tableau to a PostgreSQL database?
In Tableau, select 'Connect to Data', then choose 'PostgreSQL'. Enter the server address, database name, username, and password to establish the connection.
Click to reveal answer
intermediate
What authentication methods can you use when connecting Tableau to SQL Server?
You can use Windows Authentication (integrated security) or SQL Server Authentication (username and password).
Click to reveal answer
intermediate
Why is it important to know the database server's port number when connecting Tableau to PostgreSQL?
Because PostgreSQL listens on a specific port (default 5432), and Tableau needs this port to communicate with the database server correctly.
Click to reveal answer
beginner
What is a live connection in Tableau when connecting to SQL Server or PostgreSQL?
A live connection means Tableau queries the database directly in real-time, showing the most current data without storing it locally.
Click to reveal answer
Which Tableau connector should you select to connect to a SQL Server database?
AMySQL
BPostgreSQL
CMicrosoft SQL Server
DOracle
What default port does PostgreSQL use that you might need to specify in Tableau?
A5432
B1433
C3306
D1521
Which authentication method uses your Windows login credentials to connect Tableau to SQL Server?
ASQL Server Authentication
BWindows Authentication
COAuth
DBasic Authentication
What does a live connection in Tableau mean?
ATableau queries the database in real-time
BData is refreshed once a day
CData is imported and stored in Tableau
DData is exported to Excel
Which information is NOT required to connect Tableau to PostgreSQL?
AServer address
BDatabase name
CUsername and password
DTableau workbook file path
Describe the steps to connect Tableau to a SQL Server database.
Think about what information Tableau needs to reach the database.
You got /5 concepts.
    Explain the difference between a live connection and an extract in Tableau when connecting to databases like PostgreSQL.
    Consider how Tableau accesses and stores data in each mode.
    You got /4 concepts.

      Practice

      (1/5)
      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
      Recommended

      Ready to prove it?

      Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

      10 questions~5 mineasy hard