I. Overview
Huawei Cloud Data Warehouse Service (DWS) is an enterprise-level data warehouse product launched by Huawei Cloud. Its distributed parallel database kernel took six years to build and has been tested by hundreds of commercial sites under the cloud. It has the characteristics of high reliability, high performance, low cost, security and ease of use.
FineReport provides two ways to connect data:
Method 1: Connect to the database in the designer. For details, see [Designer]JDBC Connection.
Method 2: Connect to the data decision platform. This paper mainly introduces this way.
II. Data connection
1. Configuration information
| Drive | URL | Driver download address |
| org.postgresql.Driver | jdbc:postgresql://hostname:port/dbname |
2. Connection steps
1) Download the Huawei cloud DWS driver package from the configuration information driver download link, save the driver package to %FR_HOME%\webapps\webroot\WEB-INF\lib, and restart the report server.
2) The administrator logs in to the data decision system and clicks Manage>System>Data Connection>Data Connection Management, select New Data Connection, select Huawei Cloud DWS under All options, and click OK, as shown below:
Note: If non-administrator users want to configure data connection, the administrator must assign the permission of the data connection node in the management system to them. For details, see Data Connection Authorizatio.
3) Enter the data connection information in the configuration information format described in Section II . Advanced Settings are optional. For details, see [Platform] Data Connection. After input information, the interface is as follows:
4) Click Test Connection, or Click to Connect Database in mode. If the "Connection Successful" prompt box pops up, the database is successfully connected, as shown in the picture below:
5) Select the mode after the test connection is successful. Select the corresponding mode as required. Otherwise, the first mode will be selected by default. As shown below:
6) Click the Save button in the upper right corner after selecting the mode, and the data connection will be added successfully. As shown below:
