[Platform] ClickHouse Data Connection

Version

Application Scenario

ClickHouse is a column-oriented database management system (DBMS) for online analytical processing (OLAP) of queries.

This document describes how to connect to ClickHouse.

Version and Driver

Download the driver package and upload it to FineReport. For details, see section "Creating a Data Connection" in Driver Management.

Connection Information Collection

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

IP address and port number of the database server

Username and password of the database

Database mode

FineReport provides two data connection methods for you:

Method 1: Perform data connection in the designer. For details, see [Designer] JDBC Data Connetion.

Method 2. Perform data connection on the decision-making platform. This document mainly describes this method.

1. Log in to the decision-making platform as the admin, choose System Management > Data Connection > Data Connection Management, and click New 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 data connection management.

2. Find the ClickHouse icon, as shown in the following figure.

3. Click Custom, select the driver uploaded in section "Version and Driver", and enter the connection information collected in section "Connection Information Collection."

Click Click to Connect Database. If the connection is successful, you can select the pattern, as shown in the following figure.

Note:

You can optionally modify other advanced settings. For details, see Advanced Setting in Data Connections.

4. Click Save to save the data connection.

For details, see Dataset.