topic Re: Third Party BI Tools supporting SAS in SAS Enterprise Guide

Third Party BI Tools supporting SAS

Aboveland — Wed, 07 Feb 2018 12:45:15 GMT

Hi All,

I am trying to find a list of third party BI tools that i can use to read data from SAS Datasets or SAS Olap Cubes. Can you please help compile a list.

Thanks in advance!

Re: Third Party BI Tools supporting SAS

ChrisHemedinger — Wed, 07 Feb 2018 17:33:20 GMT

You can access SAS data sets with the following standard data provider protocols:

ODBC, using the SAS ODBC driver to access data available in SAS/SHARE or SPDS
OLE DB (Microsoft applications), using the SAS Local OLE DB Provider (for data set files like sas7bdat) or the SAS IOM OLE DB Provider (for connecting to SAS Workspace sessions)
JDBC for Java-based applications, connecting to SAS/SHARE or SAS Workspace sessions

The SAS OLAP Server uses OLE DB for OLAP (ODBO) as its protocol, but access to SAS OLAP server from a non-SAS application isn't strictly supported. SAS Enterprise Guide and SAS Add-In for Microsoft Office use the SAS ODBO provider to interact with SAS OLAP data. You can use SAS language -- PROC SQL and MDX -- to pull data slices from a SAS OLAP cube.

You can also use Python -- via SASPy -- to read SAS data sets from an active SAS session and convert into Python pandas data frames.

Re: Third Party BI Tools supporting SAS

AlanC — Sun, 11 Feb 2018 05:30:35 GMT

Anything that supports ODBC is fair game. I have pulled SAS data into almost every MS Office product, SQL Server, blah, blah, blah. The list I have used them in is in the dozens but perhaps not 100.

OLAP is not my concern but SAS datasets are easy to read using ODBC. What OLAP product are you using? I have worked with SSAS but not the others out there.