Connecting ClickHouse to External Data Sources using the JDBC Bridge

Connecting ClickHouse to External Data Sources using the JDBC Bridge

ClickHouse is never used as a standalone – it integrates with other data sources and exposes query results to applications. Upstream data for OLAP is sometimes in relational databases like MSQL SQL Server. The JDBC and ODBC bridges provide a…

ClickHouse Data Integration — September 2020 Meetup Report

ClickHouse Data Integration — September 2020 Meetup Report

Our last ClickHouse SF Bay Area meetup was on September 10th and focused on data integration. This turned out to be a popular subject. We had well over 100 signups with 59 people in attendance. This article summarizes the talks…

Connecting Excel to ClickHouse using the Windows ODBC driver

Connecting Excel to ClickHouse using the Windows ODBC driver

Many years ago a wise customer once said, “every report wants to be an Excel spreadsheet when it grows up!” I have always had a soft spot for Excel–it’s one of the most useful programs that Microsoft ever released. To…

New release of ClickHouse ODBC driver

New release of ClickHouse ODBC driver

Today Altinity is pleased to announce an important improvement to the ClickHouse ecosystem. In addition to adding new features to ClickHouse server and maintaining the Grafana plugin, we recently took over responsibility for the ClickHouse ODBC driver. The ClickHouse ecosystem…

Using ODBC with Clickhouse

Using ODBC with Clickhouse

20 Sept 2018This article shows different ways of how you can use ClickHouse in connection with other data sources to make queries use all of ClickHouse optimization features in order to make results come faster. Also, it is good practice…