SAS ODBC

[jen9814]

Is it possible to use a business intelligence tool such as business objects with a SAS dataset?

 

[klaz2002]

jen9814,

I am not sure what you want to do with the Business Objects software, but I can tell you that I have been successful in having other software apps see the SAS dataset via the SAS ODBC add on (free). (Please note: That for SAS to see non-SAS data it needs the ODBC engine a SAS product)

Let me know if you need more info.
Klaz

 

[jen9814]

I have business partners that are not familiar with SAS and I was wondering if BO could be used with a SAS dataset. So far I have been unsuccessful establishing an SAS ODBC connection.

 

[klaz2002]

You could try to use the odbc driver from sas.

http://www.sas.com/apps/demosdownloads/odbcdriver_prod_82_sysdep.jsp?packageID=000166

Read the doc that they supply. If you have a specific problem feel free to ask. I have gotten it to work so that an asp.net web page can view a SAS dataset. I did use the MDAC 2.5 for this purpose. I noticed that the SAS documentation explicitly states that a number of bugs are found in the earlier releases.
Klaz

 

[jen9814]

Thanks for the link. Despite that the SAS documentation regarding the driver configuration is incorrect I was able to use a BI tool with a SAS dataset. Thanks for your help.

 

[ChrisW75]

Any chance you could post the steps you took to get it working for posterity?