Alteryx desktop connect to ClickHouse

[DRubanov3]

 Hi!
Is it possible to connect Alteryx Desctop to Click house data source? When selecting an input data (data source), there is no Click house option, are there any ways to do it?

[BS_THE_ANALYST]

@DRubanov3 how would you be looking to connect to Clickhouse? Is there an ODBC driver or API available? 

ODBC connection guide: https://knowledge.alteryx.com/index/s/article/Connecting-to-an-ODBC-Datasource-1583459849470 

Take note, there's a GENERIC ODBC option that you could configure: https://help.alteryx.com/20241/en/designer/data-sources/odbc-and-oledb-database-connections.html#odb...

However, it doesn't guarantee a connection, I found this in the second article: 

Generic ODBC Option

From the Connect In-DB tool, you can select the Generic ODBC option to attempt a connection to an unsupported data source. This option does not guarantee a successful connection to unsupported data sources

If you want to go down an API connection route, you could use Python (as there's a Python tool within Alteryx) or you could leverage the Download tool and follow along the examples in this article to learn how to connect to an API: https://community.alteryx.com/t5/Engine-Works/APIs-for-Beginners-Integrate-All-the-Systems/ba-p/8074... 

Please note, these types of connection will be processed in memory when the data is pulled into Alteryx. You could get around this by using IN-DB tools (https://help.alteryx.com/20232/en/designer/tools/in-database-overview.html) if Clickhouse was supported but it doesn't look like it is currently. You could vote for the feature to be made available here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Support-ClickHouse-especially-for-in... 

All the best,

BS

[apathetichell]

Use the Clickhouse API... -> https://clickhouse.com/docs/en/cloud/manage/api/api-overview

[DRubanov3]

Thank you! 
I will try these options.
Do you know where the ODBC administrator can be found in the latest versions of the Alteryx?

[nagakavyasri]

@DRubanov3 ODBC connection can be added from Alteryx through: Input tool->Set Up a connection->Data sources->Generic (or) select any ODBC link->click on ODBC Admin in the pop-up.

Or Simply search for 'ODBC' in Search bar of your system, select(preferably 64-bit) add the ODBC connection.