topic Re: Qlik Connector to Clickhouse Database in Integration, Extension & APIs

Qlik Connector to Clickhouse Database

Festyan35 — Mon, 26 May 2025 09:00:56 GMT

Hello,

Anyone can help me for setting configuration ODBC Connector to Clickhouse Database.

I have tried it but I am confused in the connection string configuration in the Clickhouse odbc connector.

Has anyone tried it or are there any recommendations for other connectors to retrieve data from the clickhouse database?

Re: Qlik Connector to Clickhouse Database

jprdonnelly — Tue, 27 May 2025 17:43:43 GMT

The ultimate data-connection configuration will be driven by your Clickhouse settings, but for a fairly vanilla self-hosted deployment of Clickhouse, I've found this to be successful.

The below example is from the 64-bit ODBC Admin configuration panel on Windows Server, after installing the Clickhouse drivers and starting to create a System DSN.

Simplified example above is using the default Unicode Clickhouse ODBC driver, which should also work passing through the Direct Access Gateway if you have a Cloud tenant.

You can also use the Qlik REST API connector, which is a bit less intuitive, but has been successfully implemented both in Cloud and client-managed as a 1st-class way to query Clickhouse.

Re: Qlik Connector to Clickhouse Database

Festyan35 — Tue, 27 May 2025 18:13:40 GMT

Thanks for your answer before @jprdonnelly ,

I already used 64-ODBC clickhouse driver but, im confusing to fill Connection String in the qlik cloud. I can't see connection string reference from clickhouse document.

For Qlik REST Connector, are you have tutorial reference for me to get table database from clickhouse database?