All Products
Search

This Product

    AnalyticDB:Use FineBI to connect to AnalyticDB for PostgreSQL

    Document Center

    AnalyticDB:Use FineBI to connect to AnalyticDB for PostgreSQL

    Last Updated:Nov 08, 2024

    AnalyticDB for PostgreSQL is built on the open source Greenplum database. It is compatible with the syntax, interfaces, and ecosystems of both Greenplum and PostgreSQL. This topic describes how to use FineBI to connect to AnalyticDB for PostgreSQL.

    Prerequisites

    • FineBI is downloaded and installed.

    • An AnalyticDB for PostgreSQL instance is created.

    • The IP address of the server where FineBI resides is added to a whitelist of the AnalyticDB for PostgreSQL instance.

    Usage notes

    The first time you connect to AnalyticDB for PostgreSQL, you must download and install the Java Database Connectivity (JDBC) driver.

    Procedure

    1. Start the FineBI client.

    2. In the left-side navigation pane, choose Manage > Data Connection > Data Connection Management.

    3. On the Data Connection tab, click New Data Connection. Select Pivotal Greenplum Database.

    4. On the Data Connection tab, specify parameters such as URL, Username, and Password.

      Parameter

      Description

      Example

      Driver

      The driver code.

      org.postgresql.Driver

      URL

      The connection information of the AnalyticDB for PostgreSQL instance. The URL format varies based on the driver. For more information, see the "Configuration information of the FineBI driver" section of this topic.

      Note

      • You can view the endpoint on the Basic Information page of the AnalyticDB for PostgreSQL console.

      • If FineBI is not located in the same zone as the AnalyticDB for PostgreSQL instance, you must use a public endpoint to connect to the instance.

      • The default port number of AnalyticDB for PostgreSQL is 3432.

      jdbc:postgresql://gp-bpxxxxxxxxxxxxxx.gpdb.rds.aliyuncs.com:3432/dbname

      Code

      The connection code. By default, Automatic is selected.

      -

      Username

      The database account that is used to connect to the AnalyticDB for PostgreSQL instance.

      adbpgname

      Password

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

      adbpgpassword

      Table 1. Configuration information of the FineBI driver

      Driver code

      URL

      Supported database version

      org.postgresql.Driver

      jdbc:postgresql://Endpoint:Port/Database name

      4.3.9 and 5.0

      com.pivotal.jdbc.GreenplumDriver

      jdbc:pivotal:greenplum://Endpoint:Port;DatabaseName=Database name

    5. Click Test Connection.

      Note

      If the connection test fails, you can modify the parameter configuration as prompted.

    6. After the connection test passes, click Save in the upper-right corner.