Overview
Version
| FineBI Version | Functional Change |
|---|---|
6.0 | / |
Function Description
Hologres is an interactive analysis product developed by Alibaba. Compatible with the PostgreSQL 11 protocol and seamlessly integrated with the ecosystem of big data, Hologres provides high-concurrency and low-latency analytical processing of petabytes of data.
Hologres is designed to provide strong query services and large-scale computational storage of high performance and low cost. Hologres provides interactive query services and real-time data warehousing solutions that help manage large amounts of data.
Preparation
Version/Driver
| Driver Download | Driver |
|---|---|
org.postgresql.Driver |
Data connection URL format: jdbc:postgresql://Instance-id-region-endpoint-internal.hologres.aliyuncs.com:Port number/Dbname
Preparation
1. Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management. Click Save after successful upload, as shown in the following figure.
2. Before connecting the database, you need to collect the following information:
IP address and port number of the server where the database is located
Database name
Username and password of the database
Schema of the database to be connected
Connection Procedure
1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.
Note:
2. Select the Hologres database icon, as shown in the following figure.
3. According to the above-mentioned configuration information, enter the corresponding information for the database, and optionally enter advanced settings information, as shown in the following figure. (For details, see Entry-Level Data Connection Configuration.)
4. Click Test Connection or Click to Connect Database under Schema. If the test connection is successful, it means that the database is successfully connected, as shown in the following figure.
Adding Database Tables to FineBI
Two methods are available to add database tables to FineBI.
