Data Connection to Hologres

Version

Function Description

Hologres is an interactive analysis product developed by Alibaba Cloud. Compatible with PostgreSQL and seamlessly integrated with the big data ecosystem, it supports high-concurrency and low-latency processing and analysis of petabyte-scale data.

Hologres is designed to provide strong query services and large-scale computational storage of high performance and low cost. It provides real-time data warehousing solutions that help manage large amounts of data and interactive query services.

Database Version and 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 the "Uploading the Database Driver" section in Driver Management. The following figure shows the driver upload page. Click Save after successful upload.

2. Before connecting FineBI to the database, you need to collect the following information:

• IP address and port number of the database server

• Database name

• Username and password of the database

• Schema of the database to be connected

1. Log in to the FineBI system as the admin, choose System Management > Data Connection > Data Connection Management, click Create, select Data Connection, as shown in the following figure.

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on the data connection module. For details, see Data Connection Permission Overview.

2. Select the Hologres database, as shown in the following figure.

3. Enter the connection information collected in the "Preparation" section. You can determine whether to configure Advanced Setting, as shown in the following figure. (For details, see Entry-Level Data Connection Configuration.)

4. Click Test Connection or Click to Connect Database in Schema. If the test connection is successful, the database is successfully connected, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding  SQL Datasets