Data Connection to Pivotal Greenplum Database

Version

Application Scenario

Database Version and 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 the "Uploading the Database Driver" section in Driver Management. The following figure shows the driver upload page. Click Save after successful upload.

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

• IP address and port number of the database server

• Username and password of the database

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 schema of the Trino database. Schema is available after the database is connected by clicking Click to Connect Database, as shown in the following figure.

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

• Adding Database Tables

• Adding SQL Datasets