All Products
Search

This Product

    AnalyticDB:Use Tableau to connect to AnalyticDB for PostgreSQL

    Document Center

    AnalyticDB:Use Tableau to connect to AnalyticDB for PostgreSQL

    Last Updated:Jun 21, 2024

    This topic describes how to connect to AnalyticDB for PostgreSQL for visualized data analysis by using Tableau.

    Background information

    Tableau is a secure and flexible end-to-end data analysis platform that provides a complete set of features from connection to collaboration. You can use Tableau to connect to AnalyticDB for PostgreSQL and analyze data in a visualized manner.

    Prerequisites

    An AnalyticDB for PostgreSQL instance is created as the data source.

    Procedure

    1. Download and install Tableau.

      Download a Tableau client from the Tableau official website based on your business requirements and install the client. In this example, the Windows-based Tableau Desktop is used.

    2. Configure a Tableau Datasource Customization (TDC) file.

      To ensure an optimal connection to the AnalyticDB for PostgreSQL data source for better performance and user experience, perform the following steps to configure the TDC file:

      1. Download the TDC file.

      2. Copy the TDC file and save the file in the following default directory: My Tableau repository\Data source\. You can search for keywords to find the default directory.

      3. Restart Tableau Desktop.

      For more information about the TDC file, see Tableau Help.

    3. Connect to the AnalyticDB for PostgreSQL instance.

      1. Start Tableau Desktop.

      2. In the left-side navigation pane, choose Connect > To a Server > More. On the right side of the page, select PostgreSQL. In the PostgreSQL dialog box, configure parameters for the AnalyticDB for PostgreSQL instance.

        The following table describes the parameters.

        Parameter

        Description

        Server

        The public endpoint that is used to connect to the AnalyticDB for PostgreSQL instance.

        You can obtain the public endpoint from the Database Connection Information section of the Basic Information page.

        Port

        The public port number that is used to connect to the AnalyticDB for PostgreSQL instance.

        You can obtain the port number from the Database Connection Information section of the Basic Information page.

        Database

        The name of the database in the AnalyticDB for PostgreSQL instance.

        Authentication

        The authentication method. Select Username and Password from the drop-down list.

        Username

        The AccessKey ID of your Alibaba Cloud account.

        You can obtain the AccessKey ID from the Security Management page.

        Password

        The AccessKey secret of your Alibaba Cloud account.

        You can obtain the AccessKey secret from the Security Management page.

        Require SSL

        Specifies whether to connect to the AnalyticDB for PostgreSQL instance by using SSL certificates. Do not select this check box.

      3. Click Sign In.

    4. Analyze data in a visualized manner by using Tableau Desktop.

      After you use Tableau to connect to AnalyticDB for PostgreSQL, you can analyze existing table data in a visualized manner. For more information, see Getting started with Tableau.