Database connections (SQL Server, PostgreSQL) in Tableau - Cell-by-Cell Formula Trace

Sample Data

This table shows connection details for two database servers: one SQL Server and one PostgreSQL. Each row has server address, database name, username, password, and port.

Cell	Value
A1	Server
B1	Database
C1	Username
D1	Password
E1	Port
A2	sqlserver.example.com
B2	SalesDB
C2	user_sql
D2	pass123
E2	1433
A3	postgres.example.com
B3	MarketingDB
C3	user_pg
D3	pgpass456
E3	5432

Formula Trace

CONNECT_TO_DATABASE(Server, Database, Username, Password, Port)

Step 1: CONNECT_TO_DATABASE("sqlserver.example.com", "SalesDB", "user_sql", "pass123", 1433)

Step 2: CONNECT_TO_DATABASE("postgres.example.com", "MarketingDB", "user_pg", "pgpass456", 5432)

Cell Reference Map

   A                   B           C          D         E
1 | Server            | Database  | Username | Password | Port
2 | sqlserver.example.com | SalesDB  | user_sql | pass123 | 1433
3 | postgres.example.com  | MarketingDB | user_pg | pgpass456 | 5432

Arrows: Each row's cells feed into the CONNECT_TO_DATABASE function parameters.

The formula uses the connection details from each row: Server (A), Database (B), Username (C), Password (D), and Port (E).

Result

   A                   B           C          D         E           F
1 | Server            | Database  | Username | Password | Port | Connection Status
2 | sqlserver.example.com | SalesDB  | user_sql | pass123 | 1433 | Connected
3 | postgres.example.com  | MarketingDB | user_pg | pgpass456 | 5432 | Connected

The final result shows that Tableau successfully connected to both databases using the provided details.

Sheet Trace Quiz - 3 Questions

Which cell contains the port number for the PostgreSQL connection?

A D3

B E3

C B3

D C3

Key Result

CONNECT_TO_DATABASE(Server, Database, Username, Password, Port) establishes a connection using these parameters.