How to configure connection to ClickHouse in FineBI V6.0?

Recently, at work, I often encounter a question about the connection FineBI V6.0 To clickhouse- columnar database management system (DBMS) for online processing of analytical queries (OLAP). Get step by step instructions.

Installing the ClickHouse Driver

We will use official driver by ClickHouse

You can find the current, official driver on the page https://github.com/ClickHouse/clickhouse-java/releases
As of the date of writing the article, the driver called clickhouse-jdbc-0.4.6.jar is relevant, we will use it.

Direct link to driver version 0.4.6 dated May 2, 2023 https://github.com/ClickHouse/clickhouse-java/releases/download/v0.4.6/clickhouse-jdbc-0.4.6.jar

1. Manage → Data Connection Management → Driver Management

2. Choose New Driver

3. Fill in the Driver Name field and click OK

4. Click Upload File and upload the previously downloaded clickhouse-jdbc-0.4.6.jar file

5. After loading the driver, check the value in the Driver field and click Save

On disk, your driver is located in the folder …/webapps/webroot/WEB-INF/drivers/ClickHouse/clickhouse-jdbc-0.4.6.jar

Creating a connection to ClickHouse

1. Manage → Data Connection Mangment → New Data Connection

In section All find clickhouse.

Fill in the fields:

Data Connection Name: specify the connection name
driver: choose type Custom and specify our driver com.clickhouse.jdbc.ClickHouseDriver (driver name)

IMPORTANT! Database Name: leave empty

host: name or ip address your ClickHouse server
port: port on which you connect, in our case we use http port 8123. If your ClickHouse is configured to connect using SSL, then you need to specify https port 8443
username: username to connect to ClickHouse
Password: the password of the above user

Click on Click to Connect Databaseif the connection was successful, then in the field below you can select database to which you need to connect

We save our connection.