872596_en-US

liliconcom

DuckDB odbc issue

Hello,

 

I have some issue when I try to connect JMP 17 / 18 and 19EA8 using the DuckDB Windows ODBC.

Does jmp support DuckDB connectivity?

Has anyone tried it?

 

Thank you

 

Reference: https://duckdb.org/docs/stable/clients/odbc/windows

Data AccessWindowsRe: DuckDB odbc issue

I haven't tried DuckDB Windows ODBC but have had an issue connecting JMP 18 to Google BigQuery:ODBC connection not working after elevating from JMP 17 to JMP 18.

What helped was going to a lower version nr. of the same driver. (The issue referenced above is not yet updated, seeing how JPM Tech Support wanted to this themselves.)

Re: DuckDB odbc issue

At least DuckDB isn't mentioned here Data Connectors | JMP.

 

You could use Python in between with JMP18 (query data with integrated Python and convert the dataframe to JMP table). I think in JMP19 you could build your own data connector using JMP's Python integrationExtending Data Connectors with Python: Query Builder Integration and More 

 

Edit: But it might be that the ODBC "should just work". @bryan_boone 

Re: DuckDB odbc issue

Hi,

 

Yes, that's the solution I'll probably consider now.

Re: DuckDB odbc issue

Hello Guillaume,

 

Does the DuckDB connect through the ODBC Manager driver connection test?  Windows and Mac offer varying ways to test the DSN that you create.  The other thing to make sure of is that you installed the 64-bit, and not the 32-bit version.

 

If you write JMP Tech Support I think they'll at least try some common troubleshooting for this driver, even though it is not something we typically support.

 

Brian Corcoran

JMP Development

 

Re: DuckDB odbc issue

Hello Brian,

 

I am using the 64bits version yes.
I will contact the support.

 

Thanks

Re: DuckDB odbc issue

Hello,

 

With the latest duckdb odbc driver release (v1.2.2), it works with jmp 17 (still have issue with jmp 18).

https://github.com/duckdb/duckdb-odbc/pull/46

 

Thanks