topic Re: SAS Connection to Duckdb? in SAS Data Management

SAS Connection to Duckdb?

tlorel — Tue, 29 Oct 2024 08:00:49 GMT

Can SAS Connect to duckdb? Using odbc or other libname engine?

Any experience?

Re: SAS Connection to Duckdb?

LinusH — Tue, 29 Oct 2024 08:44:01 GMT

No experience, but given the documentation ODBC is your choice if you want some kind of plug-and-play inteface.

Since DUckDB is an OLAP engine, I thought that OLEDB for OLAP should an appropriate choice, but they doesn't seem to support OLEDB.

Re: SAS Connection to Duckdb?

VincentRejany — Wed, 23 Apr 2025 07:54:30 GMT

SAS/ACCESS Interface to DuckDB is coming in our July release, 2025.07.
You can also already use the ODBC or JDBC drivers

Re: SAS Connection to Duckdb?

Quentin — Wed, 23 Apr 2025 14:41:10 GMT

@VincentRejany wrote:
SAS/ACCESS Interface to DuckDB is coming in our July release, 2025.07.
You can also already use the ODBC or JDBC drivers

Do you know if SAS/ACCESS to DuckDB made it into 9.4M9?

Re: SAS Connection to Duckdb?

VincentRejany — Wed, 23 Apr 2025 15:09:08 GMT

It is not planned to be in SAS 9.

That being said, it is still possible to use SAS/ACCESS Interface to ODBC or JDBC and the related driver from DuckDB.

https://duckdb.org/docs/stable/clients/java

https://duckdb.org/docs/stable/clients/odbc/overview

Re: SAS Connection to Duckdb?

Quentin — Wed, 23 Apr 2025 17:28:17 GMT

Interesting. I’m pretty sure I heard rumors of it being on the roadmap for SAS 9. Will have to ask around the SAS 9 desk at innovate. : )

Re: SAS Connection to Duckdb?

VincentRejany — Tue, 13 May 2025 12:25:01 GMT

As one of the PM for SAS 9, I can tell you that it is not planned for SAS 9.4M9

Re: SAS Connection to Duckdb?

AhmedAl_Attar — Tue, 13 May 2025 13:15:04 GMT

@Quentin
Just as an FYI, last year when I tried to use SAS/ACCESS Interface to JDBC to connect to DuckDB, I encountered errors that I didn't encounter when using JDBC to connect to DuckDB from DBeaver Community Edition!

https://communities.sas.com/t5/Administration-and-Deployment/ERROR-Error-retrieving-DatabaseMetaData-java-sql/m-p/917228

Not sure about the ODBC!? I don't have unrestricted privileges on my Windows machine that has SAS software installed on it!

Hope this helps

Re: SAS Connection to Duckdb?

VincentRejany — Fri, 16 May 2025 21:04:53 GMT

See
https://github.com/sassoftware/sas-access-samples/blob/master/SAS%20Viya/JDBC/DuckDB/README.md

Re: SAS Connection to Duckdb?

AhmedAl_Attar — Fri, 16 May 2025 22:19:01 GMT

@VincentRejany

This is great news,

So either SAS Institute must have changed something in SAS/ACCESS Interface to JDBC for SAS Viya and not SAS 9.4, or DuckDB Lab added missing methods implementations that were part of the specifications that SAS Access engine was looking for.

All in all, good news to Viya users