I. Description
HP Vertica is a database based on column-based MPP (massively parallel processing) architecture. It can support storing structured data up to PB (Petabyte) level.
FineReport provides two data connection methods:
Method 1: Connect in the designer. For specific methods, please refer to: [Designer] JDBC data connection.
Method 2: Connect on the data decision platform. This article mainly introduces this way.
II. Data Connection
2.1 Configuration Information
| Driver | URL | Driver Download Link | Support Database Version |
|---|---|---|---|
| com.vertica.jdbc.Driver | jdbc:vertica://ip:port/databaseName | Vertica_7.2.1 |
2.2 Connection Steps
1) Download the HP Vertica 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) The administrator logs in to the data decision system, click Manage>Data Connection>Data Connection Management, click New Data Connection, and select HP Vertical under All options, as shown in the following figure:
Note: If a non-administrator user wants to configure a data connection, the administrator needs to assign the authority to the data connection node under the management system. For specific operations, please see Data Connection Authorization.
3) Enter the corresponding data connection information according to the configuration information format in section 2.1 of this article. The advanced settings are optional. For details, please refer to: [Platform] Data Connection. After entering the information, the interface is as shown in the figure below:
4) Click Test Connection, or click Click to Connect Database in the mode, 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 Save in the upper right corner, and the data connection is added successfully. As shown below:
