Overview
Version
| FineBI Version | Functional Change |
|---|---|
6.0 | / |
6.0.18 | Removed the driver related to PostgreSQL from fine-bi-engine-third-6.0.jar in FineBI V6.0.18 and later versions. To use related data connections (such as PostgreSQL and Huawei DWS data connections), you must ensure that you have manually uploaded the related drivers through Driver Management. |
Application Scenario
This document introduces how to connect to the PostgreSQL database.
Preparation
Version/Driver
Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management.
| Supported Database Version | Driver Package |
|---|---|
PostgreSQL 9.2.3/9.4.7/9.5.0/9.5.2/9.6.0/12 | Download the latest PostgreSQL driver. |
Connection Information Collection
Before connecting the database, you need to collect the following information:
IP address and port number of the database server
Database name
Username and password of the database
Schema of the database to be connected
Connection Procedure
1. Log in to FineBI, choose System Management > Data Connection > Data Connection Management, click New Data Connection, and select the PostgreSQL icon, as shown in the following figure.
Note:
2. Enter the connection information collected in section "Connection Information Collection." Select Custom from the Driver drop-down list and select the driver uploaded in section "Version/Driver".
Schema is available after the database is connected by clicking Click to Connect Database, as shown in the following figure.
3. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.
Adding Database Tables to FineBI
Two methods are available to add database tables to FineBI.
