You need to enable JavaScript to run this app.
ByteHouse Cloud Data Warehouse Version

ByteHouse Cloud Data Warehouse Version

  • Documentation
    • ByteHouse Cloud Data Warehouse VersionUser guideEcosystemBI toolFineBIConnection Configuration
Copy page
Download PDF
FineBI
Connection Configuration
Copy page
Download PDF
Connection Configuration

This article explains how to install different ByteHouse drivers on Fine BI and complete the connection configuration.

Prerequisites

According to Environment PreparationFine BI installation and datasource configuration is complete.

Connection Information

Driver class

Connection string

Port

Other configurations

MySQL JDBC Driver5

System default driver

Automatic Generation

3306

Your_Database**?enabledTLSProtocols=TLSv1.2,TLSv1.3**

MySQL JDBC Driver8

com.mysql.jdbc.Driver

Automatically generated

3306

ClickHouse JDBC Driver

com.clickhouse.jdbc.ClickHouseDriver

jdbc:clickhouse://<host>:8123/<database_name>?user=bytehouse&password=<API_Key>&ssl=true&compress=0&server_version=54021&server_time_zone=Asia/Shanghai

8123

ByteHouse JDBC Driver

com.bytedance.bytehouse.jdbc.ByteHouseDriver

jdbc:bytehouse://<host>:19000/<database_name>?user=bytehouse&password=<API_Key>&secure=true&compress=true

19000

ByteHouse HTTP JDBC Driver

com.bytedance.jdbc.ByteHouseDriver

jdbc:clickhouse://<host>:8123/<database_name>?user=bytehouse&password=<API_Key>&ssl=true&compress=false&server_version=54021&server_time_zone=Asia/Shanghai

8123

General Configuration:

  • System default username is bytehouse, and the password is <API_Key>.
  • return (<Host> and <API_Key> can be searched or accessed via [Regions and Availability Zones](/docs/6517/76323)Search, or visit **ByteHouse Console - Tenant Management**.
)
  • SSL Tunnel: Activate.

Configure Data Connection

Connect via MySQL JDBC Driver5

  1. Log in to the Fine BI Console, click "manage System>Data Connection>Data Connection Management>Create New Data Connection" to create a new data connection, select the built-in MySQL driver.
  2. According to the configuration information provided, enter the corresponding database information.
    Image

Connect via MySQL JDBC Driver8

  1. Log in to the Fine BI Console, click "manage System>Data Connection>Data Connection Management>Create New Data Connection" to create a new data connection, choose the previously defined database type "MySQL".
  2. According to the configuration information provided, enter the corresponding database information.
    Image

Connect via ClickHouse JDBC Driver

  1. Log in to the Fine BI Console, click "manage System>Data Connection>Data Connection Management>Create New Data Connection" to create a new data connection, select the previously defined database type "ClickHouse".
    Image
  2. According to the configuration information provided, enter the corresponding database information.

Connect via ByteHouse TCP JDBC Driver

  1. Log in to Fine BI Console, click "System Management>Data Connection>Data Connection Management>New Data Connection" to create a new data connection, select the previously defined database type "ByteHouse".
    Image

  2. According to connection information, input the corresponding information for the database.

Connect through ByteHouse HTTP JDBC Driver

  1. Log in to Fine BI Console, click "System Management>Data Connection>Data Connection Management>New Data Connection" to create a new data connection, select the previously defined database type "ByteHouseHTTP".
    Image
  2. According to connection information, input the corresponding information for the database.
Last updated: 2026.03.31 16:16:13