Dear JMP team,
I am trying to set up ClickHouse database connector in JMP. I have successful done it on Windows OS, but I struggle to find the correct clickhouse odbc driver for MaxOS M1 ARM 64. Could you please provide instructions on this?
Tried and failed driver: clickhouse-odbc-1.2.1-Darwin (https://github.com/ClickHouse/clickhouse-odbc)
Hi JMP Support Team,
I was trying to build the driver on mac for clickhouse-odbc to use with JMP.
But getting build errors and have submitted an issue on the Github repo they have.
The other thing I tried was to directly install the driver with “brew install clickhouse-odbc” and it places the driver file in a location that I can browse and link the driver in ODBC manager.
But upon adding the driver, I get following error message.
The third thing I tried was to run :
$conda install -c conda-forge clickhouse-odbc
And that driver automatically shows up in iODBC, I then created a DSN from it and click Test and it comes back Successful.
But then using this DSN in JMP to connect shows Connection Refused error:
I am using Intel mac OS: Mac Sonoma 14.0
Hi Yuan,
Thank you for your inquiry. We have an open ticket with JMP Support investigating this issue, initiated by Tarun Parmar. I will add you to the thread when we receive a response.
Thank you,
Nick
@mzwald
