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 flexible way to connect and fetch data, especially in environments like Kubernetes.
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 and provides links to slides and videos.
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 honor that long lost user this article will show how to bring joy to your ClickHouse reporting by pulling data into Excel.
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 has a rich set of native drivers for different environments, but ODBC has a special role. ODBC drivers are a must for integrations with various 3rd-party tools, for example BI tools like Tableau.
20 Sept 2018
This 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 when you have some infrastructure elements already linked to some other data sources or tools that supports ODBC.