I. Description
GaussDB is a relational database system developed by Huawei Technologies Co., Ltd. based on the open source database PostgreSQL9.2.
FineReport provides two data connection methods:
Method 1: Connect in the designer. For details, please refer to: [Designer] JDBC data connection .
Method 2: Connect on the Data Decision Platform. This article 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 GaussDB 200 driver package from the configuration information driver download link, and place the driver package under %FR_HOME%\webapps\webroot\WEB-INF\lib, and restart the report server.
2) Log in to the Data Decision System, select Manage >Data Connection>Data Connection Management, click New Data Connection, and select GaussDB 200 under All, as shown in the following figure:
Note: If a non-administrator user wants to configure a data connection, the administrator needs to assign it the authority of the data connection node under the management system. For specific operations, please refer to Data Connection Authorization.
3) Enter the corresponding data connection information according to the configuration information format in section
II.1 of this article. The advanced settings are optional. For details, please refer to: [Platform] Configure Data Connection.. After entering the information, the interface is as shown below:
4) Click Test Connection, if the 「Connection Successful」prompt box pops up, it means that the database is successfully connected, as shown in the following figure:
5) After the test connection is successful, you can select the pattern, and select the corresponding pattern according to your needs. If you do not select, the first pattern will be the default. As shown below:
6) After the pattern is selected, clickSavein the upper right corner, and the data connection is added successfully. As shown below: