I was recently speaking with Kat about certified connectors and related status for those connectors – specifically related to Clickhouse, which is listed as a Certified data connector for Sisense. Are there any Sisense customers out there that are using Clickhouse successfully with Sisense? To us, "successfully" would at a minimum include: Being able to connect using a Live Connection for interactive query and aggregation via Sisense Notebooks Being able to load data from Clickhouse into Elasticubes Thanks all!

Hello NUNA,I want to connect the Sisense with Clickhouse DB. can you please share the steps or any detail link ? Thanks

We'll share what we can once we have this sorted out. Ideally we get updated instructions published on the Sisense docs vs. community threads. According to Sisense's website, Clickhouse is a "certified connector" – however it's listed as requiring use of the generic JDBC driver elsewhere in the Sisense docs here. Still waiting on the official response / support for getting properly connected to Clickhouse.

Thanks for the reply. I have been following link :https://docs.sisense.com/main/SisenseLinux/connecting-to-custom-connectors-with-jdbc-drivers.htm#CData according to this link Cdata is official partner of Sisense and you can download the driver from the website. but I unable to find "Clickhouse" in the list.https://www.cdata.com/solutions/bi/sisense/

Clickhouse supports both MySql and PostgreSql wire protocols. Setting these up on the Clickhouse side allows you to use the MySql or Postgres connectors to connect to Clickhouse. As Sisense can go live to Postgres, you can also go live to Clickhouse using the Postgres connector.

Hello,I am able to connect with Clickhouse and create a dashboard on the this data. Simple Steps : 1. Go to Data Sources.2. Click on Other JDBC from the list. 3. Then fill the information : jdbc:clickhouse://"IP of Clickhouse DB":8123/"DatabaseName" <user-name>User Name</user-name> <password>YourPassword</password> com.clickhouse.jdbc.ClickHouseDriverafter this you will able to connect with Clickhouse.

Connecting to Clickhouse | Sisense Community

11 Replies

Replies have been turned off for this discussion

Learner
Data Storage
03-01-2023
Hello NUNA,
I want to connect the Sisense with Clickhouse DB. can you please share the steps or any detail link ?
Thanks
- sisense-nuna
  Cloud Apps
  03-01-2023
  We'll share what we can once we have this sorted out. Ideally we get updated instructions published on the Sisense docs vs. community threads.
  
  According to Sisense's website, Clickhouse is a "certified connector" – however it's listed as requiring use of the generic JDBC driver elsewhere in the Sisense docs here.
  
  Still waiting on the official response / support for getting properly connected to Clickhouse.
  - Learner
    Data Storage
    03-01-2023
    Thanks for the reply.
    I have been following link :
    https://docs.sisense.com/main/SisenseLinux/connecting-to-custom-connectors-with-jdbc-drivers.htm#CData
    
    according to this link Cdata is official partner of Sisense and you can download the driver from the website. but I unable to find "Clickhouse" in the list.
    https://www.cdata.com/solutions/bi/sisense/
alex-frisbie
Cloud Apps
03-02-2023
Clickhouse supports both MySql and PostgreSql wire protocols. Setting these up on the Clickhouse side allows you to use the MySql or Postgres connectors to connect to Clickhouse. As Sisense can go live to Postgres, you can also go live to Clickhouse using the Postgres connector.
- sisense-nuna
  Cloud Apps
  03-06-2023
  MySQL worked for you? We get an error - "text": "{\"error\":{\"moreInfo\":{\"why\":{\"name\":\"InvalidParametersException\",\"message\":\"InvalidParametersException\",\"errorCode\":8,\"errorMessage\":\"Code: 47. DB::Exception: Missing columns: 'TABLE_COMMENT' while processing query: 'SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, multiIf(TABLE_TYPE = 'BASE TABLE', multiIf((TABLE_SCHEMA = 'mysql') OR (TABLE_SCHEMA = 'performance_schema'), 'SYSTEM TABLE', 'TABLE'), TABLE_TYPE = 'TEMPORARY', 'LOCAL_TEMPORARY', TABLE_TYPE) AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM (SELECT \",\"wrongParameter\":null,\"dbSourceErrorMessage\":null,\"trace\":null}},\"code\":22002,\"message\":\"Cannot establish connection with provided parameters.\",\"status\":400,\"httpMessage\":\"Bad Request\"}}"
- sisense-nuna
  Cloud Apps
  03-06-2023
  And if we try from postgres we get "ERROR: ClickHouse doesn't support extended query mechanism"
- sisense-nuna
  Cloud Apps
  03-06-2023
  And if I set "preferQueryMode=simple" it then complains that pg_database doesnt exist.
Learner
Data Storage
03-06-2023
Hello,
I am able to connect with Clickhouse and create a dashboard on the this data.
Simple Steps :
1. Go to Data Sources.
2. Click on Other JDBC from the list.
3. Then fill the information :
jdbc:clickhouse://"IP of Clickhouse DB":8123/"DatabaseName"
<user-name>User Name</user-name>
<password>YourPassword</password>
com.clickhouse.jdbc.ClickHouseDriver
after this you will able to connect with Clickhouse.
Miasm1
Cloud Apps
10-11-2023
Hello,

Many people try to establish Live Connections for interactive queries and aggregations through Sisense Notebooks. Additionally, these users have seamlessly loaded data from Clickhouse into Elasticubes, meeting the specified criteria for success. Recently I am completed Salesforce Admin Certification and now I am working on a project . I faced same query during my certification
DRay
Journey Map
06-10-2025
Hi sisense-nuna,

We have launched our native ClickHouse and we strongly encourage you to use it. It is the only Sisense certified and supported ClickHouse connector. Here is our documentation on it. https://docs.sisense.com/main/SisenseLinux/connecting-to-clickhouse.htm