ClickHouse
Feature Request: ODBC Driver Support for Windows ARM64 Architecture
Request Overview
Add support for Windows ARM64 architecture to the ClickHouse ODBC driver.
Current Situation
- User is working on integrating ClickHouse with various data tools on a Windows ARM64 laptop
- Attempted to use the existing 64-bit ODBC driver
- Encountered system errors related to driver incompatibility due to ARM64 architecture
Impact
The lack of ARM64 support prevents users with ARM-based Windows devices from:
- Integrating ClickHouse with Windows data tools via ODBC
- Developing and testing ClickHouse applications on increasingly popular ARM-based Windows laptops
- Using ClickHouse in certain environments where ARM64 Windows machines are deployed
Business Justification
- Growing adoption of ARM-based Windows devices in the market
- Expanding the ecosystem compatibility of ClickHouse
- Supporting developers and analysts who use ClickHouse on these emerging platforms
Current Usecase
User's primary need for the ClickHouse ODBC driver is for developing reports using Microsoft Power BI. They cannot use the native connector for ClickHouse available on Power BI since they need to write custom SQL queries and that is where the ODBC tool suffices
This is useful also when running Windows under VMWare Fusion for people using Mac OS X. The only way to have a working PowerBI Desktop + Windows ODBC driver working is to install following drivers:
- https://github.com/ClickHouse/clickhouse-odbc/releases/download/v1.1.10.20210822/clickhouse-odbc-1.1.10-win32.msi
- https://github.com/ClickHouse/clickhouse-odbc/releases/download/v1.1.10.20210822/clickhouse-odbc-1.1.10-win64.msi Seems to work as we end up using the 32bit compatibility layer
This is useful also when running Windows under VMWare Fusion for people using Mac OS X. The only way to have a working PowerBI Desktop + Windows ODBC driver working is to install following drivers:
- https://github.com/ClickHouse/clickhouse-odbc/releases/download/v1.1.10.20210822/clickhouse-odbc-1.1.10-win32.msi
- https://github.com/ClickHouse/clickhouse-odbc/releases/download/v1.1.10.20210822/clickhouse-odbc-1.1.10-win64.msi Seems to work as we end up using the 32bit compatibility layer
@linux-wizard I've not been able to even make the x64 driver run if you have any tips? (I get a system error code 193) - so far my route has to be to use 32bit powerbi with 32bit odbc driver however support for powerbi 32bit will be deprecated on 1st August as welll
Only the 32bit driver will work so far. You can install both. And I've been able to use power I 64bits.
@linux-wizard interesting - I have both installed but I can't create 64bit ODBC entries (error as above). I am able to generate 32bit connections but powerbi 64bit won't recognise this and hardcoding the source gives me the architecture mismatch error (as you'd expect).