HP Vertica data connection

HP Vertica is a database based on the column-based MPP (massively parallel processing) architecture, which can support the storage of structured data up to PB (Petabyte) level.

The following describes how to connect to the HP Vertica database in FineBI.

2.1 Configuration information

2.2 Steps

• Download the HP Vertica driver from the download link above, and place the driver under %FineBI%\webapps\webroot\WEB-INF\lib, and restart FineBI;

• Log into the data decision system, select "Manage>Data Connection>Data Connection Management", click "New Data Connection", and select "HP Vertica" under "All", as shown in the following figure:

• According to the configuration information provided above, enter the corresponding information of the database, and you can choose to fill in the advanced setting information (for related introduction, please refer to: Configure Data Connection), as shown in the following figure:

• Click "Test Connection", or click "Click to Connect Database" in the "Pattern", if the test connection is successful, it means that the database is successfully connected, as shown in the following figure:

• 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:

• After the pattern is selected, click "Save" in the upper right corner, and the data connection is added successfully. As shown below: