How to connect Tableau to AnalyticDB for PostgreSQL-AnalyticDB(AnalyticDB)-阿里云帮助中心

This topic describes how to connect Tableau to AnalyticDB for PostgreSQL to visualize and analyze your data.

Background

Tableau is a secure and flexible end-to-end data analytics platform that offers a full suite of features, from data connection to collaboration. You can connect Tableau directly to AnalyticDB for PostgreSQL to visualize and analyze your data.

Prerequisites

An AnalyticDB for PostgreSQL instance is required.

Procedure

Download and install Tableau.

Download the appropriate Tableau client from the Tableau official website and follow the on-screen instructions to install it. This topic uses Tableau Desktop on Windows as an example.
Configure the TDC file.

For optimal performance and user experience, configure a Tableau Datasource Customization (TDC) file to customize the connection to your AnalyticDB for PostgreSQL data source.
1. Download the Tableau Datasource Customization (TDC) file.
2. Copy the TDC file to the following directory: My Tableau Repository\Datasources. You can search for this directory if you cannot find it.
3. Restart Tableau Desktop.
For more information about TDC files, see Tableau Help.

Connect to the AnalyticDB for PostgreSQL instance.

After installation, open Tableau Desktop.

In the left navigation pane, in the Connect > To a Server section, click More and select PostgreSQL. Configure the connection parameters for your AnalyticDB for PostgreSQL instance.

The following table describes the parameters.

Parameter	Description
Server	The public endpoint of your AnalyticDB for PostgreSQL instance. You can find the public endpoint in the Database Connection Information section on the Basic Information page of your instance.
Port	The public port of your AnalyticDB for PostgreSQL instance. You can find the public port in the Database Connection Information section on the Basic Information page of your instance.
Database	The name of the database that you created in your AnalyticDB for PostgreSQL instance.
Authentication	Select Username and Password.
Username	The AccessKey ID of your Alibaba Cloud account. Click AccessKey Management to obtain your AccessKey ID.
Password	The AccessKey Secret of your Alibaba Cloud account. Click AccessKey Management to obtain your AccessKey Secret.
Require SSL	Clear this checkbox.

Click Log On.

Visualize and analyze data in Tableau.

After connecting Tableau to your AnalyticDB for PostgreSQL instance, you can visualize and analyze your table data. For more information, see Getting started with Tableau.