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!
You can access SAS data sets with the following standard data provider protocols:
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.
You can access SAS data sets with the following standard data provider protocols:
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.
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.
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.