SAS Connection to Duckdb?

[tlorel]

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

Any experience?

[LinusH]

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.

[VincentRejany]

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

[Quentin]

---

@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?

[VincentRejany]

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

[Quentin]

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

[VincentRejany]

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

[AhmedAl_Attar]

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

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

[VincentRejany]

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

[AhmedAl_Attar]

@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