# Clickhouse connection

**URL:** <https://forum.inductiveautomation.com/t/clickhouse-connection/23259>\
**Category:** Ignition\
**Tags:** database\
**Created:** [March 12, 2019, 6:58pm UTC](https://forum.inductiveautomation.com/t/clickhouse-connection/23259 "2019-03-12T18:58:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mjohncox](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mjohncox/32/5702_2.png) [@mjohncox](https://forum.inductiveautomation.com/u/mjohncox)\
**Post date:** [March 12, 2019, 6:58pm UTC](https://forum.inductiveautomation.com/t/clickhouse-connection/23259/1 "2019-03-12T18:58:13Z")

</div>

I would like help connecting Ignition to Clickhouse db. I have installed .jdbc driver and I have heard its postgres like so defaulted driver type and translator that way without success.

---

<div class="post-metadata">

**Author:** ![jsorlie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jsorlie/32/3645_2.png) [@jsorlie](https://forum.inductiveautomation.com/u/jsorlie)\
**Post date:** [August 9, 2019, 5:10pm UTC](https://forum.inductiveautomation.com/t/clickhouse-connection/23259/2 "2019-08-09T17:10:36Z")

</div>

FWIW here is pathway to working solution.

- For 8.x gateways the clickhouse-jdbc-0.1.54.jar available from [javalibs.com](https://javalibs.com/artifact/ru.yandex.clickhouse/clickhouse-jdbc) works with basic driver config per IA documentaion.
- For 7.9.x gateways the pre-built JAR gives errors in gateway log indicating missing Apache dependencies. Work-around is to build the JAR with dependencies directly from GitHub source using following commands:

```auto
git clone https://github.com/yandex/clickhouse-jdbc.git
cd clickhouse-jdbc
mvn package assembly:single -DskipTests=true
cp target/clickhouse-jdbc-0.1-SNAPSHOT-jar-with-dependencies.jar clickhouse-jdbc-with-dependencies.jar

```