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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.