Hi All,
I wonder whether we can use SAS to access the Tableau server data? How will the connection to Tableau server be established? Thank you!
In our company, there are people using Tableau, there is no problem to use SAS data as a data source to Tableau server. While I am trying to use the Tableau data in SAS, and do not know how to build the connection from Tableau server to SAS?
Any comments are welcome!
Jade
Hi @Jade_SAS
I took a look at the Tableau site. I don't see an ODBC driver that enables a user to use the Tableau server as a data source. I could have missed it. If an ODBC 3.5 compliant driver exists it can be used with SAS/ACCESS Interface to ODBC.
If you find a driver, this paper may help you - An Insider's Guide to SAS/ACCESS Interface to ODBC
Best wishes,
Jeff
Thank you!
As long as you have SAS/ACCESS to ODBC installed and licensed.
Thank you! What's the connecting syntax if you happen to know?
Jade
First fix the connection from your server, and test the connection outside SAS.
For syntax, it's all there in the SAS/ACCESS to Relational databases (there is an ODBC section as well).
Connection can be done either by LIBNAME or SQL CONNECT TO.
Thank you, now I have the direction to start!
Hi @Jade_SAS
I took a look at the Tableau site. I don't see an ODBC driver that enables a user to use the Tableau server as a data source. I could have missed it. If an ODBC 3.5 compliant driver exists it can be used with SAS/ACCESS Interface to ODBC.
If you find a driver, this paper may help you - An Insider's Guide to SAS/ACCESS Interface to ODBC
Best wishes,
Jeff
Many thanks to both of you!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.