I. Description
Postgresql is a powerful open source database system. After more than 15 years of active development and continuous improvement, Postgresql has gained a high reputation in the industry for reliability, stability, and data consistency.
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 link | Support database version |
|---|---|---|---|
| org.postgresql.Driver | jdbc:postgresql://hostname:port/dbname | postgresql_9.2.3；9.4.7；9.5.0；9.5.2；9.6.0；12 |
Note: The V12 does not support stored procedure currently.
2.Connection steps
1) Download the Postgresql driver package from the configuration information driver download link. Users can also choose to download the driver package under the Official link . According to the database version, download the driver version corresponding to JDBC4.0, and place the driver package in %FR_HOME%\ Under webapps\webroot\WEB-INF\lib, 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 Postgresql 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 mode, and select the corresponding mode according to your needs. If you do not select, the first mode will be the default. As shown below:
6) After the mode is selected, click the Save button in the upper right corner, and the data connection is added successfully. As shown below:
