clickhouse custom connector

[Dandelion0124]

Hi all,

We need to use ClickHouse as the data source to connect Power BI while there's no ClickHouse connector in Power BI . So we have found the data connector SDK a great stuff for us and may help us to make the customized ClickHouse connector.

https://github.com/Microsoft/DataConnectors

The connect way we want to use is the Direct query way because we have very big data.

Clickhouse have it own official ODBC driver so I think we can use the ODBC to complete the Direct Query.

https://github.com/Microsoft/DataConnectors/blob/master/docs/odbc.md

I have learned the information in github but still not that very clearly for the way to achieve.

Is it possible for us to complete the ClickHouse connector with the direct query way by using the data connector SDK?

Have someone tried it? Very thanks.

Wenjing Zhao

[Anonymous]

Hi all,

To have access to ClickHouse need to install the official ODBC driver:

1. Download and install the latest installation package from https://github.com/ClickHouse/clickhouse-odbc/releases (32 or 64 bit *.msi file)

2. Run ODBC Data Sources tool and configure connection with ClickHouse

3. Run Power BI Desktop App -> Get Data -> select ODBC source -> select Data Source Name created on previous step.

On 2nd step may appear the error 'ODB driver could not be loaded due to system error code 126..':

to fix it need to install Visual Studio C++ Redistributable libs (see issue System error code 126).

Thanks,

Vladimir

[Anonymous]

Hello,

I'm in the same situation. ClickHouse ODBC driver doesn't work for me, I downloaded, installed and tried variouse versions of it avaliable here: https://github.com/ClickHouse/clickhouse-odbc/releases, but with no luck.

That's why I developed my own connector using Visual Studio and the SDK for custom connector development. So, now I can connect to ClickHouse successfully, but visually it's an ugly connector. I want to make a GUI for my connector to ask for the connection parameters and display the database tables for the user to select. Something like the connectors for MySQL and other databases that already have that.

So, how do I achieve this? Is it possible? Can a GUI be programmed in M? Or do I have to program it in another programming language and then encapsulate the connector code in it?

I have another question regarding this issue, you can look at it and answer me there instead: https://community.powerbi.com/t5/Developer/Graphical-User-Interface-for-Power-BI-Custom-Connector/m-...

Any tips, tricks, workarounds or actual solutions regarding these issues will be much appreciated.

Hope I hear some feedback soon.

Greetings from Venezuela.

[janhavitripurwa]

Hi,

Can you please share how you created custom connector for clickhouse enabling direct query ?

Thanks.

[Anonymous]

Any progress on this? We are in the same situation...

[v-yulgu-msft]

Hi @Dandelion0124,

You can refer to this blog to get started with generating a custom data connector step by step.

And this article provides a sample that define logic that enable Direct Query for an ODBC based connector.

Regards,

Yuliana Gu