Overview
Version
| FineBI | 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 Cloud DWS data connections), you must have manually uploaded the related drivers in the Driver Management area. |
Application Scenario
This document introduces how to connect to the HUAWEI Cloud DWS data source.
Preparation
Version/Driver
Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management.
| Version/Driver | Driver Package Download |
|---|---|
/ |
Connection Information Collection
Before connecting the database, you need to collect the following information:
Name and port number of the host where the database is located
Username and password of the database
Database name
Schema of the database to be connected
Connection Procedure
1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.
Note: If you are not the admin, you can configure data connections only after the admin assigns you the permission on Data Connection Management. For details, see Data Connection Permissions Overview.
2. Find the HUAWEI Cloud DWS icon, as shown in the following figure.
3. Select Custom from the Driver drop-down list, select the driver uploaded in section "Version/Driver", and enter the connection information collected in section "Connection Information Collection."
Note:
4. Click Click to Connect Database, and select the required schema after successful connection. Finally, save the data connection, as shown in the following figure.
Adding Database Tables to FineBI
Two methods are available to add database tables to FineBI.
