Data Connection to Dameng

Version

Function Description

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

This document introduces how to connect to ClickHouse.

Version/Driver

Download the driver package and upload it to FineBI. For details, see section "Uploading the Database Driver" in Driver Management.

Connection Information Collection

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

• IP address and port number of the server where the database is located

• Username and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, click Create, and 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 Data Connection Management. For details, see Data Connection Permission Overview.

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

3. Select Custom from the Driver drop-down list, select the driver uploaded in section "Version/Driver", and enter the connection information collected in section "Connection Information Collection."

Click Click to Connect Database, and select the required schema after successful connection.

Note:

For FineBI of versions earlier than 5.1.19, you need to manually change the driver name to cc.blynk.clickhouse.ClickHouseDriver.

Note:

You can optionally modify other advanced settings. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Save to save the data connection.

During data connection, if the error message "ClickHouse response without column names" is displayed, you can suffix the URL with ? compress=false, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL datasets