Overview
Version
FineDataLink Version | Functional Change |
---|---|
3.2 | Scheduled Task supported data reading from the ClickHouse database. |
3.7 | Scheduled Task supported data writing into the ClickHouse database. |
4.0.28 | Pipeline Task supported data writing into the ClickHouse database. |
4.1.6.3 | Data Service supported the ClickHouse database. |
4.1.13.3 | Real-time data development tasks supported data writing into the ClickHouse database. |
Function Description
ClickHouse is a column-oriented database management system (DBMS) for online analytical processing (OLAP) of queries.
FineDataLink supports connection to the ClickHouse database for data reading and writing using scheduled tasks, data writing using pipeline tasks, data writing using real-time tasks, and for releasing data services.

Preparation
Prerequisite
For details, see Overview of Data Connection.
Version and Driver
Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see Driver Management.
Supported Database Version | Driver Package |
---|---|
20.1 | clickhouse.zip |
22.6 | clickhouse4j-1.4.4-SNAPSHOT.jar |
Connection Information Collection
Collect the following information before connecting FineDataLink to the database.
IP address and port number of the database server
Username and password of the database
Schema of the database to be connected
Procedure
1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and choose Create > Data Connection, as shown in the following figure.

2. Set the data connection name. You can also modify the directory of this data connection.
3. Find the ClickHouse data source by searching the data source name or filtering the data source by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure.
4. Click Custom, select the driver uploaded in the "Version and Driver" section, and enter the connection information collected in the section "Connection Information Collection."
Click Click to Connect Database. If the connection is successful, you can select the schema, as shown in the following figure.
5. Click Save to save the data connection.
Data Source Usage
After configuring the data source, you can use it in Scheduled Task. For details, see Overview of Scheduled Task.
After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.
After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.
After configuring the data source, you can use it in Real-Time Task. For details, see Overview of Real-Time Task.
