Qlik Connector to Clickhouse Database

[Festyan35]

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?

[jprdonnelly]

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.

[Festyan35]

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?