DuckDB odbc issue

[#1]

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

[#2]

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.)

[#3]

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 

[#4]

Hi,

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

[#5]

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

[#6]

Hello Brian,

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

Thanks

[#7 · Accepted solution]

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