03-16-2017 02:36 PM
From Linux SAS we are trying to connect Tableau. We have ODBC license addition to that do we need SAS/Share? If we get SAS/share can we connect directly from Tableau Windows server to Linux SAS?
03-21-2017 12:47 PM
03-16-2017 05:18 PM
It's not clear from which direction you want to go. Is it to connect to SAS from Tableau?
Then your SAS/ACCESS licence can't be used for this.
As you already suggested, you need a SAS/SHARE and a SAS/SHARE*NET licence.
Or, if you are lucky to have SPD Server as your primary storage engine (it comes with a ODBC/JDBC server).
03-18-2017 03:34 AM
03-18-2017 08:04 AM - edited 03-18-2017 08:06 AM
Let me refresh: you want to connect from Tableau to SAS (SAS tables). Right? not the other way around.
In that case, you will only need the ODBC drivers for SAS. Once you get the ODBC driver and the connection working to your SAS tables, you only need to connect Tableau (or any other software) to the ODBC connections:
- Documentation: http://support.sas.com/software/products/odbc/
he SAS Drivers for ODBC are implementations of the ODBC interface standard that enable you to access, manipulate, and update SAS data sources from applications that are ODBC compliant. The SAS Drivers for ODBC connect from an ODBC-compliant application to SAS/SHARE servers, SAS Scalable Performance Data (SPD) Servers, or a local instance of a SAS ODBC server. The SAS Drivers for ODBC are often used with productivity suites such as Microsoft Office. However, they can be used with any application that uses ODBC version 3.5 Core interface level functions. Another ODBC-related product by SAS is SAS/ACCESS® Interface to ODBC. This SAS/ACCESS product enables SAS to act as an ODBC client and access data from third-party databases. For more information, see SAS/ACCESS software.
An alternative for the downloads: on your SAS Depot you will find the drivers as well. Actually they should be already installed in your SAS Servers.
03-20-2017 09:06 AM
Yeah, Tableau can read SAS tables. But we are looking for direct connection from Tableau to SAS. As we don't have SAS/Share, OLEDB options we are looking to use ODBC drivers.
03-20-2017 09:27 AM
You either need SAS/SHARE or SAS SPDS (Scalable Performance Data Server) for access with the SAS ODBC driver.
03-21-2017 12:47 PM
Need further help from the community? Please ask a new question.