​

ODBC/JDBC Connections

​

ODBC Connection

​

System Requirements

• Windows, Linux, or macOS
• Clickhouse ODBC Driver installed
• Network access to Datazone instance

​

Installing Clickhouse ODBC Driver

​

Windows

1. Download the Clickhouse ODBC driver from the official website
2. Run the installer
3. Configure the ODBC data source in Windows ODBC Data Source Administrator

​

Linux

# Ubuntu/Debian
apt-get install clickhouse-odbc

# CentOS/RHEL
yum install clickhouse-odbc

​

macOS

brew install clickhouse-odbc

​

Connection String

Driver={Clickhouse ODBC Driver};Server=app.datazone.co;Port=8123;Database=default;UID=your_username;PWD=your_password;Protocol=http;

​

Configuration Parameters

​

JDBC Connection

​

Requirements

• Java 8 or later
• Clickhouse JDBC driver
• Network access to Datazone instance

​

Maven Dependency

<dependency>
    <groupId>com.clickhouse</groupId>
    <artifactId>clickhouse-jdbc</artifactId>
    <version>0.3.2</version>
</dependency>

​

Connection URL

jdbc:clickhouse://app.datazone.co:8123/default

​

Java Example

String url = "jdbc:clickhouse://app.datazone.co:8123/default";
Properties props = new Properties();
props.setProperty("user", "your_username");
props.setProperty("password", "your_password");
Connection conn = DriverManager.getConnection(url, props);

​

Common Use Cases

​

BI Tool Integration

1. Tableau
   Connection Type: Other Databases (ODBC)
   Driver: Clickhouse ODBC Driver
   
2. Power BI
   Data Source: ODBC
   Driver: Clickhouse ODBC Driver
   
3. Looker
   Dialect: Clickhouse
   Connection: JDBC
   

​

DBeaver Configuration

1. Create new connection
2. Select Clickhouse database
3. Enter connection details:
   JDBC URL: jdbc:clickhouse://app.datazone.co:8123/default
   Username: your_username
   Password: your_password
   

​

Troubleshooting

​

Common Issues and Solutions

1. Connection Timeout
   Error: Connection timeout
   Solutions:
   - Check network connectivity
   - Verify port is open (8123)
   - Check firewall rules
   
2. Authentication Failed
   Error: Authentication failed
   Solutions:
   - Verify credentials
   - Check user permissions
   - Ensure proper protocol (http/https)
   
3. Query Performance
   Issue: Slow queries
   Solutions:
   - Check query execution plan
   - Review data types
   - Use appropriate indexes
   

​

Logging

jdbc:clickhouse://app.datazone.co:8123/default?log_level=TRACE

​

Next Steps

1. Install appropriate drivers for your system
2. Configure your connection using the provided parameters
3. Test the connection with a simple query
4. Integrate with your BI tools or applications