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