Data Connection to Pivotal Greenplum Database

Version

Application Scenario

Greenplum Database (GPDB) has various features. This document introduces how to connect to Pivotal Greenplum Database in FineBI.

Version/Driver

To use the PostgreSQL driver, the data connection URL is in the jdbc:postgresql://IP address:Port number/DB name?fineBIDialect=greenplum format.

To use the Greenplum driver, the data connection URL is in the jdbc:pivotal:greenplum://IP address:Port number;DatabaseName=xxx format.

Preparation

1. Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management. Click Save after successful upload, as shown in the following figure.

Before connecting the database, you need to collect the following information:

• IP address and port number of the database server

• Username and password of the database

1. Choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

2. Find the Pivotal Greenplum Database icon, as shown in the following figure.

3. Select the driver uploaded in section "Preparation" and enter the connection information collected in the section. You need to select the connection pattern of the Trino database. Schema is available after the database is connected by clicking Click to Connect Database. 

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets